web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Gantt Chart in Power Apps
Power Apps
Unanswered

Gantt Chart in Power Apps

(0) ShareShare
ReportReport
Posted on by

Hi all,

 

I've created a nice looking simple gantt chart in Power Apps to have an overview of our firm's projects. I've followed this great video and it's working well. Data is a SP list in my case.

I've got two issues:

  1. It doesn't work well for projects which started before this year, 2022 - I'd like them to be displayed like starting on 1.1.2022 with End date coming from the SP list. I have the following formula in the width  property of the label placed in a gallery:

 

If((Value(EndDays.Text) - Value(StartDays.Text)) * GanttProjects.Width / 365 > DateDiff(_StartDate, _EndDate), (Value(EndDays.Text) - 0) * GanttProjects.Width / 365,(Value(EndDays.Text) - Value(StartDays.Text)) * GanttProjects.Width /365)​

where EndDays.Text is DateDiff(Date(2022,1,1), DateValue(_EndDate.Text))+1
_EndDate.Text is simple the End Date from the SP list
where StartDays.Text is DateDiff(Date(2022,1,1), DateValue(_StartDate.Text))+1
_StartDate.Text is simple the Start Date from the SP list

But for some of the projects in the gallery this doesn't work. Is there a way how to say that if they started before 1.1.2022 to make them appear like starting there and then just put the End Date to the correct position?

 

  • Second one might be easier - I have a combobox which should filter the items in the gallery based on the Geographic Impact field. That field is a multi-choice column in SP list. User can only select one item in the combobox.

    If he selects global, he'll see all projects with Geographic Impact being global, but for those items where there is more items selected, including Global, they'll not appear - so the item can have both Global and Europe in the Geographic Impact column and that will not appear. I have the following formula for that, any chance this can be improved?

 

(Concat(
 'Geographic impact',
 Value,","
 ) in GeographicImpactCombobox.Selected.Value || GeographicImpactCombobox.Selected.Value = Blank())​

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 445

#2
WarrenBelz Profile Picture

WarrenBelz 386 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 321 Super User 2025 Season 2

Last 30 days Overall leaderboard