Create a collection with the items that are present in one table, but not in another, i.e. creating a "Diff" between tables

(0) Share

Report

Posted on by MoonLunatic

Here is my challenge:

- I query from AD a list of the people in my company, and put it in a collection: colPeople

- I save that list in a CDS table, named tblPeople, so that I can add more details for each of the persons

This gives me a snapshot of who is in the company at the time of the query.

If I want an updated list from AD, I can query again and populate colPeople, but it will give me a different list of items, because some people will have joined, some people will have left.

I want to update my CDS-based table with the latest updates from AD, what it the best way to proceed if I need to:

remove from tblPeople the people that are not in colPeople anymore
add to tblPeople the people that have appeared in colPeople since the last query
modify information in tblPeople to match the latest colPeople information

I am trying to create a new collection that would match the first need, and the best I can do is a button with:

ForAll(colPeople,If(IsBlank(LookUp(tblPeople,ThisRecord.'Full Name' = ThisRecord.'Full Name')),Collect(colinADnotCDS,ThisRecord))).

However, "ThisRecord" seems to always refer to tblPeople items, not colPeople items.

Thanks for any pointer or help!!

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MoonLunatic ,
Ambiguity is the issue here - try

ForAll( colPeople as aPeople, If( IsBlank( LookUp( tblPeople, 'Full Name' = aPeople.'Full Name' ).'Full Name' ), Collect( colinADnotCDS, ThisRecord ) ) )

or maybe this

ClearCollect( colinADnotCDS, Filter( tblPeople, !('FullName in colPeople.'Full Name') ) )

Please click Accept as solution 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 Thumbs Up.

Visit my blog Practical Power Apps
WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MoonLunatic ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution 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 Thumbs Up.

Visit my blog Practical Power Apps
MoonLunatic 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren, sorry, I am not working on this project full time and have not been able to check whether your suggestion works out for me! Once I have tried it out, I will confirm it works or ask for more advice 🙂