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

Forms flow - start date to 3 months

Hi all,

 

I recently started with Power Automate.

I have created a Forms that contains information about a candidate's deal. For example, it states on which day the candidate starts.

I want to set up PA so that I receive an email notification on the day the candidate works for 3 months.

Schermafbeelding 2020-09-18 om 09.58.08.png

I think I have to do something with a condition but I can't figure it out.

Anyone have tips?

 

Cheers,

 

Skjellter

2 ACCEPTED SOLUTIONS

Accepted Solutions

Excellent!

So your first challenge, according to the example, is that you need to add 3 months to current input date (2020-09-17), right? Then , on the new calculated date send some sort of reminder email, right?

 

If so, let's concentrate on the first step, and assume we use addDays() WDL function to add 90 days

https://docs.microsoft.com/es-es/azure/logic-apps/workflow-definition-language-functions-reference#a...

Would this approach match your requirements? Or you need the result to be 2020-12-17?

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

skjellter
Frequent Visitor

Hello readers,

This eventually became the solution flow.

 

Schermafbeelding 2020-09-28 om 17.36.19.png

 

with formating: formatDateTime(addDays(outputs('Opstellen'),90),'yyyy-MM-dd')

 

 Cheers,

 

 

 

View solution in original post

7 REPLIES 7
efialttes
Super User
Super User

Hi!

Can you share a screenshot from your current flow design, and also an example of the date format that is received from Forms response?

Thanx!



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!



@efialttes 

To explain it even better.
I get a start date from Forms, for example below. 3 months must be added to this date, if it is that day. Then I have to receive an email that the candidate is working for 3 months.

 

Schermafbeelding 2020-09-18 om 10.35.23.png

 

I hope you can help 🙂

 

Thanks!

Excellent!

So your first challenge, according to the example, is that you need to add 3 months to current input date (2020-09-17), right? Then , on the new calculated date send some sort of reminder email, right?

 

If so, let's concentrate on the first step, and assume we use addDays() WDL function to add 90 days

https://docs.microsoft.com/es-es/azure/logic-apps/workflow-definition-language-functions-reference#a...

Would this approach match your requirements? Or you need the result to be 2020-12-17?

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!



Now, on the second challenge.

So you need to wait for the calculated day to send a reminder email: some sort of "Today, XXX has been working for 3 months since its first day in the company", right?

If so, I believe you need to store the info from Forms response somewhere (Excel table, Sharepoint List) and design a second Flow of tipe Recurrence, frequency daily, that would read all the list elements, and for each one will compare calculated date with current executed date. A reminder will be sent for every match.

 

The reason for a second flow is, as far as I know, max Flow execution time is 30 days, so you cannot implement all in one flow (the one that is triggered when a Forms response is received) and add a Delay action block for 3 months.

 

Does the suggested strategy match your requirements?

THanx!



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!



Hi @efialttes,

 

Thanks for the input! I stored all the info in a sharepoint list from Forms and designed a flow of the type resurrence. 

 

The only thing is the current input date (timestamp) is variable. How can i set up PA so i get something like:

 

addDays('Startdate'(), 90, yyyy-MM-dd)

 

'Startdate' is given in a sharepoint list

 

Is something like this possible?

 

 

Hi!

Yes, you make date calculations taking a date stored on a Sharepoint list item, and take decissions based on the result.

Please let us know your progress, if you face any blocking issue remember to share a screenshot with the current flow design in this same thread.

Cheers!

 
 

 

 



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!



skjellter
Frequent Visitor

Hello readers,

This eventually became the solution flow.

 

Schermafbeelding 2020-09-28 om 17.36.19.png

 

with formating: formatDateTime(addDays(outputs('Opstellen'),90),'yyyy-MM-dd')

 

 Cheers,

 

 

 

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.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,644)