Create Gantt Chart

(0) Share

Report

Posted on by Hii_iii

691

Hello, I am trying to create a diagram similar to the picture below.

But I can't, when I try I don't have the colored bars displayed.

I have something like that :

All properties that I have :

Indicator Label :

Fill : If(ThisItem.Status.Value="Not Started";White;If(ThisItem.Status.Value="Active";Orange;If(ThisItem.Status.Value="Delayed";Red;If(ThisItem.Status.Value="Completed";Green;Gray))))

X : Value(StartDays.Text) * 'Gantt Tasks_1'.Width/365

EndDays Label :

Text : DateDiff(Date(Year(Now());1;1); DateValue(EndDate.Text))+1

EndDate Label :

StartDays Label :

DateDiff(Date(Year(Now());1;1); DateValue(StartDate.Text))+1

StartDate Label :

Can you help me please ? Thanks in advance 😞 !

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Hi,

To save you some time - Someone has already gone through the trouble of doing this so you don't have to - you can get it from the community samples here and then tweak it for your needs:

Gantt-like Display Using Standard Power Apps Contr... - Power Platform Community (microsoft.com)

Cheers,

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

I saw it but I didn't understand. His tutorial is way too complex for me 😕

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

oh, well he included the actual .msapp so that you could copy out the contents and modify it for your own needs rather than a full tutorial

You can look at this tutorial for a step-by-step:

GanttChart Using Microsoft PowerApps (c-sharpcorner.com)

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

As you can see in my post, this is exactly the tutorial I followed but it doesn't work as you can see 😕 @iAm_ManCat

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report

Yeah, that's not a great tutorial to be honest, their naming convention is poor and they have way too many unnecessary items.

I will put together a blog on this sometime soon, but there's the test .msapp I created as a proof of concept - you can use File> Open to browse for this .msapp file and then open it - those few labels and galleries are what you need for a basic gantt - feel free to copy them out of that app into your own.

Any issues copying it to your App then please let me know,

Ciao,

Gant Test.msapp

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

I recovered the file but I can't adapt it with my SharePoint data :c @iAm_ManCat

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

If you select the error notification it will take you to the formula that is erroring - this will likely be the name of the list, the names of the startdate and enddate columns, the status, and the description(title).

You will need to change these to match the naming and column types of your datasource

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (1)

Report

It's work !

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (1)

Report

It's work thank you ! C:

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report
Excellent, glad I could help!

One minor fix:

lblIndicator.X

change to:

Value( DateDiff( Date( Year(Now()), 1, 1 ), ThisItem.StartDate ) + 0 )* (galBodyMonths.Width / 365)

and

lblIndicator.Width:

(Value( DateDiff( Date( Year(Now()), 1, 1 ), ThisItem.EndDate ) + 1 ) - Value( DateDiff( Date( Year(Now()), 1, 1 ), (ThisItem.StartDate + 0) ) )) * (galBodyMonths.Width / 365)

This should fix them starting too far from left and the gaps between items 🙂

Was this reply helpful? Yes No