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

Community site session details

Session Id : d73dbkNdyq/R1rZ1TyRJLm
Power Automate - Building Flows
Answered

Group Form Adding Form Attachments to Email

Like (0) ShareShare
ReportReport
Posted on 8 May 2024 16:40:32 by 44

I have a flow who's trigger is a group form.  It works well.  But now I want to add attachments submitted with the form to emails.  I have it set up to add the attachment to SharePoint using a concat expression in Get file content using path. This works.  But, if I add that output to the append to array variable, Flow Checker throws an error:  Enter a valid json.

 

Flow:

SCastille_0-1715186180940.png

 

How do I get file content to attach to the Email Array variable?

 

Thank you in advance.

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on 09 May 2024 at 07:29:20
    Re: Group Form Adding Form Attachments to Email

    Hi @SCastille,

    I have different steps with yours:

    vqiaqimsft_0-1715239545267.png

    {
     "type": "array",
     "items": {
     "type": "object",
     "properties": {
     "name": {
     "type": "string"
     },
     "link": {
     "type": "string"
     },
     "id": {
     "type": "string"
     },
     "type": {},
     "size": {
     "type": "integer"
     },
     "referenceId": {
     "type": "string"
     },
     "driveId": {
     "type": "string"
     },
     "status": {
     "type": "integer"
     },
     "uploadSessionUrl": {}
     },
     "required": [
     "name",
     "link",
     "id",
     "type",
     "size",
     "referenceId",
     "driveId",
     "status",
     "uploadSessionUrl"
     ]
     }
    }

    Then Apply to each,  For each item in the body of the file question,

    Get file content using path: to get the file content of individual items from SharePoint document library. Select the appropriate SharePoint site/ Group where the form is and then navigate to the path.

     

    I think the json format should be:

    {
    
     "Name": items('Apply_to_each')['name'],
    
     "ContentBytes": body('Get_file_content_using_path')['$content']
    
    }

    On your side, you need to capture the name from the apply to each, and file content from the get file content using path.

  • creativeopinion Profile Picture
    10,466 Super User 2025 Season 2 on 08 May 2024 at 16:50:26
    Re: Group Form Adding Form Attachments to Email

    @SCastille You might find these YT Tutorials helpful: 

     

    How to Get Microsoft Form File Uploads Attached to an Email đź“§

     

    In this Microsoft Power Automate Tutorial I’m going to cover where file uploads from your Microsoft Forms are saved. I’ll also show you how attach the uploaded files to an email and how to dynamically name the files and customize the recipient of the email based on the selections made in your Microsoft Form. I will also cover how to handle responses that don’t include any file uploads.

     

    IN THIS VIDEO:

    ‌✅‌ Two types of MS Forms

    ‌✅‌ Where Microsoft Personal (OneDrive) Form File Uploads are Saved

    ‌✅‌ Where Microsoft Group Form File Uploads are Saved

    ‌✅‌ How to Add a File Upload Question to an MS Form

    ‌✅‌ How to get a Microsoft Form ID

    ‌✅‌ How to get a Microsoft Form Response

    ‌✅‌ How to Get the Dynamic Content Microsoft Form File Upload Content

    ‌✅‌ How to handle Single and Multiple Microsoft Form File Uploads

    ‌✅‌ How to use a Scope action to Organize and Group Your Flow Actions

    ‌✅‌ How to Get the File Content from an MS Form File Upload

    ‌✅‌ How to Collect All Files Uploaded to a MS Form and Attach to an Email

    ‌✅‌ How to Handle MS Form Response When a File Isn’t Uploaded

    ‌✅‌ How to Create an Email Key

    ‌✅‌ How to Send an Email to a Specific Recipient Based on Form Selection

    ‌✅‌ How to Create a Dynamic Output Based on Form Selection

     

    ----

    How to Get a Microsoft Form RSVP Response into a SharePoint List

     

    In this Microsoft Power Automate tutorial, I’ll show you how to get your Microsoft Form responses into SharePoint. I’ll cover how to build a Microsoft form with conditional fields by using branching. You’ll learn how to format your multiple choice responses for a SharePoint multi-choice column as well as converting it to text. I’ll also show you how to take a text response and convert it to a number with a switch action and with an expression. After adding the response to SharePoint, we’ll send the user an email confirmation with all the details of their form submission.

     

    IN THIS VIDEO:

    âś… How to get a Microsoft Form Response into SharePoint

    âś… How to get a Microsoft Form ID

    âś… How to get a Microsoft Form response

    âś… How to Build a Microsoft Form with Conditional Fields

    âś… How to used Branching in Microsoft Forms

    âś… How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column

    âś… How to parse a Microsoft Form multiple choice response as string of text

    âś… How to convert a text response to a number

    âś… How to use the Switch action

    âś… How to create a custom email confirmation for a Microsoft Form submission

    âś… How to Create a Custom View in a SharePoint list

    âś… How to use the Compose Action

    âś… How to write Power Automate Expressions

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a 👍 if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete