cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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.

SPtoPowerApp.JPG

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

 

Thank you!

 

2 REPLIES 2
v-yutliu-msft
Community Support
Community Support

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:

271.PNG

 

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:

272.PNG

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,764)