
Announcements
Hi Guys,
I am building a flow at the moment and a bit stuck.
I have a manual trigger flow with two file inputs. My aim is to allow user to upload excel file from their local device with the file input. Once the file has been uploaded, the flow would extract the content of each excel file into two variable list in memory.
Then I will create a new excel in share point and populate the new excel file with contents of both lists.
Note: the columns of the uploaded excel are the same.
I am stuck at knowing which action to use to extract the excel into the variable list. please if i can get an example on this.
Hi @apatrick ,
To put it simply, you need to create temporary files in a cloud drive like SharePoint, then read them using List rows action. Please refer to below thread:
Solved: Power Automate Parse output from blob content - Power Platform Community (microsoft.com)
Best regards,