You’re offline. This is a read only version of the page.
Announcements
21
Looking for some help. trying to update sharepoint doucment file properties using excel list. I already have the excel export iqy file now in a xslx / table. hosted in a sharepoint document lib.
cannot seem to get 'ID' from excel list as an option to config on the update file properties action- as ID.
i am defo looking for a loop becuase i have mutiple records to update from excel rows to sharepoint doucment lib items.
any help appreicated,
Hey @ENkay1
You need to actually get the File Item ID to update the properties of that file. It is a unique integer that is generated by SP itself when the item/file is created. You are not creating the file in this flow which means you will first have to get the file and then reference the ID of the file in the Update Action.
So in this case, if you have the filename that will be unique and the details of that in the Excel too, you can get all files and add a filter query to filter by the name of the file and then use that ID to finally update the properties.
For later on, Maybe have the ID of the file stored in the Excel column (maybe a Flow that creates an excel row when a file is cretaed and saves it ID in a coulmn over there).
BTW, Current item that you have referenced in the ID is basically the item that you are iterating on in the apply to each loop.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Share
Report
All responses (
Answers (
