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

Filter Choices

(2) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hi Guys,

Can anyone explain how to do filter choices to my SharePoint table where I need to filter only the active program instead of all programs , where I added to the program Codes column using site contents two choices active or Inactive.

 Now all data appear when I dropdown the list.

Many Thanks in advanced

Capture 2.PNG
Capture 1.PNG
Capture 3.PNG
Categories:
Building Power Apps
  • mdevaney Profile Picture
    mdevaney 29,993 Moderator on at

    @Anonymous 
    Put this code in the Items property of your dropdown instead.

    Filter('Program Codes', 'Active Program'="Active Program").Code


    ---
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Thanks for replaying me,

    I just want to let you know that my table name in SHAREPOINT is Demo CC Usage and there is a column named Program Code and a pic will be attached for that column (Capture 4).

    there are two option active or inactive and I need to filter the active only.

    And If you please open the another attached pic (Capture 5) to see the item property to my form field.

    thanks again.

    Capture 5.PNG
    Capture 4.PNG
  • Verified answer
    v-bofeng-msft Profile Picture
    v-bofeng-msft Microsoft Employee on at

    Hi @Anonymous :

    Could you tell me what Program_x0020_Code's data type is?Lookup?Choices?

    Please try this solution:

    set the Item's property to:

     

    Filter(
 Choices([@'Demo CC Usage'].Program_x0020_Code),
 Value in Filter('Program Codes','Active Program'='Active Program').Code
)

     

    Or

    Filter(

        Choices([@'Demo CC Usage'].Program_x0020_Code),

        Value in Filter('Program Codes','Active Program'='Active Program').Title

    )

    Best Regards,

    Bof

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi again,

    First thanks for replying me but I've got an error message and please if you have any suggestion to help.

    Many thanks 

    Capture 6.png
  • mdevaney Profile Picture
    mdevaney 29,993 Moderator on at

    @Anonymous 
    PowerApps does not recognize 'Program Code' or 'Active Program'.  You might have mistyped in the SharePoint list name with or you did not connect the SharePoint list to your app.

     

       

     

  • v-bofeng-msft Profile Picture
    v-bofeng-msft Microsoft Employee on at

    Hi @Anonymous :

    I strongly agree with @mdevaney .Please check if you connect the SharePoint list('Program Codes') to your app.

    Best Regards,

    Bof

  • v-bofeng-msft Profile Picture
    v-bofeng-msft Microsoft Employee on at

    Hi @Anonymous :

    Has the problem been solved?

    Is there anything else I can help?

    If the post is helpful, please consider accepting it as a solution to help others

    Best Regards,

    Bof

  • Verified answer
    Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    hi @v-bofeng-msft 

    Thanks for your help , to solve the problem I have created a new collection called 'programStatus' that can read the Program Code columns 

    Collect(programStatus,ShowColumns('Program Codes',"Active","Title"))

    And for the requested field I did filtering 

    Filter(programStatus,Active.Value="Active")

     

    Thanks again for ypur help

     

  • JuanArenas Profile Picture
    JuanArenas 2 on at

    Hi guys, i have been suffering for being able to create a form that let to the user create or update info of the participants in a project so i created two sharepoint list with the firs i created the entrys or the log for all of the projects that the organization currently have, so when the user starts the app would only see the projects in wich he or she is encharged. For the second list i have several problems, the most importan is that when i created a form for the reporting process ( in which it must be attached info ) the form shows all of the projects currently these are the structure for the items properties:

     

    LIST1: Filter('Registro de Proyectos y Servicios','Lider Funcional'.Email=User().Email)

     

    LIST2: Choices([@'Reporte de Empresas'].NombrePS)

     

    eventhough i have the filter function into the first list the second does not show the records for the current user,

     

    I do not know what i am doing wrong !!!

     

    thanks 

  • Numan Profile Picture
    Numan 4 on at

    Solved my problem. Thanks!

     

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

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 August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 382 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 329

#3
WarrenBelz Profile Picture

WarrenBelz 187 Most Valuable Professional

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