cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
manu59
Helper I
Helper I

How many rows in Data Operation filter result ?

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 ?

 

 

forum.PNG

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
yashag2255
Dual Super User II
Dual Super User II

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. 

Capture.PNG

 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!

View solution in original post

2 REPLIES 2
yashag2255
Dual Super User II
Dual Super User II

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. 

Capture.PNG

 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!

View solution in original post

manu59
Helper I
Helper I

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 🙂

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,186)