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.
Solved! Go to 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.
Hi @Anonymous
Thanks for your posting.
What do you want to use filtered rows data for? Send a email or other operations?
Best Regards.
@Anonymous
You can watch this video to resolve your issue.Also request you to please subscribe this channel.
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 @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.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
31 | |
30 | |
27 | |
18 | |
11 |
User | Count |
---|---|
67 | |
59 | |
29 | |
27 | |
25 |