cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shadhasan
Regular Visitor

Get Dynamic excel row value and compare /update another excel file

Hi Everyone,

 

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. 

 

Would this possible in flow ? 

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,257)