Power Apps Exchange

Hi,

i am often working with lookups to the dataverse users table. To compare or filter by a user, i am using the email adress, because this is unique for every user.
e.h. Filter(datasource,EmployeeLookup.Email = User().Email). This works fine in most cases.
But sometimes i have a strange behaviour - it can show the displayname of the user, but other information are shown as empty, although they are existing in the users table.

Displayname works:




Email does not show up:



But in the table, both information are existing:


And in other parts of the app, the same behavior works fine :( And idea?

------------------------------
Fabian Heil
------------------------------

Hi Fabian, just for testing, I would add the data into a Gallery to see if the data is not fully loaded into the app or if the Lookup function may cause this. Also, can you may try to put the data into a collection and do the lookup against the collection.

stefan

------------------------------
Stefan Sauerländer
Business Analyst
Ratingen
------------------------------

Original Message:
Sent: Jan 17, 2023 07:37 AM
From: Fabian Heil
Subject: Dataverse User lookup does no retrieve all metadata

Hi,

i am often working with lookups to the dataverse users table. To compare or filter by a user, i am using the email adress, because this is unique for every user.
e.h. Filter(datasource,EmployeeLookup.Email = User().Email). This works fine in most cases.
But sometimes i have a strange behaviour - it can show the displayname of the user, but other information are shown as empty, although they are existing in the users table.

Displayname works:




Email does not show up:



But in the table, both information are existing:


And in other parts of the app, the same behavior works fine :( And idea?

------------------------------
Fabian Heil
------------------------------

Hi Stefan,

the data is already in a collection and is already shown in the gallery. With "Lookup", i dont mean the formula in PowerApps, but the columns type in Dataverse:

("Benutzer" is the german name for the Dataverse users table).

Here is my steps:

1.) OnVisible property of the Screen: Collect a filtered table in a collection (this table contains a user lookup column called "Mitarbeiter" - see screenshot above)

2.) Show the collection in the gallery and added two labels (1 for display name, 1 for email adress)

--> DisplayName is shown, Email adress is not visible (see Screenshots above)

------------------------------
Fabian Heil
------------------------------

Original Message:
Sent: Jan 30, 2023 06:37 AM
From: Stefan Sauerländer
Subject: Dataverse User lookup does no retrieve all metadata

Hi Fabian, just for testing, I would add the data into a Gallery to see if the data is not fully loaded into the app or if the Lookup function may cause this. Also, can you may try to put the data into a collection and do the lookup against the collection.

stefan

------------------------------
Stefan Sauerländer
Business Analyst
Ratingen

Original Message:
Sent: Jan 17, 2023 07:37 AM
From: Fabian Heil
Subject: Dataverse User lookup does no retrieve all metadata

Hi,

i am often working with lookups to the dataverse users table. To compare or filter by a user, i am using the email adress, because this is unique for every user.
e.h. Filter(datasource,EmployeeLookup.Email = User().Email). This works fine in most cases.
But sometimes i have a strange behaviour - it can show the displayname of the user, but other information are shown as empty, although they are existing in the users table.

Displayname works:




Email does not show up:



But in the table, both information are existing:


And in other parts of the app, the same behavior works fine :( And idea?

------------------------------
Fabian Heil
------------------------------