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 Apps
Answered

Combo box & filter

(0) ShareShare
ReportReport
Posted on by 26

Hi There,

I have a wired issue with combo box filter. 

My PowerApps uses form to view and submit data to a Sharepoint list.
I have a column in sharepoint list named Region, which is of datatype Choice and has 4 choices - UK, APAC, EU, NA.
The field in PowerApps is shown as dropdown (combo box).
I would need to filter out UK in certain condition and display other 3 regions.

The item property of the combo box is updated as

If(Value(DataCardValue02.Text) = 6, Filter(Choices([@DPUC235611].Region), Value exactin ("EU")|| Value exactin ("APAC")|| Value exactin ("NA")), Choices([@DPUC235611].Region))


The above logic works fine in the "Preview the app (F5)" mode, however when i publish the app and test in the link, the dropdown list does not get filtered; All items are shown.
I cleared the browser cache as well but nothing works.

When i see the filtered values in the label (in link), it shows me the filtered list. But the drop down is not updated with filtered list

Can you suggest me what i'm doing wrong here?

Categories:
I have the same question (0)
  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @SS13,

    What do you mean by testing in the link? Is it the web link of the published app?

    I think you could try to check the advanced settings for the "Explicit Column Selection", please turn off of it

    v-qiaqi-msft_0-1622167726201.png

    Check if this could help.

    Regards,

    Qi

     

     

  • Sriram6000 Profile Picture
    26 on at

    I meant the web link when the app is published.

    I turned offed the "Explicit Column Selection" and it works. 

    Thanks for your help. 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard