Forms flow - start date to 3 months

[skjellter]

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.

 

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

Anyone have tips?

Cheers,

Skjellter

[efialttes]

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!

[skjellter]

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

I hope you can help 🙂

Thanks!

 

[efialttes · Accepted solution]

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

[efialttes]

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!

[skjellter]

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?

[efialttes]

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!

[skjellter · Accepted solution]

Hello readers,

This eventually became the solution flow.

 

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

 Cheers,