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)

Sort by

Verified answer

WarrenBelz 156,137 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

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 156,137 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 156,137 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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