Answered

Get file content from MS forms file upload

(0) Share

Report

Posted on by Community Power Pla...

Hello guys
I have a form that asks for a file upload. In my power automate flow the response JSON is parsed. (Flow: When a new response is submitted --> Get response details --> Parse JSON). I now have the link to a sharepoint file. My question now: What can I do with the parsed information? Is it possible to get the file data from the link?

Example: If I were to get the file from the link. Lets say its an excel document. Would It be possible to loop over the table entries?

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

v-jefferni on at

Like (1)

Report

Hi @Anonymous ,

First step, you will be able to get file path using file name and use the path in a 'get file metadata using path' action, and then you can get the file Id.

Solved: MS Forms file uploads directly to the SharePoint w... - Power Platform Community (microsoft.com)

The second step is more complicated since the files would be with dynamic names I suppose. You will need to 'get tables' from dynamic files using file Id and 'list rows' from the table that flow get from the excel file. The outputs of List rows are arrays, they could be used in Apply to each to be looped over. However, there would not be columns for you to select from dynamic contents. You will have to manually write expressions items('Apply_to_each')?['ColumnName'] to reference the value of different columns.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks for the reply. The problem is, if I use the sharepoint connector "Get file metadata" I need a link the the sharepoint folder. But from the JSON I get the direct link to the file.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

File link cannot be used to get the file id, which is necessary to be used in Excel's Get tables action.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

How can I find a file through an id? The "Get Tables" requires a path to file.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

It requires file identifier than file path. It's just displaying the file path for checking if the correct file is selected. The internal parameter is file identifier. Please check below thread:

Solved: Dynamic Filename: List Rows from Excel Table - Power Platform Community (microsoft.com)

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Oh okay, if I wanted this to be automated just from the forms then I would need to know a lot of additional information that a user had to specify. Right?

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

Actually, you only need to know which is the specific file that uploaded from MS Forms and saved in SharePoint, and this is the File identifier.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I thank you very much. I am almost there. Can you help me with one further problem? When I try to retrieve the tables it does not seem to find any tables in the excel document. I dont get any errors just an empty value:
[]
Do you have any tips?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I solved it. Sorry for the silly question.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

I have solved the Task as follows.

This flow adds members from an excel file to a Teams group.

Was this reply helpful? Yes No