Answered

Guest user lookup using User() fails

(0) Share

Report

Posted on by tedqn77

127

When a record is created, I need to pull data from a custom field in the User table and store in the record. This code works for internal users but won't return for guest user.

LookUp(Users, User().FullName = 'Full Name', 'Work Site') // get work site name of current logged in user

I notice in the Users list, guest account First Name field stores a '#' and Last Name is the full name of the guest. Could this be the reason the lookup fails?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

james1994 231 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @tedqn77,

Assuming the Full Name in that User List concatenates the First and Last Name like so ("# FirstName LastName"), then this would seem to be why the lookup is not returning anything for your Guest User. You could add a second condition in the lookup which includes the "#" to account for this.

Was this reply helpful? Yes No
tedqn77 127 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried that and it didnt work.
LookUp(Users, "# " & User().FullName = 'Full Name', 'Work Site')

Was this reply helpful? Yes No
james1994 231 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Are you able to provide an example of what the list containing a internal user and guest user looks like?

Was this reply helpful? Yes No
Verified answer

tedqn77 127 on at

Like
a
(0)

Report
Copy link

Link copied!

I was able to get it to work by changing it to
LookUp(Users, User().Email = 'Primary Email', 'Work Site'). Each user has unique primary email address.

Was this reply helpful? Yes No