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 Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

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 (3,833)