In my previous flow, I used the 'body' output from Get Response Details in the Create file step with the extension .xlsx. However, the output looked like this:
I believe the issue was caused by this format because the created file wasn’t recognized as a valid .xlsx
file. It seems I needed to use the json
method, as you suggested, to parse the content or something similar. However, the content of this output wasn't what I wanted - it differed from what I get when I manually download the Excel file from Forms.
So, I tried another way, without using json or get response details, just simply using Send an HTTP request to SharePoint to download whole file and solved it.
Your suggestion of checking the input and output really helped me a lot, thanks!
Have you considered utilizing the built-in functionality in MS Forms that syncs responses to a workbook that you can access via OneDrive or SharePoint (depending on the type of form you've created)?
In the meantime, you may be interested in these YT Tutorials:
----
How to Get Microsoft Form File Uploads Attached to an Email 📧
Are you stumped when it comes to handling a response without any file uploads?
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