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

delay until - based on existing field + x

Hi folks,

 

I think the answer to this is 'not at the moment' but is there any way to pause or delay the next steup until a dynamic period of time is reached?

 

example. 

 - SP form submitted for attending professional development - all approvals have taken place etc etc. 

          - this form contains a start and end date field where the prof dev will take place.

I want the flow to calculate a delay based on the END DATE + (7 days) then send an email to the attendee to submit their reflection.

 

Possible?

 

Thanks in advance.

Corey

 

2 REPLIES 2
v-monli-msft
Community Support
Community Support

Hi @ckemp,

 

This actually can be done using the "addhours" Date function in Workflow Definition Language. For your information:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-monli-msft

Thank you for your reponse.

 

Could I run this syntax by you? Im not familiar with logicapps...

 

@{addminutes((END DATE DYNAMIC FIELD),1)}

 

Manage your flows _ Microsoft Flow.png

 

When running it as it is, error returns:  

Unable to process template language expressions in action 'Delay_until' inputs at line '1' and column '2083': 'String was not recognized as a valid DateTime.'.

 

The date format which is returned in the output of "DATE TO" is:   2017-06-14T23:42:00Z 

 

Thank you

 

Corey

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,368)