cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Dual Super User III
Dual Super User III

Re: Forms flow - start date to 3 months

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

Highlighted
Frequent Visitor

Re: Forms flow - start date to 3 months

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
Highlighted
Dual Super User III
Dual Super User III

Re: Forms flow - start date to 3 months

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!



Highlighted
Frequent Visitor

Re: Forms flow - start date to 3 months

@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!

Highlighted
Dual Super User III
Dual Super User III

Re: Forms flow - start date to 3 months

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

Highlighted
Dual Super User III
Dual Super User III

Re: Forms flow - start date to 3 months

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!



Highlighted
Frequent Visitor

Re: Forms flow - start date to 3 months

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?

 

 

Highlighted
Dual Super User III
Dual Super User III

Re: Forms flow - start date to 3 months

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!



Highlighted
Frequent Visitor

Re: Forms flow - start date to 3 months

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (7,376)