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 / Adding an Addtional fi...
Power Apps
Unanswered

Adding an Addtional filter to my FX

(0) ShareShare
ReportReport
Posted on by 643

I have the following:

 

If(
    !IsBlank(TextInput2_4.Text),
    (Search(
        'WTRF Database',
        TextInput2_4.Text,
        "Assigned_x0020_To_x0020_Job",
        "Tool_x0020_Number_x0020_Text",
        "WTRFNumber",
        "Customer_x0020_Text"
    )),
    Sort(
        'WTRF Database',
        'Priority Order'.Value,
        SortOrder.Ascending
    )
)
 
And I would like to filter this list by Status value = "In Progress". At the moment it shows all statuses. Where would I fit it?
Categories:
I have the same question (0)
  • Micky Profile Picture
    365 Moderator on at

    You can filter the Search datasource with the status that you want, like the code below.

    Filter('WTRF Database',Status = statusControl.Selected.Value)

     

    This is what it looks like when adding it to your code.

     

    If(
     !IsBlank(TextInput2_4.Text),
     (Search(
     Filter('WTRF Database',Status = statusControl.Selected.Value),
     TextInput2_4.Text,
     "Assigned_x0020_To_x0020_Job",
     "Tool_x0020_Number_x0020_Text",
     "WTRFNumber",
     "Customer_x0020_Text"
     )),
     Sort(
     'WTRF Database',
     'Priority Order'.Value,
     SortOrder.Ascending
     )
    )

     

     

  • jamescosten Profile Picture
    643 on at

    Gat an error

     

    jamescosten_0-1707468110948.png

     

  • jamescosten Profile Picture
    643 on at

    @MMPoweR Fixed it by adding .value to status. However the gallery is now showing items, but they are not filtered. 

     

    jamescosten_1-1707468798071.png

    It is showing all status.

     

    jamescosten_2-1707468835791.png

     

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

wolenberg_ 119 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 107 Most Valuable Professional

#3
Haque Profile Picture

Haque 103

Last 30 days Overall leaderboard