You’re offline. This is a read only version of the page.
Hi,
I am new to power automate.
I have made this flow which can transfer excel attachements for my email inbox to sharepoint. Then I take a row from the table in the excel file and add it to a table in a master excel file.
However, I have only managed to do this with a specific file and "file name".
I don't understand how I can make the flow take a row from the new files added to my sharepoint folder no matter the name of the file.
As you can see in the screenshot below, you are supposed to choose the specific file and location in order to "get row", but what if I don't know what the file is called before i receive it? I only know the folder it will end up in.
So basically what I do not understand is: what to do here when the files in the folder will have varying names?
The table will always have the same name and location in all the files
Hope anyone is up for the task of explaining/helping me on understanding this 😊
Hello,
I would suspect that this data comes from the Create File you did above? If so then move your steps into the Apply to Each, so that for each attachment you save it executes the get row etc.
And get the details for the path etc from the outputs of Create File (Dynamic Properties)
Like this
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Share
Report
25
All responses (
Answers (
