How to compare Excel Tables/Sheets in Microsoft Power Automate

This video tutorial shows, how to compare Excel Sheets and Tables with Microsoft Power Automate. Three examples are created and data are taken out, where the tables match (intersect), where the tables not match (distinct) and where we join the tables.

You could also watch:
🔵 Power Automate for Beginners - https://youtu.be/omQ-fAF4QpI
🔵 Power Automate .XLSX to .CSV - https://youtu.be/Ik-TLaMByhw

0:10 Our Power Automate Compare Excel Use Case
Presenting the case, where we want to compare Excel tables with Power Automate

1:35 Create our flow to find matching Excel Rows
We iterate through each row in two Excel tables and find matching rows. The result we chose to write in a third table.

1:58 List rows present in a table
Use the action to get all the rows in the Excel table. Because we will read two tables, it's important to rename the activity to have a better overview and not get confused.

2:54 Apply to each
The Apply to each action will loop through all the rows in the Excel table.

3:29 Create a nested loop
The other Excel table is read with another List rows present in a table and an Apply to each. The intuition is that we take a row one by one in the first table and compare that exact row with the rows one by one in the second table.

5:19 Condition
We create the condition to write matching rows to a new table.

7:26 Flow to find rows in Excel tables that don't match
The intuition is almost the same as the previous flow. We will also do a nested loop, but we will introduce a boolean variable to help us keep track of the non-matching rows.

15:31 Flow to join to Excel tables
Again we can apply the same intuition from our two previous flows to join the two Excel tables with Power Automate. Instead of editing our existing tabled we create a new table to write to.

Connect with me:
🔔 Subscribe - http://www.youtube.com/user/klogeanders?sub_confirmation=1
💼 LinkedIn - https://www.linkedin.com/in/andersjensens/
👥 Facebook - https://www.facebook.com/andersjensenorg
💌 Email Newsletter - https://andersjensen.org/email-newsletter/

#powerautomate #excel #microsoft

Видео How to compare Excel Tables/Sheets in Microsoft Power Automate канала Anders Jensen