web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / updating file properti...
Power Automate
Unanswered

updating file properties on sharepooint document library from excel

(0) ShareShare
ReportReport
Posted on by 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, Screenshot 2019-10-03 at 14.57.35.pngScreenshot 2019-10-03 at 14.56.57.pngScreenshot 2019-10-03 at 14.55.45.pngScreenshot 2019-10-03 at 14.54.04.png

@pstork @yashag2255 @ScottShearer 

Categories:
I have the same question (0)
  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 223 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 205 Most Valuable Professional

#3
harshdeol Profile Picture

harshdeol 167 Moderator

Last 30 days Overall leaderboard