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

(0) Share

Report

Posted on 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 at

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 at

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 at

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 at

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 at

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 at

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!