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

(0) Share

Report

Posted on by ryan2k

176

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

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

ryan2k 176 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
ryan2k 176 on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
ryan2k 176 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ryan2k 176 on at

Like (0)

Report
Copy link

Link copied!

I found the ID by hovering my mouse over the Start Time entry. Thanks!

Was this reply helpful? Yes No