Compare two collections doesn't work?

(0) Share

Report

Posted on by mrQ

482

Dear all

I have a dataverse for teams table called Registered Users and another called Eligible Users.

I would like to check if some of the Registered Users are in the Eligible Users table and I'm checking against the 'Azure AD Object ID' as the unique identifier.

// in 'Eligible Users' I have a column called cr466_User2 that has previously been saved from the 'Registered Users' table to the 'Eligible Users' table

ClearCollect(
 colCheck,
 Filter(
 'Registered Users',
 'Azure AD Object ID' in 'Eligible Users'.cr466_User2.'Azure AD Object ID'
 )
)

My colCheck collection stays empty and I'm wondering why? The 'Eligible Users' table includes Azure AD Object ID's from 'Registered Users'. See here:

I would appreciate your help. Thanks and happy easter!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

FabianAckeret 975 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @mrQ

Try your formula the other way around.

Something like:

ClearCollect( colCheck, Filter( 'Eligible Users', cr466_User2.'Azure AD Object ID' in 'Registered Users'.'Azure AD Object ID' ) )

That helped me often times... Why? I can't really answer that apart from "it might be a bug" OR "it has something to do with the relations of the tables". Meaning, I assume while executing, PowerApps can't access some of the columns right away (e.g. Azure AD Object ID from 'Eligible Users'.cr466_User2). However, if you Filter on the 'Eligible Users', you automatically have that info already (as its stored in the table) and while your 'Registered Users' table is flat, it doesn't encounter that issue there.

I hope it makes sense... I'm not a big fan of using Dataverse for exactly that reason. I've been working with other databases and their relationships before and I never encountered as many issues as with Dataverse.

However, if you know the "bugs" or limitations then Dataverse (and especially Dataverse for Teams) can be very handy/cost effective.

Was this reply helpful? Yes No
mrQ 482 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @FabianAckeret

Thanks for your answer.

That would work, but since I need some of the columns of Registered Users I can't possibly swap the statement.

Was this reply helpful? Yes No