Conditional Function based on Excel table with a Query Filter and using date range

(0) Share

Report

Posted on by ABoyNamedSue

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!

All responses (6)

Answers (1)

ABoyNamedSue 46 on at

Like (0)

Report

Re: Conditional Function based on Excel table with a Query Filter and using date range

Thanks! Tested it and success!
Verified answer

lbendlin 8,045 Super User 2025 Season 1 on at

Like (1)

Report
Re: Conditional Function based on Excel table with a Query Filter and using date range

sorry about that.

convertFromUtc(addDays(utcNow(),-7),'Central Standard Time','yyyy-MM-dd')
ABoyNamedSue 46 on at

Like (0)

Report

Re: Conditional Function based on Excel table with a Query Filter and using date range

Using that expression gives me an error message.
lbendlin 8,045 Super User 2025 Season 1 on at

Like (0)

Report
Re: Conditional Function based on Excel table with a Query Filter and using date range

convertFromUtc(utcNow()-7,'Central Standard Time','yyyy-MM-dd')
ABoyNamedSue 46 on at

Like (0)

Report

Re: Conditional Function based on Excel table with a Query Filter and using date range

Hi @lbendlin,
I am UTC-6. The automation I am running is goes to all US states and territories. I have it scheduled to run at 1300 local time, so it is not too early or late for the majority of the time zones (sorry people in Guam). If I use UTC, would it not be the next day and throw off the dates?
lbendlin 8,045 Super User 2025 Season 1 on at

Like (0)

Report

Re: Conditional Function based on Excel table with a Query Filter and using date range

Please define what you mean by "current date". UTC or local timezone?