You’re offline. This is a read only version of the page.
Announcements
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
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:
Share
Report
All responses (
Answers (
12,516
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. 👍
