Answered

MS forms > Outlook Calendar Help

(0) Share

Report

Posted on by jdash20

Hello, I'm looking for assistance with powerautomate. I built an MS Form that has a Date, Start Time & End Time (among other fields), and I'm trying to somehow make it so that by submitting this MS Form a calendar invite will be sent to a shared calendar as well as the submitter of the MS Form. Is this possible?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @jdash20 ,

I have made a test for your reference. Please see if it meets your needs
1. Here is my form.
2. Create a flow.
formatDateTime(concat(outputs('Get_response_details')?['body/ra096b6de3cad4535ad3326b089e2a0bb'],' ',outputs('Get_response_details')?['body/rd26f894b042c497a932c03edcd30e6df']),'yyyy-MM-ddTHH:mm:ss')
formatDateTime(concat(outputs('Get_response_details')?['body/ra096b6de3cad4535ad3326b089e2a0bb'],' ',outputs('Get_response_details')?['body/r1153b2dc261c4b28a9aaaa44982ec86a']),'yyyy-MM-ddTHH:mm:ss')
Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
jdash20 68 on at

Like (0)

Report
Copy link

Link copied!

listed below are the 3 pieces of the form i'm using and then the same format you used in your automate. I'm getting an error 😞

formatDateTime(concat(outputs('Get_response_details')?['body/Appointment Date Requested'],' ',outputs('Get_response_details')?['body/Appointment Start Time']),'yyyy-MM-ddTHH:mm:ss')

formatDateTime(concat(outputs('Get_response_details')?['body/Appointment Date Requested'],' ',outputs('Get_response_details')?['body/Appointment End Time']),'yyyy-MM-ddTHH:mm:ss')

Error:

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

Like (0)

Report
Copy link

Link copied!

Hi @jdash20 ，

Are you using the question name in the expression? If so, you should reference the dynamic content.
In addition, you could add Compose Action to check if the outputs is correct.

Best Regards,
Charile Choi

Was this reply helpful? Yes No
jdash20 68 on at

Like (0)

Report
Copy link

Link copied!

That did the trick, thanks so much! By chance do you know if there is a way for this flow to see if there is already an appointment booked on the calendar in question and if it is have a standard reply saying not available or something?

Was this reply helpful? Yes No
jdash20 68 on at

Like (0)

Report
Copy link

Link copied!

Do you know if there is a way for this automate to check the calendar and only show available appointments or it books an appt on the calendar when there is already an appt to do something different like tell the requester a pre-defined message?

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @jdash20 ,

Sorry for getting back to you late, I am sorry that I could only focus one issue in a single case, you could open a new case for you issue. Thanks for your cooperation.

Best Regards,
Charlie Choi

Was this reply helpful? Yes No