cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

Click button only show me todays boookings

Hi everyone

 

Need some help with the following.

 

I have a booking system and to make users life easy, I'd like the option for a user to click on a today button, for them to view only bookings for today, how do I do this please?

What is the best way to achieve this, I will want button for tomorrow too if this works nicely

1 ACCEPTED SOLUTION

Accepted Solutions
Helper II
Helper II

I am assuming your data is in a gallery? If not please specify 

 

Set the button On Select to: Set(viewtoday,true)


Set the gallery Items to: If(viewtoday=true,Filter(yourdatasource,Date=Now(),Filter(yourdatasource))

 

Let me know if you need any more help

 

Date Reference

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-date-time

 

Filter Reference

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

View solution in original post

3 REPLIES 3
Helper II
Helper II

I am assuming your data is in a gallery? If not please specify 

 

Set the button On Select to: Set(viewtoday,true)


Set the gallery Items to: If(viewtoday=true,Filter(yourdatasource,Date=Now(),Filter(yourdatasource))

 

Let me know if you need any more help

 

Date Reference

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-date-time

 

Filter Reference

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

View solution in original post

hi @Maxwell123 

I was on the right track based on your suggestion but couldn't get it to work Thanks for your help

 

If(vToday = true, Filter(List, ArrivalDate = Today()),  List)

 

No problem! If you need anymore help with your app write a new post and tag me!

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (26,788)