cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kaiserfaust
Frequent Visitor

Date Range From DataVerse Table

Good morning!

 

I'm attempting to build a reservation app and I have most of what I need built. I'm struggling on a way to basically filter or perhaps use an IF statement for my date ranges. The two fields I'm attempting to associate the reservation to are the resFrom to the resTo columns, and anything in between (please see DataVerseTable.png). I'll only be printing approved ones. I've also attached screenshots of how the calendar was built, and what items are currently being shown in the gallery.

1 ACCEPTED SOLUTION

Accepted Solutions
Kaiserfaust
Frequent Visitor

Good afternoon Community,

 

I've since figured out my issue and it was a simple fix. Inserting the following function into the  "Items" property of my nested gallery did the trick.

Filter(
tabReservations,
resFrom < ThisItem.NextDay
And resTo >= ThisItem.Value
And resAppStatus = "Approved"
)

See screenshot "ReservationGallery.png" for reference. Hope this helps someone.

View solution in original post

1 REPLY 1
Kaiserfaust
Frequent Visitor

Good afternoon Community,

 

I've since figured out my issue and it was a simple fix. Inserting the following function into the  "Items" property of my nested gallery did the trick.

Filter(
tabReservations,
resFrom < ThisItem.NextDay
And resTo >= ThisItem.Value
And resAppStatus = "Approved"
)

See screenshot "ReservationGallery.png" for reference. Hope this helps someone.

Helpful resources

Announcements
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.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,165)