cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anne_danko
Level: Powered On

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
anne_danko
Level: Powered On

Re: Trigger Flow based on a future date

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
Super User
Super User

Re: Trigger Flow based on a future date

@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
anne_danko
Level: Powered On

Re: Trigger Flow based on a future date

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

anne_danko
Level: Powered On

Re: Trigger Flow based on a future date

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (3,891)