cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ryan2k
Resolver I
Resolver I

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

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

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @ryan2k,

 

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

Capture.PNG

 

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:

Capture.PNG

 

 

Best regards,

Alice

View solution in original post

6 REPLIES 6
ryan2k
Resolver I
Resolver I

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

 

Screen Shot 2018-10-04 at 11.17.03 AM.pngScreen Shot 2018-10-04 at 11.16.40 AM.png

Hi @ryan2k,

 

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

Capture.PNG

 

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:

Capture.PNG

 

 

Best regards,

Alice

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

'r32910d80a68544ac83c413df00c48e1e'

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

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.

 

 Screen Shot 2018-10-09 at 10.48.16 AM.png

 

 

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,124)