Answered

Trigger Flow based on a future date

(0) Share

Report

Posted on by anne_danko Microsoft Employee

Hi all,

I have created a Flow which is manually triggered by selecting a date from the date picker. Flow is getting items from a SharePoint list which matches with the date selected from the date picker and then sends emails to different parties.

Between the trigger and the "Get items" activity, I have included two "Compose" activities: one to add 8 hours to the date selected from the date picker (to match the date stamp of the date in the SharePoint list), one to format the date to match the time stamp of the SharePoint list.

I then included an additional step to convert the time zone and format the date.

The Flow gets values when selecting a date in the past but does not get any values when selecting a date in the future.

Would you have an idea how to fix this?

Thanks,

Anne

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@anne_danko :

Can you post a screen shot of your Flow? That will be a big help in trying to assist you. The more detail the better.

Scott

Was this reply helpful? Yes No
anne_danko Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Scott,
Sure. When selecting a date in the past, the Flow returns values. When selecting a future date, it returns no values.

Was this reply helpful? Yes No
Verified answer

anne_danko Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Scott,
FYI - this has been resolved. The reason why Flow did not send any emails is the switch to daylight saving time in April. We used to add 8 hours to the date selected from the date picker to match it with the date on the SharePoint tracker. As the clocks are put forward in April, we had to change it to 7 hours.

Was this reply helpful? Yes No