You’re offline. This is a read only version of the page.
Announcements
Hi, i have an excel file with several columns.
I want to get in power automate all the rows where inside a certain column i have a cell which contains exactly o partially a string. (it should give me all the rows where cells of the column ColumName contains "STRING" - eg. MYSTRING, STRING, STRINGEFAE, FAE,STRING)
In power automate i use "list all excel rows" and in the filter i use contains(ColumName,'STRING')
the flow only return me the first row matching that filter, why is that???
if i use the "lit all excel rows" without filter and then I apply a condition ColumnName contain STRING, it works just fine, what am i doing wrong?
Thanks
Can you upload a screenshot of your flow where you are able to filter on a Column Name?
Alternatively, have you considered using the Select action? This will return the values from your Excel file from the columns that you select.
Hope this helps!
| If I helped you solve your problem—please mark my post as a solution ✅. Consider giving me a 👍 if you liked my response! |
Share
Report
All responses (
Answers (
10,502
