Filter gallery using Date Picker & Text box in Power-Apps

Like (0) Share

Report

Posted on 3 Feb 2021 16:36:19 by Gkrish23

Hi,

I have been working on an app that I need to filter the gallery by using text box (search) and date picker (Start-date & End-date).

Date-Picker:

text-box:

Gallery Name: Feedback Info - where it contains info such as Area,Created by, Floor Name, Location, Created (date) etc stored in share-point.

Based on the text box values I want to filter the gallery at first, if in-case I want to narrow down further then need to use date range functionality.

For ex: Suppose If I type my name in text box then I will get all the info related to my name in gallery. If I want to check the specific time-period/date between November 2020 to December 2020 using date picker function, this is where I am not getting the exact result.

Code details are as follows for search text-box : (attached) and Date picker: (attached)

Please help assist on this query.

Thanks.

Categories:

Using Apps Using Formulas

General Questions

Date picker-1 cod...

text box code.PNG

I have the same question (0)

All responses (4)

Answers (1)

Gkrish23 6 on 09 Feb 2021 at 11:02:34

Like (0)

Report

Re: Filter gallery using Date Picker & Text box in Power-Apps

@nate_halliwell Thanks for the update. Now I have understood the logic behind the filter function.!!

Kudos to the video as well..!!

Was this reply helpful? Yes No
Community Power Pla... on 08 Feb 2021 at 18:42:43

Like (0)

Report

Re: Filter gallery using Date Picker & Text box in Power-Apps

@Gkrish23 i recently made a video about this exact scenario, actually.... https://www.youtube.com/watch?v=0bRR-Zq407c

essentially you'll need to nest the entire formula from my original post inside of an If(isBlank(CountryDropDown.Selected.Value), ......) formula.

Was this reply helpful? Yes No
Gkrish23 6 on 04 Feb 2021 at 14:16:49

Like (0)

Report

Re: Filter gallery using Date Picker & Text box in Power-Apps

@Anonymous Thanks for the quick response. I am getting the expected results.

What if I want to add a drop-down box along with both Date-picker and search box?

Drop-down box (Items) contain country locations such as India,Thailand etc. Based on the country wise I want to filter the same gallery along with both functions. In that case , what adjustments do we need to make in the code?

Please assist on this..!!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on 03 Feb 2021 at 16:51:02

Like (0)

Report

Re: Filter gallery using Date Picker & Text box in Power-Apps

try this:

If(IsBlank(DatePicker_Start.SelectedDate),If(IsBlank(DatePicker_Start.SelectedDate),If(IsBlank(Searchbox.Text),FeedbackInfo,Filter(FeedbackInfo,Or(Searchbox.Text in Area, Searchbox.Text in Floor, Searchbox.Text in 'Created By'.DisplayName))),Filter(If(IsBlank(Searchbox.Text),FeedbackInfo,Filter(FeedbackInfo,Or(Searchbox.Text in Area, Searchbox.Text in Floor, Searchbox.Text in 'Created By'.DisplayName))),DaveValue(CreatedDate) >= DatePicker_Start.SelectedDate)),Filter(If(IsBlank(DatePicker_Start.SelectedDate),If(IsBlank(Searchbox.Text),FeedbackInfo,Filter(FeedbackInfo,Or(Searchbox.Text in Area, Searchbox.Text in Floor, Searchbox.Text in 'Created By'.DisplayName))),Filter(If(IsBlank(Searchbox.Text),FeedbackInfo,Filter(FeedbackInfo,Or(Searchbox.Text in Area, Searchbox.Text in Floor, Searchbox.Text in 'Created By'.DisplayName))),DaveValue(CreatedDate) >= DatePicker_Start.SelectedDate)),DaveValue(CreatedDate) <= DatePicker_End.SelectedDate))

Was this reply helpful? Yes No