Why can't i Lookup on a choice field?

(0) Share

Report

Posted on by dinisbento

Hello fellows,

I've been wraping my head around this question

I have a "persons" field in Sharepoint;

In powerapps to get the list of everyone I would make a table with the items property as

Choices(DataSource.Users)

this will create a table with the collumns

Claims, Email, Department, DisplayName, Job Title

Being this table filled with all the users in the corporation.

My problem lies here:

Why does

Lookup(Choices(DataSource.Users);Email = "email@imsureisthere.com")

return no record?

This happens with any email and even using User().Email for my own email

Truly thankful for any insights

EDIT:

It doen't give an error, it instead returns and empty table as if the searched email wasn't in Choices(DataSource.Users)

Edit:

Choiches(Users.EmailDiretor) returns a table

2024-02-09 10_15_29-Power Apps — Mozilla Firefox.png

When i try to lookup on that table i don't get a record even using my User().Email

2024-02-09 10_14_53-Power Apps — Mozilla Firefox.png

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

Micky 365 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try this.

LookUp(DataSource,person_field.Email = "email@imsureisthere.com")
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @dinisbento

You can also try this:

Filter(Choices(DataSource.Users), Email = "email@imsureisthere.com")

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @dinisbento,

Try to make sure if there is lower or upper case in your email address.

Lookup(Choices(DataSource.Users);Trim(Lower(Email)) = Trim(Lower("email@imsureisthere.com")))
dinisbento 8 on at

Like
a
(0)

Report
Copy link

Link copied!

this will give me all records on the main table with the email, but i want to retrieve 1 person record from the Choices(Datasource.Users) which is a table with the companies office365 users. i want to assign a person to a role automatically with out listing all the e-mails by hand, So i need to make a logic, if field X is A the person P gets an e-mail, i need this lookup or anything that return a full record from the choices list to apply on my condition.
dinisbento 8 on at

Like
a
(0)

Report
Copy link

Link copied!

This will return a string with the email on the main sharepoint list, but i need the record of a full person which appears as an option in the dropdown list that's linked to a "persons" type field in a sharepoint list. This field is a table inside a table that contains the selected users picture, DiplayName, Email and other info
dinisbento 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Good Idea but unfortunatly didn't work, I'll edit the main post with some images so you cant take a better look
dinisbento 8 on at

Like
a
(0)

Report
Copy link

Link copied!

UPDATE:

Using the filter function I can 1/3 of the times get a return
i'm guessing there is a bug or im not using the best way to get to this data
a few examples, all the emails in the example exist and should return a line:

btw the ang*** field thats not being return exist in the sharepoint list