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
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,524)