You’re offline. This is a read only version of the page.
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?
I have solved the Task as follows.
This flow adds members from an excel file to a Teams group.
I solved it. Sorry for the silly question.
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:
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,
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?
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,
How can I find a file through an id? The "Get Tables" requires a path to file.
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,
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.
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.
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,
#1
WarrenBelz
146,653
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (