I want to make the following flow:
How can I make such a flow?
I've never done anything with Powerautomate.
Thanks
Solved! Go to Solution.
You can create a scheduled cloud flow.
Add List rows present in a table and configure it.(my excel is stored in sharepoint)
Add Filter array action to filter out rows whose date is equal to today.
Expression:
formatDateTime(item()?['Date'],'yyyy-MM-dd')
Expression:
formatDateTime(utcNow(),'yyyy-MM-dd')
Expression:
formatDateTime(item()?['Date'],'yyyy-MM-dd')
Save and test the flow.
This is my test excel.
After flow runs, will get rows with date equal to today.
Hope the content above may help you.
Best Regards
If my answer helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can create a scheduled cloud flow.
Add List rows present in a table and configure it.(my excel is stored in sharepoint)
Add Filter array action to filter out rows whose date is equal to today.
Expression:
formatDateTime(item()?['Date'],'yyyy-MM-dd')
Expression:
formatDateTime(utcNow(),'yyyy-MM-dd')
Expression:
formatDateTime(item()?['Date'],'yyyy-MM-dd')
Save and test the flow.
This is my test excel.
After flow runs, will get rows with date equal to today.
Hope the content above may help you.
Best Regards
If my answer helps, then please consider Accept it as the solution to help the other members find it more quickly.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
70 | |
24 | |
18 | |
16 | |
13 |
User | Count |
---|---|
133 | |
43 | |
32 | |
32 | |
28 |