So I have a SharePoint List that contains a column that holds a special ID. Let's call it orderNumber. Then I have 2 other columns (lets call one Car and the other Color).
Now, both these columns are empty but the orderNumber column already contains numbers. Now my Excel table contains the data that needs to be placed in the car and color columns.
So, for example, in my SharePoint list lets say 1 is in the orderNumber. In the Excel table, we have three columns (orderNumer, car, color) and it would contain 1, ford, red.
I am attempting to populate the fields in the SharePoint list with this correlating data, but I am having difficulty. I created a Flow but it doesn't work. Any help would be appreciated.