Power Platform Community Forum Thread Details

I have an MS Forms registration that users can select multiple sessions to attend - these are already created in Outlook. I want to send an email to the user with the session appointments they've selected as attachments so they can open and accept. My flow currently sends the email with body including the names of the sessions they've selected, but it doesn't attach the appt files. Flow is below. Any help would be great.

Categories:

General topics

Hi There,

To modify your Power Automate flow to send an email with Outlook session appointments attached based on the selections from an MS Forms submission, follow these steps.

Your flow should already be triggered by the submission of the MS Forms form. Use the ‘Get response details’ action to retrieve the user's selections from the form.

For each session selected by the user, use the ‘Get events (V2)’ action from the Outlook connector. You’ll need to specify criteria to find the correct appointment, likely based on the event's subject or a unique identifier.

Initialize an array variable at the start of your flow to store the appointment details.

For each session appointment retrieved, add its details (including the .ics file content) to this array. You might need to use the 'Get attachment' action if the appointment details are not sufficient.

Use the ‘Send an email (V2)’ action from the Outlook connector. In the body, include the names of the sessions as you're currently doing. In the attachments field, use the array variable. This will attach each appointment to the email.

Test the flow to ensure that it triggers correctly upon form submission. Verify that it correctly retrieves the session appointments and attaches them to the email.

Please give kudos and mark as solution if it helps.

Thanks,

Sandeep Mishra