Hi,
I am new developing in this technology.
My flow read an excel file and use a filter data operation to select lines with a special key.
I don't succeed to count how many rows are in my result ?
Thanks
Solved! Go to Solution.
Hey @manu59
Can you share more details? If you are using the unique ID for the filter then it will filter only one row that has that unique ID. But if you are filtering based on a cell value that multiple rows can have, you can use the length function to get the number of rows.
Expression:
length(body('Filter_array'))
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hey @manu59
Can you share more details? If you are using the unique ID for the filter then it will filter only one row that has that unique ID. But if you are filtering based on a cell value that multiple rows can have, you can use the length function to get the number of rows.
Expression:
length(body('Filter_array'))
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @yashag2255
I removed the action "filter array" and created a new one.
Then I clicked "Edit in Advanced mode" and typed the formula @equald(item()?['VIP'],'1')
The flow works successfully
Thanks a lot 🙂
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
65 | |
23 | |
16 | |
15 | |
11 |
User | Count |
---|---|
115 | |
35 | |
30 | |
28 | |
26 |