admin管理员组

文章数量:1279234

Regarding Power Automate flow

I have an Excel file with column name city. There are more than 100 city names in that column. Using filter query equals expression, I am able to get three city names, but not able to get more than three equal expression.

Is there any way to get filtered data from Excel if I want more city names to filter?

I'm currently using this code:

or(or(equals(item().City, 'ABCD',equals(item().City, 'EFGH')),equals(item().City, 'IJKL'))

I want more city names to filter.

Regarding Power Automate flow

I have an Excel file with column name city. There are more than 100 city names in that column. Using filter query equals expression, I am able to get three city names, but not able to get more than three equal expression.

Is there any way to get filtered data from Excel if I want more city names to filter?

I'm currently using this code:

or(or(equals(item().City, 'ABCD',equals(item().City, 'EFGH')),equals(item().City, 'IJKL'))

I want more city names to filter.

  • power-automate
Share Improve this question edited Feb 25 at 6:09 marc_s 755k184 gold badges1.4k silver badges1.5k bronze badges asked Feb 25 at 6:03 Sonu HuriawalSonu Huriawal 1 2
  • What’s the problem? If you add one more, do you get an error? Also, “Filter query”, show us what that is exactly. There’s “Filter array” so it’s not clear for me. – Skin Commented Feb 25 at 7:05
  • Hi Thanks for revert. Please help me more I have tried your way and sucessfully get city names. Buy unable to get filtered city names along with all column data as output – Sonu Huriawal Commented Feb 27 at 15:52
Add a comment  | 

1 Answer 1

Reset to default 0

A simple way is to maintain a list of valid cities and then check if your item()?['City'] exists in this list. You can continue to add more cities or even have it read dynamically from some data source.

here's a simple demonstration

本文标签：

版权声明：本文标题：power automate - How to filter query using equal expression on more than three values in PowerAutomate flow - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1741225467a2361775.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。