Retrieve a choice column value

(1) Share

Report

Posted on by Fada

154

Hi,

I have a datavser table called 'End User' with the column below

Username: lookup column (see attach image)

Role: choice column with values(Director, Assistant, Registry).

I have already registered the users in the table.

Now, my purpose is to get in a variable, the role of the connected user when he runs the application.

Thanks

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

Hassan_SZ_365 542 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Fahd ,
you can use the following formula in PowerApps:

Set(CurrentUserRole, LookUp('End User', Username = User().Email).Role)

This formula sets a variable named CurrentUserRole to the role value associated with the connected user's email address in the "End User" SharePoint list. Adjust the column names accordingly if they differ in your setup.
Best Regards,
Hassan Raza
M_Ali_SZ365 1,110 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Fahd ,
Try this
Set(CurrentUserRole, LookUp('End User', Username = User().Email).Role)
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Fahd ,

The standard approach should be:

Set(CurrentUserRole, LookUp('End User', Username = User().Email).Role)

Actually,in certain situation the PowerApps treat the result as a choice option value, and it cannot be used as it is.

So to be sure that the result is indeed a string value use a Text() function.

Set(CurrentUserRole, Text( LookUp('End User', Username = User().Email).Role) )
Fada 154 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I have an error when running the app (see screenshots).
Thanks
M_Ali_SZ365 1,110 on at

Like
a
(0)

Report
Copy link

Link copied!
@Fahd ,
Try This
confirm 'End User' table exists.
check 'Username' column as a lookup.
Handle potential null values in code.
Set(CurrentUserRole, LookUp('End User', Username = User().Email && !IsBlank(Username)).Role)
Test with a known username.
Set(CurrentUserRole, LookUp('End User', Username = "known@email.com").Role)
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali
Fada 154 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @M_Ali_SZ365 ,
Your code does not work and it gives me a delegation warning.

However, I have the correct role with the below code but it shows me a delegation warning. So now, my purpose is to handle the delegation issue.
Set(
varUserRole,
LookUp(
'End users',
User().Email in 'User name'.Mail).Role)

Thanks
M_Ali_SZ365 1,110 on at

Like
a
(0)

Report
Copy link

Link copied!
@Fahd ,
Try This
For the delegation warning:
Refine the lookup condition:
Set(varUserRole, LookUp('End users', 'User name'.Mail = User().Email, Role))
Filter before lookup:
Set(varUserRole, LookUp(Filter('End users', 'User name'.Mail = User().Email), Role))
Limit rows for large datasets:
Set(varUserRole, First(LookUp(Filter('End users', 'User name'.Mail = User().Email), Role)))
Test these for the delegation issue.
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali
Verified answer

Fada 154 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @M_Ali_SZ365 , Still nothing, I have an error when running your code. Anyway, I take the risk of delegation.
Thanks