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
Dual Super User
Dual 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
Dual Super User
Dual Super User

Have you try:

 

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

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (2,588)