Power Platform Community Forum Thread Details

Hi Experts

I have a SharePoint List, HolidayApp_Data. HolidayApp_Data contains the columns
Title, StartTime, EndTime, Status, Id and CalculatedDaysOff.
In PowerApps, I have a collection, colVacationEvents. colVacationEvents is based on HolidayApp_Data,

ClearCollect(
colVacationEvents,
Filter(
HolidayApp_Data,
varIsManager,
Omk=varO365User.companyName,
Status.Value = "Approved"
)
)

The same Title entry can appear several times in HolidayApp_Data (therefor also colVacationEvents), but with diffrent StartTime and EndTime.
In PowerApps I have a Gallery, gal_VacationView.
gal_VacationView shows all Title sorted alphabetically and distinct(),
since I only want Title once, despite the fact that Title can appear several times in HolidayApp_Data and thus also in colVacationEvents.
To the right of the Title column in gal_VacationView I have another Gallery, gal_Border. gal_Border shows at the top the Month, week and the dateperiode for that week.
Now I then want each StartTime and EndTime periode (calculated in days) that correspond with the Title to the left, be placed in the right column that correspond with the right month and week.
So CalculatedDaysOff (DateDiff between StartTime and EndTime) should be placed in the label with ? under the right month and week