web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How many rows in Data ...

Power Automate

Unanswered

How many rows in Data Operation filter result ?

(0) Share

Report

Report

Posted on by manu59

52

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

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
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!

Was this reply helpful? Yes No
manu59 52 on at

Like (1)

Report

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 🙂

Was this reply helpful? Yes No

Join the conversation