How many rows in Data Operation filter result ?

[manu59]

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

[yashag2255 · Accepted 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!

[manu59]

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 🙂