Oct 04 2022 05:48 AM
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 default column settings with the value I needed. It seems to be working fine for any documents that are created after changing this setting, but isn't working for existing documents that were already in SharePoint? How can I change the column values for existing files and folders please? Can I use power automate to do this or can it be done using SharePoint?
Thanks in advance
Oct 04 2022 06:13 AM
Oct 04 2022 06:29 AM - edited Oct 04 2022 06:30 AM
I have tried creating a new manual tiggered workflow, then used “update file properties” but I get errors when I run it.
"{
"status": 404,
"message": "Could not find list item.\r\nclientRequestId: 315ca606-00ee-44ff-b38e-c6e88c145930\r\nserviceRequestId: 315ca606-00ee-44ff-b38e-c6e88c145930"
}"
I have entered the correct site address. library and the two columns I wanted the values changed in, so am at a loss why it is not working. Using the correct username account which is owner/admin access to that site too.
Anyone have any ideas?
Thank you.
Oct 04 2022 06:47 AM
Oct 04 2022 07:06 AM
Oct 04 2022 07:16 AM - edited Oct 04 2022 07:20 AM
You get that ID from the Trigger as a dynamic content
But you might get an endless loop if you update that file in a flow that is triggered if you update an item.... You should also insert a condition that makes sure that you don't needlessly update the item (i.e. check if the two columns already have the value you want to set)
Oct 04 2022 07:28 AM
Oct 04 2022 10:55 PM
Oct 04 2022 11:08 PM
what or where might I get the right thing ID that I really want to enter?
I have enter the right *Site Address, and *Library Name. It is only the *Id that will be that I have enter, however where might I get the right worth to enter there please, current I have quite recently entered an irregular number?
Oct 05 2022 01:36 AM
Thank you for helping with me with this.
I was using a manual trigger as it would run/triggered manually and only really used once or twice. I did not create the document library, it is a large existing library(s) which is owned by a completely different team.
Can I get the automated Flow to be manually triggered?
Oct 05 2022 02:02 AM
Oct 05 2022 02:06 AM
Oct 05 2022 04:40 AM
Oct 06 2022 02:36 AM