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 / Use Filter Function fo...
Power Apps
Answered

Use Filter Function for Value > 0

(0) ShareShare
ReportReport
Posted on by 39

I'm hoping this is just a small syntax error. I'm trying to get a gallery to display records only when the value from a specific column is 1 or higher (basically, when one specific employee has at least one item in a given row/record checked out from the office). Currently the gallery works if I leave the code as simply drawing data from my collection ("OnHand," generated when I hit the "refresh" button), but if I try to filter as "Filter( OnHand, With_x0020_April > 0 )" I get an error that it was expecting a number value, and if I try "Filter( OnHand, With_x0020_April.Value > 0 )" I get a message that "." is invalid. Can anyone suggest an alternate syntax?

Screen Shot 2020-01-28 at 11.27.28 AM.png
Categories:
I have the same question (0)
  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Try Value(With_x0020_April) instead of just 'With_x0020_April'

  • Verified answer
    mdevaney Profile Picture
    29,991 Moderator on at

    @LauradeBoer 

    My first guess would be that With_x0020_April is not a number data type.  Perhaps its text or something else.  What happens if you do this>

    Filter(OnHand, Value(With_x0020_April) > 0)

     

    I know it will throw a delegation warning but do any results show in the gallery?

     

    ---
    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."

  • LauradeBoer Profile Picture
    39 on at

    That's got it! Thank you both!

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 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard