Problem with User Table and the Filter Function

(0) Share

Report

Posted on by Lucas001

2,557 Super User 2026 Season 1

Hello all,

i came across a strange problem.

I wanted to compare the 'Full Name' attribute from the User-Table to the resourceLeader.Name, which is just another Full Name stored in another table. Definitely a string.

Why so ever it seems that the LookUp or the Filter does not work when I use that way.

When I on the opposite use 'Full Name' = Text(resourceLeader.Name) it works, anyways I get a delegation which is not necessary here.

The workaround was to use a collection and store the fullname and email inside and use that to fill in the LookUp.

Does somebody know why the LookUp seems to have a problem with the 'Full Name' of the User-table?

The code which I used:

ClearCollect(
 colUserLookUpEmail,
 ForAll(
 Users,
 {
 fullName: 'Full Name',
 eMail: 'Primary Email'
 }
 )
);

ClearCollect(
 colBookableRessourceCharacteristicsGetEmailOfLeaders,
 ForAll(
 colBookableRessourceCharacteristicsGetLeaders,
 {
 userMail: LookUp(
 colUserLookUpEmail,
 fullName = resourceLeader.Name,
 eMail
 )
 }
 )
);

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Are you getting incorrect results? Are you getting an error? What exactly is not working?

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!
@Lucas001 ,

The workaround you used is not quite a good one, as the User table can have a large number of items which you don't need. ForAll() function will iterate through all items that will affect the responsiveness of the app.

So:

ClearCollect( colUserLookUpEmail, ShowColumns( Filter(Users,'User Licensed'), "fullname", "internalemailaddress" ) )

The second part:

ClearCollect( colBookableRessourceCharacteristicsGetEmailOfLeaders, ForAll( colBookableRessourceCharacteristicsGetLeaders, { userMail: LookUp( colUserLookUpEmail, fullname = resourceLeader.Name, internalemailadress ) } ) );

Was this reply helpful? Yes No
Lucas001 2,557 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @BrianS,

I get an error which says fullname is not a text property and cannot be displayed in a gallery for example.

@gabibalaban, totally forgot the ShowColumns-function. Will improve the workaround, thanks for the support.
I will see if the error persists with that as the Fullname of the User-Table seems to make the problem occur.

Edit: @gabibalaban your solution works and is more performant than mine. Thanks for your support.

Was this reply helpful? Yes No