Forum Discussion
Auto-populating columns in SharePoint for existing files and folders
Does anyone know if there is a way to auto populate columns/metadata in SharePoint with default values for existing file and folders. I have tried by going into library settings and changed the defau...
Ah... OK, sure..... In that case you should use the instant trigger "For a selected File". This Trigger will give you the ID to the selected file.
Then you can start the flow from the list. Mark the the file and then select "Automate" and then your flow from the list menus. Then your flow will be started on that File
Then you can start the flow from the list. Mark the the file and then select "Automate" and then your flow from the list menus. Then your flow will be started on that File
Thank you, would that work on all files or just that selected file, what I need to do is change the columns values for 2 columns for all existing files and folders in that library?
Thanks for your help again, it is much appreciated
Thanks for your help again, it is much appreciated
- Thank for that, I tried doing/following your instructions but I am at a loss/can't quite figure it out.
- You're welcome 🙂
In that case the trigger doesn't matter and you will need to use the Sharepoint "Get Files (properties only)" action after the trigger.
This will give you all files in the library (Change the TOP-Count in that action to the maximum possible size to try to get all of you files in one go)..
Then use an "Apply to each" action with the value of the previous action as an input parameter.
You will then have access to all file properties inside the "Apply to each" loop, including the id.
Add your update action there and use that id