web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Comparing two tables w...

Power Apps

Unanswered

Comparing two tables with duplicates

(0) Share

Report

Report

Posted on by jimi_hendrix

Looking for some assistance here is an example

Table 1

Value:

123

123

456

789

Table 2

Value

123

456

Looking to have a means to have a list that would call out that 789 and a 123 are missing.. Whats the best way of doing this???

Ideally I'd have a gallery showing Table 1 and when the values are scanned in (creating Table 2) Id like to show a visual for the ones that have not been scanned .. problem comes in with the duplicates!!!

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @jimi_hendrix,

The issue indeed occurs when you try to compare both lists with a 'not in' filter condition as it also filters out the duplicate value after the first scan. An alternative approach you could take is to copy the Table 1 into a collection at the start of the scanning process:

ClearCollect( colTable1Remaining, Table1 )

When scanning a code, you add a record to Table2 but at the same time remove a record from colTable1Remaining:

Remove( colTable1Remaining, //Will only fetch the first occurrence LookUp( colTable1Remaining, //123 is harcoded as an example, replace accordingly Value = 123 ) )

If this solves your question, would you be so kind as to accept it as a solution. ✔️

If you liked my solution, please give it a thumbs up. 👍

Connect with me: LinkedIn | Blog

Was this reply helpful? Yes No

Join the conversation