Get Dynamic excel row value and compare /update another excel file
So here is my issue, I have 2 excel file lets call it DataInput and other MasterList both have same columns ie. Name, Address, Phone.
The masterlist has all the data in it and the datainput file gets uploaded everyweek and added to the masterlist, now so far I am able trigger flow when new datainput file is uploaded, and I am able to List the rows presents.
But I would like to be able to get each row from DataInput then compare the Name field in MasterList and if it matches the name and Address and phone are not populated I want to be able to update the data else it will create a new row.