Power Automate - create an event from a Form

%3CLINGO-SUB%20id%3D%22lingo-sub-1334220%22%20slang%3D%22en-US%22%3EPower%20Automate%20-%20create%20an%20event%20from%20a%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1334220%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20Form%20so%20other%20engineers%20could%20submit%20a%20request%20to%20schedule%20a%20testing%20time%20in%20my%20lab.%20In%20the%20form%20they%20are%20asked%20to%20insert%20the%20date%2C%20test%20start%20time%20and%20test%20end%20time.%3C%2FP%3E%3CP%3EI%20created%20a%20flow%20so%20that%20every%20time%20a%20form%20is%20submitted%20it%20creates%20an%20event%20in%20the%20calendar.%3C%2FP%3E%3CP%3Ethe%20problem%20is%20that%20it%20creates%20an%20event%20with%20the%20date%20that%20the%20form%20was%20submitted%20and%20not%20the%20date%20that%20was%20inserted%20by%20the%20user.%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20to%20look%20at%20the%20code%20but%20couldn't%20find%20anything.%3C%2FP%3E%3CP%3Ecan%20you%20please%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ShaniF_0-1587688229077.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186349iA44CADB4AD514D2D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ShaniF_0-1587688229077.png%22%20alt%3D%22ShaniF_0-1587688229077.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ShaniF_1-1587688281825.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186351i9A3CD9D93A6BB8BA%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ShaniF_1-1587688281825.png%22%20alt%3D%22ShaniF_1-1587688281825.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1334220%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1334430%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20-%20create%20an%20event%20from%20a%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1334430%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F635101%22%20target%3D%22_blank%22%3E%40ShaniF%3C%2FA%3EIn%20your%20Microsoft%20Form%20you%20have%203%20Fields.%20Date%2C%20Test%20Start%20Time%20and%20Test%20End%20Time...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Date%20Fields%20Take%20a%20Valid%20date.%3C%2FP%3E%3CP%3EThe%20Start%20Time%20Should%20be%20Like%2012%3A30%3C%2FP%3E%3CP%3EThe%20End%20Time%20Should%20be%20Like%2013%3A30%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20Power%20Automate%20Outlook%20Event%20action%20you%20are%20only%20passing%20the%20Start%20Time%26nbsp%3B%20and%20the%20End%20Time.%26nbsp%3B%20You%20are%20not%20giving%20a%20Date.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Date%20Should%20be%20in%20the%20format%20%26nbsp%3B%3CFONT%3E2020-04-23T05%3A00%3A00%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Your%20Start%20Date%20you%20could%20use%26nbsp%3B%20DateTStartDate%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emake%20sure%20your%20users%20enter%20Time%20in%2024%20hour%20Format%26nbsp%3B%20and%20ensure%20you%20have%20a%20validation%20in%20the%20powerautomate%E2%80%A6%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1347213%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20-%20create%20an%20event%20from%20a%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1347213%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F184117%22%20target%3D%22_blank%22%3E%40Maruthi%20Gadde%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%20this%20was%20helpful.%20I%20was%20able%20to%20add%20the%20date%20to%20the%20event.%20thanks!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi all, 

I created a Form so other engineers could submit a request to schedule a testing time in my lab. In the form they are asked to insert the date, test start time and test end time.

I created a flow so that every time a form is submitted it creates an event in the calendar.

the problem is that it creates an event with the date that the form was submitted and not the date that was inserted by the user. 

I've tried to look at the code but couldn't find anything.

can you please help?

 

 

ShaniF_0-1587688229077.pngShaniF_1-1587688281825.png

 

 

2 Replies
Highlighted

@ShaniFIn your Microsoft Form you have 3 Fields. Date, Test Start Time and Test End Time...

 

The Date Fields Take a Valid date.

The Start Time Should be Like 12:30

The End Time Should be Like 13:30

 

In the Power Automate Outlook Event action you are only passing the Start Time  and the End Time.  You are not giving a Date. 

 

The Date Should be in the format  2020-04-23T05:00:00

 

In Your Start Date you could use  DateTStartDate

 

make sure your users enter Time in 24 hour Format  and ensure you have a validation in the powerautomate… 

Highlighted

@Maruthi Gadde 

Thanks! this was helpful. I was able to add the date to the event. thanks!