Answered

How to compare two tables and look for differences?

(0) Share

Report

Posted on by KN-18111252-0

I have two tables with the same columns. Lets say it is 'ID', 'Name', 'Quantity' and 'Date'. The information under the columns Quantity and Date can change and therefore the tables can differ (Not ID or Name). I want to create an app which with a button or on start up compares the tables and present the differences. How do i make the comparison?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi KN-18111252-0

This should produce a Collection with any different fields and the different values
ForAll( Table1 As _T1, With( { _Data: LookUp( Table2, ID = _T1.ID ) }, If( _Data.Quantity <> _T1.Quantity || _Data.Date <> _T1.Date, Collect( colDiff, { ID: _T1.ID, Name: _T1.Name, Quantity: _T1.Quantity, Quantity2: _Data.Quantity, Date: _T1.Date, Date2: _Data.Date } ) ) ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
KN-18111252-0 2 on at

Like (0)

Report

Do i add this code under 'OnStart' property of the app? Sorry i am new to Power Apps,

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

You can add it wherever you want to collect the data - OnStart will work.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

Hi @KN-18111252-0,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No