0

I have excel file inside document library in SharePoint. I want to update the excel sheet using MS Flow.

I am passing static values via flow. (Ex Approval status: Approved & Approval Comments: Test Comments).

But I am not able to update Excel sheet using MS flow. I am getting not found error.

Error Details:

No row was found with Id 'Approved'. clientRequestId: 49132a1b-ccfd-409d-80d0-7ef8edcce0e9 serviceRequestId: a527b9bd-8bb6-40a5-bb93-487512652703;91e09720-b282-4e97-931d-721d698a89e7;356e4e3f-ba2a-4388-886c-440097fe53ff

enter image description here

enter image description here

error: enter image description here

2

1 Answer 1

1

It appears you are using the Update a Row Excel action in your Flow. Based on your description, it sounds like maybe you intended to use the Add a Row action instead? The primary difference between the new actions is that Add a Row will add a new row into the spreadsheet into the table you specify, but the Update a Row action will changes values in an existing row that you specify. If you switch to the Add a Row action, you only need to specify the spreadsheet and table, you do not need to specify a key and value to select by.

When using the Update a Row action, the way the action "knows" which row to update is by the values you specify in the Key Column and Key Value. It will find and update the row where the column you specify is equal to the value you specify. However, it assumes that the key and value you specify are unique in that it can be treated like a true database key. This means that if there are multiple rows with the same value in that column, it will only update the first one it encounters, and if no rows match that key value, then it will throw a NotFound error.

If you do not have a single unique key column that can be used to identify the row that you want to update, and you do not want to add a new row to the spreadsheet, then your next best option is to use the List rows present in a table action, optionally specifying filter and ordering. Then you can use an apply to each action to loop through the results and update multiple Rows.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.