Answered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous
Thanks for your posting.
What do you want to use filtered rows data for? Send a email or other operations?
Best Regards.

Was this reply helpful? Yes No
Powerplatform01 386 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Sorry, but the video you have shared above doesn't help me in filtering using multiple conditions.
I want to filter on multiple columns.

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No