Hi I trying to build a power automate workflow that will get data from multiple excel sheets once they are uploaded in a teams folder and paste it into a sharepoint list.
I thought it seemed straightforward but it is not working so far.
My first trigger is when a file created or modified in a folder
--This is correct
My second flow is get file content
--I am not sure why you have a second flow, you should grab the data from your Trigger, in your first flow
--However, you do NOT need to get the file contents at all, since you just want to read the data from the excel sheet(s)/files
My third flow is list rows present (the excel has been formatted into a table)
-Not sure why you have a third flow, its merely a step as part of #1 (or do you mean steps but keep saying flow?)
-This is correct though what you need to do
The fourth step is apply to each where value is selected and then all the columns in the excel table
-Also correct
The fifth is create an item in the sharepoint list and I used dynamic content to map the columns in the excel to the sharepoint list.
-Also correct
I have tried this in many ways but it is still not working. Anything I am missing? Any help?
Everything you wrote is correct, so you need to show exactly what is not working. Show your Flow (dont explain it), and show a Flow Run that failed)
But you did everything correctly (from a steps perspective, so good on that, now lets see whats wrong in your code).
2
Share
Report
All responses (
Answers (
