i trying to create a flow that will open and update and excel sheet with some data in a table. works fine if i selected site and folder and file. but if i pass the site and folder name i get errors. I am assuming i need an Identity of the Folder name. Who do i get this value? or is it something else?
Correct, i have a excel file in a folder called Reports. the site url changes from project to project. Folder name and File name stay the same from project to project. i would like to have a Flow that i can pass the SiteURL dynamic. even if i pass the new siteURL it is still opening the old file used to setup the add record. i was trying to get the Idenitfer of the folder and files and pass those instead but still cannot get it to open.
It sounds like the requirement is to update the excel sheet. So if you pass just the site and the folder, it seems like it will not know which file to update, hence why you receive the error. This is what I believe from my understanding of the issue. Can you elaborate more on the issue as far as what action you are using in Flow, and what error do you receive?
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional