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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter / Search Issue
Power Apps
Answered

Filter / Search Issue

(0) ShareShare
ReportReport
Posted on by

Hi Folks,

 

Havinga an issue trying to filter a Gallery with the Data Source 'Visitor Registration'.

Trying to filter the Data Source 'Date_x0020_and_x0020_Time_x0020' where its blank and from a Search Box 'TextInput2'

 

Got this so far, but cant seem to get it working:

 

Sort(If(IsBlank(TextInput2.Text), 'Visitor Registration' , Date_x0020_and_x0020_Time_x0020_ = Blank(), Filter('Visitor Registration', TextInput2.Text in Text(Title), Date_x0020_and_x0020_Time_x0020_ = Blank())), Title, Ascending))

 

Any help would be much appericated! 

Categories:
I have the same question (0)
  • Verified answer
    ViStr Profile Picture
    29 on at

    Blair, hi.

    Seems that you have missed some function in second argument of IF statement.

     

    You could try something like that:

    Sort(If(IsBlank(TextInput2.Text),Filter('Visitor Registration',Date_x0020_and_x0020_Time_x0020_ = Blank()),Filter('Visitor Registration',TextInput2.Text in Text(Title),Date_x0020_and_x0020_Time_x0020_ = Blank())),Title,Ascending)

     

  • Community Power Platform Member Profile Picture
    on at

    Much Appericated!

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard