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

How to get values from 'filter array' data operation ?

I have a list of rows from excel. I am using filter array data operation on this list of rows by applying a condition and I get an output object 'filter array'. I want to use the values from the filter array output. How do I access the filtered rows' data.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @msnc_leet 

Thank you for your responding.

If you want to send a message use filtered rows data, you can create html table to show the rows data.

I set up a flow, you can refer to:

This is my test excel

vLilyWmsft_0-1627873548053.png

Flow in details:

vLilyWmsft_1-1627873548064.png

My filter condition is that date is equal to today, and email ids is equal to email address.

@and(equals(item()?['email ids'], item()?['email address']),equals(formatDateTime(item()?['date'], 'yyyy-MM-dd'), formatDateTime(utcNow(), 'yyyy-MM-dd')))

vLilyWmsft_2-1627873548071.png

After filter array, you can add a Create HTML table action

vLilyWmsft_3-1627873548074.png

vLilyWmsft_4-1627873548077.png

Then save and test.

After flow runs, the Team will receive a message.

vLilyWmsft_5-1627873548078.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
v-LilyW-msft
Community Support
Community Support

Hi @msnc_leet 

Thanks for your posting.

What do you want to use filtered rows data for? Send a email or other operations?

Best Regards.

Powerplatform01
Post Patron
Post Patron

@msnc_leet 

You can watch this video to resolve your issue.Also request you to please subscribe this channel.

https://youtu.be/NLEMPn-T3ns

Let me know if you need further help.

I want to use that whole row and extract the column data in that row to append a string variable which I have already created at a parent level. 

 

I have created a sheet which has names and email ids of 10 employees.

They all submit a form daily as an attendance.

I run a scheduled flow everyday at 9:20 AM.

So, I want to collect all their form responses as a single string and send that to teams as a message at 9:20 AM everyday.

I have written a flow already which gets the form responses and inserts them into an excel sheet.

--

Finally I want to send a message something like :

--

Emp1 : Not yet filled the form.

Emp2 : Tokyo Office.

Emp3 : Work from home

Emp4 : Work from home.

.

.

Emp10 : Not yet filled the form.

----

 

How do I achieve this ?

 

My work till now has been to first query all the rows from the form responses sheet I created earlier based on the current date.

 

I want to filter the rows from the excel sheet based on two conditions :

1. The date should be today.

2. The email address should be present in the list of email ids which I have already created in a separate sheet.

 

Thank You.

 

 

 

 

Sorry, but the video you have shared above doesn't help me in filtering using multiple conditions.

I want to filter on multiple columns.

Hi @msnc_leet 

Thank you for your responding.

If you want to send a message use filtered rows data, you can create html table to show the rows data.

I set up a flow, you can refer to:

This is my test excel

vLilyWmsft_0-1627873548053.png

Flow in details:

vLilyWmsft_1-1627873548064.png

My filter condition is that date is equal to today, and email ids is equal to email address.

@and(equals(item()?['email ids'], item()?['email address']),equals(formatDateTime(item()?['date'], 'yyyy-MM-dd'), formatDateTime(utcNow(), 'yyyy-MM-dd')))

vLilyWmsft_2-1627873548071.png

After filter array, you can add a Create HTML table action

vLilyWmsft_3-1627873548074.png

vLilyWmsft_4-1627873548077.png

Then save and test.

After flow runs, the Team will receive a message.

vLilyWmsft_5-1627873548078.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thank you very much for the solution. I have tried in my own method and it has worked. have actually used the output from the 'filter array' operation on a 'parse json' operation to get the 'id' of the first element in this 'filter array' output. Then, I used this 'id' to just get a row from the excel sheet I have to get the details about their work location and their name. Anyways, I shall keep your method as an alternative to my solution.

 

Anyways, thank you very much for sharing how to use the "create HTML table" option.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (1,844)