cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rdcelestial
Regular Visitor

Galleries GroupBy and Filter using a datepicker.

Im trying to filter my Event list in  Gallery by GroupBy and TextSearchBox, I wonder how I could combine these two function to work on my gallery.  

 

GroupBy is working perfectly alone

 

 

 

 

GroupBy(EVENT_LIST,"Event_Start_Date","Booking_Post_As","Status_Abbrv","Account")

 

 

 

 

Filter is working  as well  alone

 

 

 

 
Filter(EVENT_LIST, TextSearchBox1.Text = Event_Start_Date)

 

 

 

  Event_Start_date = is converted date to text column.  

 

What I'm trying to archive is to only show the selected date. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
gabibalaban
Super User
Super User

Have you try:

 

GroupBy(Filter(EVENT_LIST, TextSearchBox1.Text = Event_Start_Date),"Event_Start_Date","Booking_Post_As","Status_Abbrv","Account","GroupByResult")

View solution in original post

1 REPLY 1
gabibalaban
Super User
Super User

Have you try:

 

GroupBy(Filter(EVENT_LIST, TextSearchBox1.Text = Event_Start_Date),"Event_Start_Date","Booking_Post_As","Status_Abbrv","Account","GroupByResult")

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,111)