cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Comparing and Updating Two Separate Excel Files using Flow

Can anyone guide me to a solution?

 

Currently I have a flow that collects response data via a form to an Excel file into a SPO folder.

 

I use Power Automate (Flow) to retrieve Company Name, and user details using the 0365 user connector. 

 

Help: I have a translation/conversion table in a Separate Excel sheet in the doc library where Company name = Internal Company Code.

 

On a schedule, how can I automatically pull Internal Company code from one excel doc into the Response Data?

 

 

5 REPLIES 5
Super User III
Super User III

Hi @ctuitt 

 

Try using Excel List Rows Present in a table. You can filter the rows using Filter Query.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

Can you point me to any examples/videos or other similar threads that can help? Complete novice on how to do this.
Super User III
Super User III

Hi @ctuitt 

 

Thanks for your quick reply.

 

Please see blog

 

https://mydevexperience.wordpress.com/2019/09/25/microsoft-flow-excel-list-rows-present-in-a-table/

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

Stupid Question: How would the filter query work in this instance if Excel "A" is my Translation Table that contains the information I want to pull from, and Excel "B" has a column in the sheet that I'd like to update with info pulled from Excel "A". 

If I use a filter query, it seems that it will return a row's for a specific value I query from Excel A. 

Super User III
Super User III

Hi @ctuitt 

 

Do you want to get all rows from Excel 'A'? Then use List Rows action for Excel A without any filter query. This should return all the rows. Next add a foreach loop and define the filter to query Excel B to get the items. Add another loop inside the earlier loop and do the update.

 

1. List Rows (Excel B) 

2. For Each

3.  List Rows (Excel A) with Filter using Excel B column value match

4. For Each

5. Update Excel B

6. End of Loop Step 4

7. End of Loop Step 2

 

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

Helpful resources

Announcements
New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (35,272)