Power Platform Community Forum Thread Details

Flow to create calendar entry from forms

This may just be me being extremely dense around a syntax issue, but I can't get it to work. Hoping someone here can help...

I have created a flow to pull responses from a microsoft form and create an event in an outlook calendar. As forms do not currently have a time field as it does a date I had a look around to see if this could be included and found this work around: https://powerusers.microsoft.com/t5/General-Flow-Discussion/Using-Forms-to-create-an-Outlook-event-at-a-specific-time/td-p/110563

It's not exactly what I want to do, as I am not interested in sending emails once the event has been created, but close enough that I thought I might be able to adapt it to get the event start and end times entered on to the calendar

Basically it suggests using concat to combine a date and time that can then be entered into the start and end field as an output, and thereby give the correct details on the calendar entry.

My issue is that when I try and enter the concat formula into the compose box, it either won't include the 2 fields I want (one of them disappears after I have selected the other) or I get an invalid formula error.

I did get it working with just the date;

concat(body('Get_response_details')?['rf2dd8e22ccdf4cfa9ecb18df8426421e'])

but this put the events in the calendar as all day affairs and it is likely that a lot of the events I am notified for by form responses will be much shorter, and I dont want to have to manually update each calendar entry from the form as that means I might as well do the whole thing manually and not use the flow at all!

However, when I try to add in the time I either get an invalid formula error, the formula won't save properly, or I get an error when I run the test.

Below is the formula that I thought would work. 'text_1' is the date and 'text_2' is the time. I have tried it with 'text_1:' and 'text_2:', as well and received an error that an unexpected ":" had stopped it from working, so I took them out again.

concat (text_1(body('Get_response_details')?['rf2dd8e22ccdf4cfa9ecb18df8426421e']), text_2(body('Get_response_details')?['r1ae0ae3b78f14fe788a46e1796784c4a']))

I wasn't sure if it would give me the result I want as the 't' and'z' shown either side of the date in the above link are omitted, but I cant even get that far to find out.

Any help on getting this working, or alternative options would be greatly appreciated!

Quick Links

Leaderboard