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.
User | Count |
---|---|
88 | |
37 | |
26 | |
13 | |
13 |
User | Count |
---|---|
127 | |
54 | |
38 | |
24 | |
21 |