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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter on Choice colum...
Power Apps
Unanswered

Filter on Choice column not showing any results

(1) ShareShare
ReportReport
Posted on by DWTKHome 15
Hello,
 
I have a choice column in my custom SharePoint PowerApps form that points to a lookup column(MachineLU) in a SharePoint list. I'm trying to filter that column with a variable(AreaVAR) in the PowerApp versus another column in the SharePoint list(area).
 
 
I know it should produce exactly 2 results, however it is not displaying any results.
 
I don't understand why this wouldn't be working, Any advice would be greatly appretiated.
 
Thanks in advance
DWTKHome
Categories:
Building Power Apps
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    Michael E. Gernaey 53,958 Moderator on at
    Hi
     
    Please share a photo of the two lists with the lookup defined
     
    Please share the code you are trying to use
     
    Please share what it does show you versus what you expect, with an example where filtering based on X should produce 2 so we can tell you why its not.
     
    It looks like you might have posted a picture, but its not visible. But please share all of this information.
     
    Thanks!
  • DWTKHome Profile Picture
    DWTKHome 15 on at
    Hello @FLMike
     
    Thanks you for your response your email,
     
    The look column is configured as in the image below
     
    The List is the lookup is pointing to is called called Machines, gathering the values from the column I have called MachineCodeDesc, the variable is called AreaVAR which I compare to the column Area, also in the Machines list
     
    The dropdown combo box Item property in the custom Power App SharePoint form control is;
     
    Filter(Machines,MachineCodeDesc, AreaVAR=area)
     
    When testing the combobox has no values image below,
     
     
    but I am expecting to have 2 displayed in the drop down.
     
    I hope this is better described
    DWTK
     
     
     
     
     
     
     
     
     
     
     

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

News and Announcements

Welcome to the Power Platform Communities

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 1,070

#2
Valantis Profile Picture

Valantis 639

#3
11manish Profile Picture

11manish 608

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans