Answered

Horizontal Gallery Template Size and Gantt Chart construction

(2) Share

Report

Posted on by zuurg

546 Super User 2024 Season 1

I'm putting a Gantt Chart together based on data in a SharePoint list. In my list, a record has a Start Date and an End Date.

The Horizontal Gallery contains the months that stretch from the earliest activity start date until the month of the latest ending activity. The Horizontal Gallery contains a nested Vertical gallery which displays the record's Activity name, with the X being calculated on the number of days since the 1st of the earliest month of activities, multiplied by the number of pixels that a day represents.

The issue that I have is that since not all months contain the same number of days, if I have a long activity, the length of the activity stretches past the End Date because it's going on the number of days instead of what the calendar looks like. I hope that makes sense.

In this example, Deliverable 4 is showing as stretching into the beginning of Jan 2026, even though the Start Date is 12/01/2024 and End Date for it is 12/31/2025 (duration is 396 days):

Is there a way to set the widths of the Horizontal gallery to be variable based on the number of days in that month to make the calculation work properly? Does anyone have a better approach to this?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

BCBuizer 22,718 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi @zuurg,

The below formula should do the trick for the Width property control inside the vertical gallery that displays the activity name:

( Day(ThisItem.StartDate) / (EoMonth(ThisItem.StartDate,0)) + (DateDiff(ThisItem.StartDate, ThisItem.EndDate, TimeUnit.Months) - 1) + Day(ThisItem.EndDate) / (EoMonth(ThisItem.EndDate, 0)) ) * HorizontalGallery.TemplateWidth

This works by adding the fraction of the first month, the number of full months in between the start- and enddate and the fraction of the last month and then multiply this by the width of a month (HorizontalGallery.TemplateWidth). Like this, the number of days in each month becomes irrelevant.

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
zuurg 546 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Thanks @BCBuizer!

This was still a little off, but the logic behind your solution was exactly what I was looking for by treating the first month, months in between, and last month as 3 separate pieces to add together.

This is what I ended up with:

// Starting Month ((DateDiff(ThisItem.'Start Date',EOMonth(ThisItem.'Start Date',0),TimeUnit.Days) + 1) / Day(EOMonth(ThisItem.'Start Date',0))) * gal_MonthYear.TemplateWidth + // Ongoing Months (DateDiff(ThisItem.'Start Date',ThisItem.'End Date',TimeUnit.Months) - 1) * gal_MonthYear.TemplateWidth + // Final Month Day(ThisItem.'End Date') / Day(EOMonth(ThisItem.'End Date',0)) * gal_MonthYear.TemplateWidth

Was this reply helpful? Yes No