web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / MS forms > Outlook Cal...
Power Automate
Answered

MS forms > Outlook Calendar Help

(0) ShareShare
ReportReport
Posted on by 64

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:
I have the same question (0)
  • v-yujincui-msft Profile Picture
    on at

    Hi @jdash20 ,

     

    I have made a test for your reference. Please see if it meets your needs

    1. Here is my form.

    vyujincuimsft_0-1646294372265.png

    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')

    vyujincuimsft_2-1646294921348.png

    Result Screenshot:

    vyujincuimsft_4-1646295444556.png

     

     

    Best Regards,

    Charlie Choi

  • jdash20 Profile Picture
    64 on at

    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 😞 

     

    jdash20_1-1646325148312.png

     

    jdash20_2-1646325166774.png

    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:
    jdash20_4-1646325325129.png

     


     

  • v-yujincui-msft Profile Picture
    on at

    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.

    formatdatetime.gif

     

     

    Best Regards,

    Charile Choi

  • jdash20 Profile Picture
    64 on at

    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?  

  • jdash20 Profile Picture
    64 on at

    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?

  • Verified answer
    v-yujincui-msft Profile Picture
    on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard