Flow not filtering correctly

(0) Share

Report

Posted on by GM-22011819-0

Hello,

I have a flow that's not filtering correctly and I'm unsure why

I've created the flow to have an email sent at 10am in the morning and then again at 4pm in the afternoon every day that displays any new office closure entries that have been submitted into the office closure table of the office closure power app I've built. Below is the flow and below that is the output from the last run. The final screen shot shows the table from the app. The entry that was created on 3/5/2025 should not be included in the output and in the email notification. Any ideas as to what I'm missing?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Michael E. Gernaey 53,369 Super User 2025 Season 2 on at

Like (1)

Report

hi

What are the time zones? I am wondering if you need to offset for that (convert the value by timezone)

Was this reply helpful? Yes No
GM-22011819-0 72 on at

Like (0)

Report

Thanks for the reply!

My app registers the created-on date by EST.

I have the recurrence schedule set in EST as well (image below).

Forgive me as I'm still a novice - it seems I have to use the convert time zone action to understand the time zone of my flow as this cannot be identified in settings, etc. Is this correct in terms of your question? If so, what would I include in the Base Time Field?

Was this reply helpful? Yes No
GM-22011819-0 72 on at

Like (0)

Report

I tried breaking the flow out to test each component.

I'm starting with the filter rows expression (shown below):

createdon ge '@{formatDateTime(convertTimeZone(utcNow(), 'UTC', 'Eastern Standard Time', 'yyyy-MM-dd'), 'yyyy-MM-dd')}T00:00:00Z'
and createdon lt '@{formatDateTime(convertTimeZone(addDays(utcNow(), 1), 'UTC', 'Eastern Standard Time', 'yyyy-MM-dd'), 'yyyy-MM-dd')}T00:00:00Z'

My first question is... Shouldn't the output show the entries that were created today 3/6/2025? Instead, it shows "200".

I attempted to add a compose following the list rows but each time I select any dynamic content, an apply to each is automatically added which I do not want given the end goal of sending 1 email with all entries from that day.

Any guidance is appreciated!

Was this reply helpful? Yes No
GM-22011819-0 72 on at

Like (0)

Report

Continuing from my last post...

The Filter array output is also blank. I used the created on is equal to startOfDay(utcNow()) expression.

I'll pause here before continuing to ensure I'm tracking in the right direction.

Thank you in advance!

Was this reply helpful? Yes No