web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Checking if a multiple...
Power Apps
Answered

Checking if a multiple choice field contains a specific choice

(0) ShareShare
ReportReport
Posted on by 112

I'm having a real nightmare figuring this out, and I feel like it should be really simple. 

 

I'm using a sharepoint list to track specific information from our users as they interact with various powerApps etc. I've previously been manually handling people's access to certain functions with an "AdminMode" variable and the OnStart property of an application in this manner:

If(

User().FullName="Simon Smith"||
User().FullName="First Last"||
User().FullName="First Last",
Set(AdminMode,true),
Set(AdminMode,false)

)

 

This is really inefficient, as it requires manual updating. I figured I could use my list that holds other info to also hold a department/role multichoice field, so this could be updated by others, rather than hard coded by myself. 

SimonSmith84_0-1676304530777.png

My first attempt at applying this though and I've hit a brick wall. I'd like an element in Powerapps to only be visible if someone has the "Order Processing" choice selected in the "Department" field, but I can not for the life of me figure out how to do this. 

 

Any pointers would be hugely appreciated, I assumed there'd be tons of resources relating to this, but I'm either using poor search terms, or it's so obvious that it's never needed to be asked before! 

 

 

 

Categories:
I have the same question (0)
  • RJM07 Profile Picture
    801 on at

    I believe you might want to look into Azure Active Directory

    https://learn.microsoft.com/en-us/power-apps/teams/integrate-azure-ad

  • Verified answer
    v-liwei-msft Profile Picture
    Microsoft Employee on at

    Hi @SimonSmith84 

     

    Could you please tell me:

    Do you want to determine whether a field is visible in the gallery based on whether the Department column contains a certain value?

    I have made a test for your reference:

    1.

    vliweimsft_0-1676344820035.png

    2.

    vliweimsft_1-1676344854736.png

    3.In your scenario, the formula should be:

    If("Order Processing" in ThisItem.Department.Value,true,false)

     

    Best Regards,

    Levi

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 358 Most Valuable Professional

#2
11manish Profile Picture

11manish 214 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 185

Last 30 days Overall leaderboard