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...
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
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
Thank for that, I tried doing/following your instructions but I am at a loss/can't quite figure it out.