Power Platform Community Forum Thread Details

I have an app for our employees to track everyone's time off for scheduling purposes. I have 2 galleries: a horizontal one that gets a week's worth of days and dates, and that's nested inside a vertical gallery to get the whole month. This is to make a sort of calendar (shown below).

The app can show and update people's time off within this calendar, and I have 4 text boxes within each day that shows people's time off on that day. When one person's time off ends, the next time off record will move up a row; as it is now the first one in the list (shown below). What I am hoping to do is if one record starts in row 3 for example, I want it to stay in row 3 until their time off ends.

Below is the code I use in the first textbox in the galleries. Essentially, it gets the first 4 records that contain a date range that intersects with the current cell's date value and gets the title (this one is for the first textbox, so it indexes the first result, the second textbox would have the same code but indexing the second result, etc).

With(

{

tableFilter:

FirstN(

Filter(

'Time Off Calendar Tracking',

And(

'Time Off Start' <= DateValue(lblFullDate_Invisible.Text),

'Time Off End' >= DateValue(lblFullDate_Invisible.Text)

)

), 4

)