cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chandni
Regular Visitor

Filter Excel and retrieve row count

Hi,

I want to filter an excel file but I am receiving an error. I want to filter 3 columns (Road = B, Load/Empty = E, Car Mech Fleet ID = 5852) After applying that I want to count the rows.

Is it possible by power automate desktop ?

 

Test.PNG

 

test 1.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @Chandni :

Please try this solution:

Firstly, convert target data into table

v-bofeng-msft_0-1606383687182.png

 

Secondly, Because flow cannot recognize "/" and spaces, you need to modify these two field names

v-bofeng-msft_1-1606383687183.png

 

Thirdly, Put this excel file into OneDrive

Finally, please try this flow.

v-bofeng-msft_2-1606383687189.png

 

Reference Expression

1\

@and(equals(item()?['Road'], 'B'),equals(item()?['LoadEmpty'], 'E'),equals(item()?['CarMachFleetID'], '5852'))

2\

length(body('Filter_array'))

Result

v-bofeng-msft_3-1606383687191.png

 

Best Regards,

Bof

View solution in original post

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @Chandni :

Please try this solution:

Firstly, convert target data into table

v-bofeng-msft_0-1606383687182.png

 

Secondly, Because flow cannot recognize "/" and spaces, you need to modify these two field names

v-bofeng-msft_1-1606383687183.png

 

Thirdly, Put this excel file into OneDrive

Finally, please try this flow.

v-bofeng-msft_2-1606383687189.png

 

Reference Expression

1\

@and(equals(item()?['Road'], 'B'),equals(item()?['LoadEmpty'], 'E'),equals(item()?['CarMachFleetID'], '5852'))

2\

length(body('Filter_array'))

Result

v-bofeng-msft_3-1606383687191.png

 

Best Regards,

Bof

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,306)