cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anne_danko
Microsoft
Microsoft

Trigger Flow based on a future date

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

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

3 REPLIES 3
ScottShearer
Super User III
Super User III

@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

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Hi Scott,

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

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.

View solution in original post

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (43,390)