Compare 2 Excel Sheets (big database)

(0) Share

Report

Posted on by jonbu

155

Hello everyone,

I built my flow orientated on this linked flow from this forum:
https://powerusers.microsoft.com/t5/Building-Flows/Compare-2-Excel-Spreadsheets/m-p/487909

Unfortunately, this flow is too slow for running my big sheet with 900 rows.

So here is what I wanted to build:

I have two excel sheets with each about 900 rows and 3 necessary columns. I want the flow to compare the sheets and check every row to see if it has changed to the older one.

Sheet old:

CustomerID	CustomerName	Level
1	Microsoft	Basic
2	Google	Standard
3	Meta	Premium
4	Twitter	Premium

Sheet new:

CustomerID	CustomerName	Level
1	Microsoft	Basic
2	Google	Standard
3	Meta	Standard
4	Twitter	Basic

I hope you understand my problem and can help me, solve this.

Thanks in advance!

Categories:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (1)

v-bofeng-msft on at

Like (1)

Report
Re: Compare 2 Excel Sheets (big database)

Hi @jonbu ,

Could you please tell me what kind of results do you want to achieve?

If you just want to know if these two tables are the same, then this is easy to achieve.

If you want to know which records in the two tables are different, then this is still done by creating a loop.

Best Regards,

Bof

Was this reply helpful? Yes No
jonbu 155 on at

Like (0)

Report

Re: Compare 2 Excel Sheets (big database)

Hi @v-bofeng-msft,
Thanks for your answer.

I'd like to have the second opinion. My goal is to compare two sheets and give out the differences - preferred as a mail, but this will be easier than building a performing flow, I Think.

Was this reply helpful? Yes No
Verified answer

jonbu 155 on at

Like (0)

Report

Re: Compare 2 Excel Sheets (big database)

I solved it by myself.
The fault was the wrong connection to "apply to each". The right way was to connect "apply to each 2" to "filter array" instead of connecting it again to "lists rows present in a table".

The flow runs now for about 30 minutes, but both excel sheets have about 900 entries to compare.

Was this reply helpful? Yes No