Excel - Update a table

[Benniewoods]

Hi everyone,

I saw this question multiple times, and tried several solutions. But i could not get it to work. Hopefully someone can enlighten me.

I have one masterdata file that contains multiple columns with data. Furthermore i have one destination file that contains a view with only necessary columns for that group. The source is the masterdata file (both are on the same Sharepoint, but a different folder).

Masterdata file

Destination file

What I want to achieve is that the information in the destination file is updated when something changes in the masterdata file. It can be that a row (ruim/location) will be added, or information in a cell will change. For this I created the following flow:

In this example some names can be different because i altered them for the picture. But in the flow everything is correct. The error I get with this flow is "No row was found with Id '1'. This is the key value. I added the No in both files to use it as a key value. But for some reason it is not working. Any suggestions?

Thanks in advance,

Ben