Forms flow - start date to 3 months

(0) Share

Report

Posted on by 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.

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

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (2)

Sort by

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
skjellter 18 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

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#addDays

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

Hope this helps

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
skjellter 18 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Verified answer

skjellter 18 on at

Like (1)

Report
Copy link

Link copied!

Hello readers,
This eventually became the solution flow.

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

Cheers,

Was this reply helpful? Yes No