Unanswered

Compare 2 Excel Spreadsheets

(0) Share

Report

Posted on by Community Power Pla...

Hi everybody! I have 2 Excel Spreadsheets.Spreadsheet A and Spreadsheet B. Spreadsheet A has 3 columns: Name, Age and Country. From Spreasheet B only the name is relevant. I want to compare if the Name of a person that is in spreadsheet B also is in Spreadsheet B. And if it is in Spreadsheet B, what is the Age and the Country? I really would appreciate an answer!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-alzhan-msft on at

Like (1)

Report
Hi @Anonymous ,

Microsoft flow could only get rows in the table in excel, you could create table with Name, Age and Country column in your excel sheet A and create a table withName column in your excel sheet B, the document about format table in excel as below:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/how-to-excel-tips

Then you could save the excel sheet A and sheet B in your onedrive bussiness and refer to screenshot below to create the flow:

The length expression in the Condition as below:

length(body('Filter_array'))

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Paintballhearts 7 on at

Like (0)

Report

@v-alzhan-msft great stuff! Just wanted to ask if what I'm trying to lookup/compare are items not found on spreadsheet A and B (technically if you use vlookup in excel it would give a #NA), would I need to use does not contain in filter array?

Was this reply helpful? Yes No