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:
How do I get file content to attach to the Email Array variable?
Thank you in advance.
Hi @SCastille,
I have different steps with yours:
{
"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.
@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
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2