web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Have issue with galler...

Power Apps

Unanswered

Have issue with gallery, filter and datepicker.

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

Can someone help me to do multi filtering/search with text input and date picker.

I have 1 Text input called: TextSearch

I have 1 Date picker called: DateSearch

What i want is to be able to combine both in searches, to only view specific date in DateSearch and be able to Search or filter out entrys "Datacards".

I tried with a ComboBox but thats Not something that i want to use.

My sharepoint list is [@'My_SP_List']

My colums in splist is:

At the moment I'm using the filter below but it only does the "StartsWith" and i would like to be able to search with different criterias and not only one column:

Filter([@'My_SP_List'],StartsWith('Reporting user?'.Email,TextSearch.Text))

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

wyotim 2,545 on at

Like
a
(1)

Report
Copy link

Link copied!
Hey @Anonymous, try this:

Filter( 'My_SP_List', StartsWith( 'Reporting user?'.Email, TextSearch.Text ), (DateColumn = DateSearch.SelectedDate || IsBlank(DateSearch.SelectedDate)) )

The IsBlank part checks if the date picker is blank and returns true. What this does is skip the date filter part if that is the case, only using the StartsWith portion of the filter. You could also simplify it (if you will always have a date in the date picker), like so:

Filter( 'My_SP_List', StartsWith( 'Reporting user?'.Email, TextSearch.Text ), DateColumn = DateSearch.SelectedDate )

Please let me know if that doesn't work or if I can try to help out further!

Join the conversation