Forum Discussion
Auto-populating columns in SharePoint for existing files and folders
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.
- what or where would I get the correct item ID that i need to enter?
I have enter the correct *Site Address, and *Library Name. It is just the *Id that is that I have enter, but where would I get the correct value to enter there please, current I have just entered a random number?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)- I only get the options of choosing the likes of latitude, longitude, city, country/region, timestamp, user name and user email which I have tried but again I get errors.
The ID has to be a integer of certain length
"The 'inputs.parameters' of workflow operation 'Update_file_properties' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'id' is required to be of type 'Integer/int64'. Converting the integer value '51.571610920882094' to type 'Integer/int64' will result in a loss of precision. Use the 'float()' expression if this is intended."