Hello!
I need to update some of the values in 'Sheet 1' with the corresponding information from 'Master Sheet'. Each are excel files stored in a Sharepoint document library.
Each row on both 'Sheet 1' and 'Master Sheet' have a unique 'ID' column. 'Master Sheet' is a Master list of all the data. 'Sheet 1' has only a few of the rows that 'Master Sheet' has, as it is tailored to a specific user.
So basically, for each unique 'ID' found on 'Sheet 1's row, update 'Sheet 1' with the information from 'Master Sheet's row that shares this unique 'ID'.
How I have been trying to do this:
Manual trigger ->
'List Rows Present in a Table' action to get content from 'Master Sheet', using a filter query to reduce the amount of data returned. ->
'Filter Array' action to further reduce the amount of data. ->
'Parse JSON' action to allow the Filter Array data to be accessed via Dynamic Content ->
'Update a Row' action inside of an 'Apply to Each'
The error I'm getting:
// (highlighted in gray is some values I've redacted)
{
"status": 404,
"message": "No row was found with Id '510069872280'.\r\nclientRequestId: redacted",
"error": {
"message": "No row was found with Id '510069872280'."
},
"source": "redacted"
}
My assumption on what it's doing:
It looks to me like it is attempting to use each 'ID' from 'Master Sheet', find it on 'Sheet 1', then update 'Sheet 1'.
The id in the error above "510069872280" is one found on 'Master Sheet', but not 'Sheet 1'.
What I need it to do:
I need it to look for the unique 'ID' on 'Sheet 1', then find the row on 'Master Sheet' with the same 'ID', and update the cells in the 'Sheet 1' row with the information from the corresponding row in 'Master Sheet.'
Flow pictures:
Entire flow:
Actions Breakdown:
List Rows Action:
Filter Array Action:
Parse JSON Action:
Update a Row Action:
Please let me know if I can provide any more information.
Your help will be very much appreciated.
Best,
Jordan
