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

[Anonymous]

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.

[v-LilyW-msft]

Hi @Anonymous 

Thanks for your posting.

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

Best Regards.

[Powerplatform01]

@Anonymous 

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.

[Anonymous]

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.

[Anonymous]

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

I want to filter on multiple columns.

[v-LilyW-msft · Accepted solution]

Hi @Anonymous 

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

Flow in details:

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')))

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

Then save and test.

After flow runs, the Team will receive a message.

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.

[Anonymous]

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.