Hi, I'm trying to filter a collection (colFBPPending) against another collection (colExistingIDs).
colFBPPending contains a list of IDs such as
ColExistingIDs queries a dataverse table to ge ta list of IDs already with a table called Quotes. It returns:
What I need in a gallery, is to filter out the IDs returned in colExistingIDs with the list of items returned in colFBPPending to only show:
I did come close with the below code but it isn't filtering correctly and returns all items in colFBPPending
Filter(colFPBPending, !IsBlank(LookUp(colExistingIDs, id in colFPBPending.id)))
Any ideas on the correct code?
