I am trying to schedule a flow which will trigger on every Sunday 8pm local time.
I need help to filter from previous Saturday to Friday (total 7 days)
Column name: runningDate
1.When flow triggers on sunday
2.Should filter previous Saturday to Friday dates.
Note : flow should not consider current week Saturday and Sunday
You can use a Recurrence trigger and configure it to run the Flow every Sunday at your specified time.
Is your data stored in SharePoint? If not, can you tell me where your data is stored?
Also, are you saying that you only want to retrieve data from the previous Saturday through Friday .
Yes, dates are stored in share point list and yes I only want to retrieve data from the previous Saturday through Friday .
Please see my example below and let me know if you have any questions. Please note the single quotes around Start Date and End Date in the Filter query.
So many events happening this month - don't miss out!
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.