cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
S_D_Andrews
Frequent Visitor

QUESTION: Scheduled Daily workflow that needs to check Dates

Hi all,

 

I have a Power Automate Flow that's plugged into a SharePoint list has several columns that are of a date/time nature.  I've been asked to build a workflow that runs on a daily basis.  It needs to check the dates in SharePoint list and upon encountering a date that is three weeks away should take a series of actions.

 

In building the workflow, I've got the schedule working as required and I also have the actions that are required once the condition has been met.  What I'm having trouble with is how I would configure the workflow to detect that it is three weeks out from a date specified within the SharePoint list.

 

If anyone can point me in the right direction I'd be most grateful

Best

Steve

1 ACCEPTED SOLUTION

Accepted Solutions
efialttes
Super User
Super User

Hi!

You mean to take flow execution date, add 21 days (3 weeks) and filter all items whose date column X matches the calculated date?

If so, I would recommend to use "Get future time" action (There is a 'Get past time' also).

efialttes_0-1600712741799.png

THen define an ODATA filter on your 'Get items' action block. GReat tutorial here with all steps

https://baddaz.com/filtering-a-list-of-records-in-flow-based-on-todays-date-5a80292b366d

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

1 REPLY 1
efialttes
Super User
Super User

Hi!

You mean to take flow execution date, add 21 days (3 weeks) and filter all items whose date column X matches the calculated date?

If so, I would recommend to use "Get future time" action (There is a 'Get past time' also).

efialttes_0-1600712741799.png

THen define an ODATA filter on your 'Get items' action block. GReat tutorial here with all steps

https://baddaz.com/filtering-a-list-of-records-in-flow-based-on-todays-date-5a80292b366d

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,077)