Use SharePoint Project Status List as a PowerApp with Gantt Chart Type of View

[Anonymous]

Hi

I'm new to PowerApps and thought that I could use this use case as a means to start learning how to use it.  Someone in our organization has asked for a SharePoint list that has current projects with the project start and end dates to be displayed like a gantt chart.  The list has just a few columns:

• Project Name (Original Title Field - Single Line of Text)
• Manager (Single Line of Text)
• Start Date (Date Only)
• End Date (Date Only)
• Status (Single Line of Text)
• Health (Single Line of Text)

Basically, they want a gantt chart visualization of the Start Date through the End Date at the month level.  The gantt chart feature in SharePoint views no longer works on modern sites.  So, I used json to do some trail and mostly error and got something like this, but it is ugly.  So I thought that PowerApps might be the next level up to make it even better.

Any help on how to get this into a PowerApp and format the list for a gantt chart view would be appreciated.

Thank you!

[v-yutliu-msft]

Hi @Anonymous ,

Do you want to generate a picture based on start date and end date like the pic that you showed?

I'm afraid it's not supported to generate picture like your picture by using data in table directly currently in powerapps.

However, I've found an alternative way to display data like your picture.

I suggest you try to use gallery, which could change the label's color based on its data.

I've made a similar test for your reference:

1)Firstly, you need to generate a collection based on start date and end date:

ClearCollect(a,AddColumns(b,"jan",If(Month(startdata)=1||Month(enddata)=1,true,false),"feb",If(Month(startdata)=2||Month(enddata)=2,true,false),"mar",If(Month(startdata)=3||Month(enddata)=3,true,false),.....))

In this way, you will generate a collection will the data of month.If the project's work time is within this month, its data is true.Or else. its data is false.

Just like this:

2)insert a gallery, insert 12 labels inside the gallery.

Set label1's Text:

ThisItem.jan

set label1's Fill:

If(ThisItem.jan=true,Blue,White)

Set label2's Text:

ThisItem.feb

set label2's Fill:

If(ThisItem.feb=true,Blue,White)

.....

Insert 12 lables outside the gallery, set their Text like this:

"jan-2020"     "feb-2020"   ,.......

Then you will get data like the picture:

Best regards,

[Anonymous]

Thanks

I actually don't want it to be a picture or look like the picture that I provided.  The picture was provided only to show what I've done in a SharePoint list so far.  Now I want to take it to the next level (either PowerApp or PowerBI, whichever is best for this case) and provide the list data with a gantt chart visual at the month level.  So, instead of there being individual colored cells for each month, there would be a solid bar that would go left to right across the appropriate months based on the start and end date fields.  It should look like a gantt chart when completed.  I first would like to know if this should be done as a PowerApp or PowerBI.  I see that there are controls in the SharePoint list to start a PowerApp from the list, but I could also see that PowerBI can be created and placed on a SharePoint page.