Newbie - pull date from Form, add days, then create calendar event

Like (0) Share

Report

Posted on 3 Oct 2018 19:50:08 by ryan2k

174

New to Forms and trying to figure things out... appreciate your help!

Setup

I have a Form that triggers the Flow. Within the Form are fields for account name, start date, end date.

Goal

Create a series of Calendar events based on the start date submitted in a Form.

For example, let's say the Form returns value start date for tomorrow. I'd like to create a calendar event for 20 days from the submitted start date. Then another event that's 40 days from the start date, and so on. Can I have the Calendar Event's start time be something like [start date]+20days ... ??? Thank you!

Screen Shot 2018-10-03 at 1.40.43 PM.png

All responses (6)

Answers (1)

ryan2k 174 on 09 Oct 2018 at 21:05:37

Like (0)

Report

Re: Newbie - pull date from Form, add days, then create calendar event

I found the ID by hovering my mouse over the Start Time entry. Thanks!
ryan2k 174 on 09 Oct 2018 at 17:18:36

Like (0)

Report

Re: Newbie - pull date from Form, add days, then create calendar event

Hi @v-yuazh-msft - Thanks for the reply but I don't see a way to copy the Expression of the Dynamic Content "Start Date." It doesn't auto fill the Expression, field, and there's no other field I can find that reveals the expression ID.
v-yuazh-msft on 09 Oct 2018 at 01:06:35

Like (0)

Report
Re: Newbie - pull date from Form, add days, then create calendar event

Hi @ryan2k,

The expression below is the "Start Date"dynamic content of the "Get response details" action.

body('Get_response_details')?['r32910d80a68544ac83c413df00c48e1e']

You could add the "Start Date"dynamic content of the "Get response details" action,then copy the expression of the "Start Date"dynamic content.

Best regards,

Alice
ryan2k 174 on 08 Oct 2018 at 16:42:27

Like (0)

Report
Re: Newbie - pull date from Form, add days, then create calendar event

Thanks so much! I look forward to trying this out, but how did you obtain the id string
'r32910d80a68544ac83c413df00c48e1e'
Verified answer

v-yuazh-msft on 08 Oct 2018 at 09:12:44

Like (0)

Report
Re: Newbie - pull date from Form, add days, then create calendar event

Hi @ryan2k,

I have made a test on my side,please refer to screenshot below to create the flow:

The expression in the Start time field in the Create event action as below:

addDays(body('Get_response_details')?['r32910d80a68544ac83c413df00c48e1e'],20)

The flow would run successfully as below:

Best regards,

Alice
ryan2k 174 on 04 Oct 2018 at 17:24:03

Like (0)

Report

Re: Newbie - pull date from Form, add days, then create calendar event

I've tested the below syntax, but it doesn't seem to like it!