Here is my flow, scheduled to run once a week.
The List row present in a table action has a Filter Query and when I test it, it works as expected.
Here is where I need help. For my condition, I need it to look for a date range for the past seven days. The flow is scheduled to run on Wednesdays, and the date range should be from the Tuesday before to the previous Wednesday. I know I can have this set up to run based on the current date but cannot get the right expression to make it happen. I also tried to initialize variables for the date and get nothing but error messages when trying to save.
I appreciate your help!
