Hi there!
I am trying to create a flow that updates a files properties (name) when a task is completed. However, I have stumbled across a little problem which i can't seem to fix so I will take a gamble and ask you folks.
To give a short summary about this flow:
I have a planner board which has different task on it. These task all have a corresponding folder (named after their Id). When a task is finished, this flow gets hit. The flow then searches for a folder that corresponds in name with the id of the task that is finished. After that, it will search this folder for an .xlsx file. It reads the data out of the tables that are in the .xlsx file and composes that into a couple of strings. These strings then later form the name of the document.
I am able to get all the data out of that excel sheet and use it to compose strings, but I am not able to update the file properties. The error Flow is throwing me is:
{
"status": 404,
"message": "Could not find list item.\r\nclientRequestId: 1406b4be-d09e-41a2-80c8-7b1e03af1257\r\nserviceRequestId: XXXXXXXXXXXXXXXXXX"
}
This is a screenshot of the connector:
The inner code for the item value is:
item()?['Id']
My item looks like this:
{
"Id":"%252fGedeelde%2bdocumenten%252fMeldingen%252fBijlages%252fgZHqywfJZ0WTPew65vfpn5cADPcD%252fLog_CustomerName.xlsx",
"Name":"Log_CustomerName.xlsx",
"DisplayName":"Log_CustomerName.xlsx",
"Path":"XXXX",
"LastModified":"2020-06-02T16:59:49Z",
"Size":54904,
"MediaType":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"IsFolder":false,
"ETag":"XXXXXXXXX",
"FileLocator":"XXXXXXXXX",
"LastModifiedBy":null
}
I hope i have been clear enough in explaining my issue. Thank you dearly for your help!
