Limit some values in Choice field based on email in PowerApps

(0) Share

Report

Posted on by perrydan57

Hello,

I would like to define some values from a choice field based on user email (into Power Apps Form).

Field = OneIDM from IT Applications SharePoint

Target if user = firstname.lastname@gmail,com ==> Allowed Selection Values = New, Done,Checked, N/A

Else ==> Allowed Selection Values = New, Done, N/A

My current formula is:

Filter(Choices([@'IT Applications'].OneIDM),if (!User().Email= "firstname.lastname@gmail.com", Value= "New" || "Done" || "Checked"|| "N/A", Value= "New" || "Done" || "N/A"))

Unfortunately not accepted 😕

Thanks for your help

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

rsaikrishna 3,703 on at

Like
a
(0)

Report
Copy link

Link copied!

Based on the information you provided, the different of values between If and Else is just Checked should be ignored.
Try changing the formula:
if (!User().Email= "firstname.lastname@gmail.com", Choices([@'IT Applications'].OneIDM), Filter(Choices([@'IT Applications'].OneIDM), Value <> "Checked")

Regards
Krishna Rachakonda
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @perrydan57 ,

Please try this

Filter(Choices([@'IT Applications'].OneIDM),if (User().Email= "firstname.lastname@gmail.com", Value in "NewDoneCheckedN/A", Value in "NewDoneN/A"))

Best Regards,

Wearsky
perrydan57 54 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi rsaikrishna,
Formula is not working ☹️
Additionally My choice has one additional value (to be re-certified) that is only used in Power Automate, never as possible choice
perrydan57 54 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately not working,
error message:
perrydan57 54 on at

Like
a
(0)

Report
Copy link

Link copied!

I forgot 2nd error message linked to if:
Verified answer

perrydan57 54 on at

Like
a
(0)

Report
Copy link

Link copied!

finally found solution:
If (User().Email = "firstname.lastname@gmail.com",
Filter(Choices([@'IT Applications'].OneIDM), Value in "NewDoneCheckedN/A"),
Filter(Choices([@'IT Applications'].OneIDM),Value in "NewDoneN/A")
)