Power Platform Community Forum Thread Details

Since Forms doesn't allow matrix formatted questions, we have created an Excel Sheet that staff can use to add FY budget information to a Microsoft Form.

The plan was to provide a staff with a formatted excel sheet, and have them complete the form and attach the excel sheet using the upload question.

The issue I am running into is that I cannot get Power Automate to get the data that I want from the table after it has been uploaded and put the numbers into SharePoint.

I know how to add an attachment to a SharePoint list, but I am wanting to pull specific data from the table in the excel workbook and put it in a specific column in SharePoint, Is this possible?

Categories:

Building flows

Power Automate Desktop

Hi @AR-09031950-0,

Yes, it’s possible. Read the uploaded Excel (from the Forms upload folder), pull values from a named table, then write them into SharePoint columns.

Flow pattern that works:

1) Trigger: When a new response is submitted → Get response details.
2) Parse the upload answer (it’s JSON with name, id, driveId, link). For personal forms, files are in the creator’s OneDrive → Apps/Microsoft Forms; for group forms, files are in the group site’s SharePoint → Documents/Apps/Microsoft Forms.
3) Locate the file using the returned id/driveId (don’t rely on the public link). Then either:

Read directly where it is (OneDrive/SharePoint), or
Copy to a processing library you control, then read.

4) Use Excel Online (Business) → Get tables (by file identifier) → List rows present in a table → map values to SharePoint (Create/Update item). Remember the Excel connector defaults to 256 rows; enable Pagination if needed.

Gotchas: Protected sheets, read‑only/locked files, or missing table names break the Excel actions. Ensure .xlsx, a proper named table, and that your flow connection has access to the owner’s OneDrive/Group site.

References:
https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/forms/resolve-file-upload-errors-microsoft-forms

https://petri.com/microsoft-forms-upload-files/

https://ashishcoder.com/courses/microsoft-forms/attachments-location-in-microsoft-form.html

https://www.expiscornovus.com/2024/02/13/retrieve-files-from-upload-file-question/

https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/

✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.