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 / Filter a Power App Usi...
Power Apps
Answered

Filter a Power App Using CRM Entity Status Field

(0) ShareShare
ReportReport
Posted on by 119

I am trying to Filter some CRM records to only contain items that are still open. 

 

The Status field equals 0 (Zero) when the record is open but I can't find how to filter on this. 

 

Trying 

 

Filter(Opportunities, Status = 0) 

 

results in an error that the Status clause has incompatible value types. 

 

Anyone know how to do this?

I have the same question (0)
  • RezaDorrani Profile Picture
    12,145 on at

    Hi @Jonfarmer4999 

     

    Filter(Opportunities,Status = 'Status (Opportunities)'.Active)

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

  • Jonfarmer4999 Profile Picture
    119 on at

    Hi @RezaDorrani 

     

    If I try

     

    Filter(Opportunities,Status = 'Status (Opportunities)'.Active)

     

    The = has the error Invalid Argument Type and the "Active" has the error Name isn't valid. The identifier isn't recognized.

     

    Many thanks

     

    Jon

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

    Hi @Jonfarmer4999 ,

     

    What is the data type of Status field?  it is option set and its items contain Active and Inactive, right?

     

    it should be the form of  Status(Opportunities).** if you want to call option set. The ** is the items you want to filter and can be chosen in the formulas bar. 

    Please refer to following screenshot.

    Annotation 2019-10-08 172952.png

     

    Best regards,

    Sik

  • Jonfarmer4999 Profile Picture
    119 on at

    Hi @v-siky-msft 

     

    It was Status = Open

     

    Thank you for your help.

     

    Kind Regards

     

    Jon

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
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard