Just came across this and it looks great and exactly what I was looking for. I will use your step by step as a start and try to add in more as I go along.
Great video for task based items. Have you got any suggestions to show multiple bookings on an item on a gantt chart. For example show all the booking on a room and the room ID is listed on the left column.?
Thanks for the video ! But how to make it add a new box for indicator everytime i add a new task ? what it does is that it has one only indicator box and everytime i change the details of a task it modifies the old one ! thanks for your response in advance
Thank you for this video ! This was extremely helpful ! i have only one question , what if i would like to make to indicator colored bar editable, after adding a task,, and by changing the indicator, the Date value changes also with it ?
This is great! I would like to ask if is it applicable if you selelct start and end date with different year? like Start is June 2020 and End is January 2021?
Hi there, this video has been huge in my development, it has taught me so much. Any chance that you could help out with maybe adding a toggle which would focus on a 3- and 6-month view? expanding the indicator giving it a kind of zoom in capability?
Awesome video! Would you be able to describe how you spaced out the tasks based on category and added the labels to the left of the charts in the advanced version? I have mine sorted by category but looking to add that little bit of space between them and grouped with the label. Thanks!
Absolutely, I used Blank Flexible Height Gallery. I'm having difficulty re-importing my App, but when I get it working, I'll follow up with some more info. But basically you set the items to Distinct(DataSource,ColumnName) and inside there you have a label for each category item, and another gallery, which you set the items to Filter(DataSource, TextBox.Value in Column) to return just those specific rows. That gallery works like the one I set up in the walkthrough.
Thank you so much for sharing this video! This was so great! I am wondering if there is a way to save all tasks into a sharepoint at the same time keep the Gantt chart?
Thanks for watching (and the Twitter follow)! You can absolutely use a SharePoint list to hold these, just create a new list in SharePoint with the fields mentioned in the Collection, and set up a link. Then change the references to the collection to the List. Good luck with it!
This was a great video, thanks a lot for taking the time to make this it helped me a lot. Is there a way to create the same with a 2 day view and just time?
You're welcome! It's not a lot of work to convert it to a different length view. Figure out how you want to break down the days, hours? Half hours? Quarter hours? And the amount of those for two days will be what you divide by, instead of the length of days in the year. Reach out on Twitter (@powerapproadmap) if you need any more help, and definitely let me see the results!
Hi Andrew, do you mean saving the additions to a SharePoint list or external data source? I haven't covered that in any video yet, I'm relatively new to making videos and some of the PowerApps rockstars on CZcams have already covered that kind of thing. Shane Young is a great resource: czcams.com/video/MclJ_O9HvJQ/video.html Thanks for your kind words. You're not the only person to ask about this, so a companion video might happen!
Před 10 měsíci
First of all, thank you very much, that was a very helpful video! Is there a way to view the final version? So the Gantt chart after minute 44:21
Před 10 měsíci
Or is there a way to contact you, unfortunately you can no longer be found on X?
Hello, Thanks for this great video. I'm looking to know how you configured the drop-down list at the end of the video to change the status of the recorded task? (In the blue part)
Thank you! So, the update drop-down will depend on what you're using for your data source. For my demo, using a local collection, I want to add a function to the OnChange property of the dropdown. Patch(NameOfCollection,First(Filter(NameOfCollection,ID=SelectedItemID)),{Status:CurrentSelectedDropDownOption}) in this case NameOfCollection is your Collection where you're storing the items ID is any field with unique content SelectedItemID is the content of that field for the current selected item Status is the name of the field you're updating CurrentSelectedDropDownOption is Your dropdown's name with the path .SelectedText.Value after it. Hope this gets you started. Reach out on Twitter if you want to chat about it more, @PowerAppRoadMap - and let me see your finished project! Thanks again!
Is there a way to make the gantt chart formatted to support projects that span beyond 1 year? I know this will complicate things significantly since the formulas all have been developed around a 12 month timeline.
Hi, thanks for watching. You should establish the absolute maximum end point for your actions, and use that in your formula. For example, if you have activities that span 20 months, you change the month striping width to (stageWidth/20) and instead of dividing by 365, divide by how many days are between your start and end date. You could calculate this manually, or, make a 'set up' screen with date pickers for start and end date, and use the DateDiff formula to calculate the amount of days between the two. My day job is priority just now, but I do intend to revisit this build to address stuff from the comments, and I'll include this aspect
@@WorldOfPlatform Thank you this is helpful. I've developed an excel calculator that builds project timelines so the dates are uncertain, sometimes the projects start/end within 6 months sometimes years. Any tips you can provide to manage this uncertainty plus the timelines can span years sometimes are greatly appreciated. This would be a great addition to a future video. Also, if you could talk about ways to connect to databases that would also be super helpful! Great job!
Could you explain how to create the status drop down in lieu of the status label like you did in the video. Also the steps to creating that user and category option as well?
Hi Dominique! Sure. add your drop down input, and set Items to ["active","complete"] or whatever you want your options to be, then using the OnChange property for the dropdown, you need to add a function in here to Patch the record with its new status. Patch( YourCollectionName, First( Filter( YourCollectionName, YourIDField= -CurrentItemID- ) ), { status: dropdownMenu.Selected.Value} ) Where YourCollectionName is the name of your datasource, YourIDField is the name of whatever you're using as your unique ID, CurrentItemID should be a reference to the current selected item, and dropdownMenu should be whatever you've called your Drop Down Menu. This video has just under 3500 views, way more than any of my other videos and way way more than I ever expected any of my videos to get. You're not alone in asking about the end version of the app, and I'm planning on revisiting this and covering the stuff I glossed over in this video.
Can you give me an example of the unique ID from your video. I used the tutorial verbatim to see if it would work. I need the code for the drop down and steps for the adjacent box. I am trying to solve for something and this video had everything except the last two things 😞
Absolutely! In my example I created an ID field (in the formula around 09:00 ). If your naming conventions are the exact same as mine, your patch formula to change the status will be: Patch(TaskList,First(Filter(TaskList,ID=GanttTasks.Selected.ID)),{Status: dropdownMenu.Selected.Value}) . dropdownMenu is whatever you named the status drop down you swapped in for the label at the bottom. for the dark blue box, the dropdown there would have an Items property of Distinct(TaskList, AssignedTo) to populate it with each of the people. The two labels below that, you can do a count of matching users with the formula CountIf(TaskList,AssignedTo = UserDropDown.Selected.Value) where UserDropDown is the name of your new dropdown menu. To calculate the average, you can use the formula SUM(Filter(TaskList,AssignedTo = UserDropDown.Selected.Value),DateDiff(DateValue(StartDate),DateValue(EndDate)))/CountIf(TaskList,AssignedTo = UserDropDown.Selected.Value) To break that down, We are filtering TaskList to only return records where AssignedTo is your selected user, then we are going to take the difference between the start date and end date for each of those rows, and sum them together, and then divide that by the count of rows that match that assigned to person. I don't have the app easily available to just send you the code, but what I've typed above should be pretty close to right. If you're having trouble, break the calculation down into parts, I'll check back in when I've had a chance to pull the formula from my app.
Hye. I already can do it the gantt chart base on your video.. but i want to change the colour by category ( like the end of your video ) can you show how you do it. I really need your help.
Sorry about the delay in responding. Yes! In the Fill control for your label, you can use an If statement to control the color. This example will change the color based on who the task is assigned to: If(ThisItem.AssignedTo = "Person 2", RGBA(108, 92, 231,1.0) RGBA(179, 55, 113,1.0)) You can continue adding IFs to that formula, but this quick version will color Person 2 tasks a different color from everyone else. Change the column ThisItem is looking at if you want to by a different metric. Good luck!
You want to add Nested Galleries. Set your background gallery to get the striping, then Add a blank gallery with variable height. The source of this gallery should be set to your DataSource with a distinct operator for the category field. So now this gallery will have as many items as you have categories. Then inside that gallery, add a new gallery like in the video. the source for this gallery will be set to a Filter on your DataSource where category matches ThisItem (the category name). That should get you on your way to the solution. Let me know how you get on, thank you for watching.
Not yet, message me on Twitter and I can send you a copy. The idea is to publish working documents on a blog site to accompany the videos. I'm glad you enjoyed the video.
You've put substantial effort into this explainer video, thank you @PowerApps Road Map. It's content-wise of very high quality. I hope you continue soon submitting more of these... Is there a way to access your Gantt chart sample code?
Hi John. I built this demo using a local collection. If you want to store the data somewhere and recall it, there's a lot of great videos that can help with this. I haven't personally covered the topic, but Shane Young has - czcams.com/video/gX5q_V3U8-s/video.html Your SharePoint list will need to have all the fields in it that we create in the video, and then the button would Patch that data to the list. The chart itself would then use the SharePoint list as it's data source to display the data. Hope that helps. I can try and make a companion piece talking through saving the data to a list in the future. If you need any more help you can always reach out of Twitter too (@PowerAppRoadMap). Thanks for watching!
@@johnbrennan8442 Do you mean the bars for each task? When you have your data saving to SharePoint or an external source, you'll update the gantt chart gallery's data source control to that external source too. If you set up a SharePoint List called GanttTasks and save the form data to that, you'd change the Gallery controls to read the data from that list.
Just came across this and it looks great and exactly what I was looking for. I will use your step by step as a start and try to add in more as I go along.
This was great! Thank you so much. I didn’t create a Gantt chart but it helped me to create a delivery roadmap !!
Hi. Great video. What is the formula you use for the advance Gantt chart to display the vertical line representing the current date?
Saved my life! THANK YOU!
Glad it helped!
Great video, really appreciate the in depth review.
The presentation is good and clear
Hi, Great video. Could you do a video for the Part 2? It is very interesting and I like how you explained it. Keep up with the good work.
Excited to check this one out - Is there a way to have two tasks on the same line?
THANK YOU! Very useful!
You're welcome! It's not a common need in PowerApps, but it's definitely a useful layout if you have the data to support it.
Great video for task based items. Have you got any suggestions to show multiple bookings on an item on a gantt chart. For example show all the booking on a room and the room ID is listed on the left column.?
Thanks for the video ! But how to make it add a new box for indicator everytime i add a new task ? what it does is that it has one only indicator box and everytime i change the details of a task it modifies the old one ! thanks for your response in advance
Awesome 🎉🎉🎉🎉
Thank you for this video ! This was extremely helpful ! i have only one question , what if i would like to make to indicator colored bar editable, after adding a task,, and by changing the indicator, the Date value changes also with it ?
This is great! I would like to ask if is it applicable if you selelct start and end date with different year? like Start is June 2020 and End is January 2021?
So much helpful , just had one question , how to update a task with new dates?
Hi there, this video has been huge in my development, it has taught me so much. Any chance that you could help out with maybe adding a toggle which would focus on a 3- and 6-month view? expanding the indicator giving it a kind of zoom in capability?
Awesome video! Would you be able to describe how you spaced out the tasks based on category and added the labels to the left of the charts in the advanced version? I have mine sorted by category but looking to add that little bit of space between them and grouped with the label. Thanks!
Absolutely, I used Blank Flexible Height Gallery. I'm having difficulty re-importing my App, but when I get it working, I'll follow up with some more info.
But basically you set the items to Distinct(DataSource,ColumnName) and inside there you have a label for each category item, and another gallery, which you set the items to Filter(DataSource, TextBox.Value in Column) to return just those specific rows. That gallery works like the one I set up in the walkthrough.
Thank you so much for sharing this video! This was so great! I am wondering if there is a way to save all tasks into a sharepoint at the same time keep the Gantt chart?
Thanks for watching (and the Twitter follow)! You can absolutely use a SharePoint list to hold these, just create a new list in SharePoint with the fields mentioned in the Collection, and set up a link. Then change the references to the collection to the List. Good luck with it!
This was a great video, thanks a lot for taking the time to make this it helped me a lot. Is there a way to create the same with a 2 day view and just time?
You're welcome! It's not a lot of work to convert it to a different length view. Figure out how you want to break down the days, hours? Half hours? Quarter hours? And the amount of those for two days will be what you divide by, instead of the length of days in the year.
Reach out on Twitter (@powerapproadmap) if you need any more help, and definitely let me see the results!
Hey man, thanks a lot!
You're welcome!
Great tutorial
👏🏼👏🏼👏🏼👏🏼👏🏼
very cool, but what happens when a task straddles 2 years ?
This is a brilliant video. Did anyone see if there was a section on updating the server data from the client edits?
Hi Andrew, do you mean saving the additions to a SharePoint list or external data source? I haven't covered that in any video yet, I'm relatively new to making videos and some of the PowerApps rockstars on CZcams have already covered that kind of thing. Shane Young is a great resource: czcams.com/video/MclJ_O9HvJQ/video.html
Thanks for your kind words. You're not the only person to ask about this, so a companion video might happen!
First of all, thank you very much, that was a very helpful video!
Is there a way to view the final version? So the Gantt chart after minute 44:21
Or is there a way to contact you, unfortunately you can no longer be found on X?
@32:00 using Remove without First seem to work fine.
Hello,
Thanks for this great video. I'm looking to know how you configured the drop-down list at the end of the video to change the status of the recorded task? (In the blue part)
Thank you! So, the update drop-down will depend on what you're using for your data source. For my demo, using a local collection, I want to add a function to the OnChange property of the dropdown.
Patch(NameOfCollection,First(Filter(NameOfCollection,ID=SelectedItemID)),{Status:CurrentSelectedDropDownOption})
in this case
NameOfCollection is your Collection where you're storing the items
ID is any field with unique content
SelectedItemID is the content of that field for the current selected item
Status is the name of the field you're updating
CurrentSelectedDropDownOption is Your dropdown's name with the path .SelectedText.Value after it.
Hope this gets you started. Reach out on Twitter if you want to chat about it more, @PowerAppRoadMap - and let me see your finished project! Thanks again!
Also docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch is a great guide to the patch function.
@@WorldOfPlatform Thank you for your quick reply.
Is there a way to make the gantt chart formatted to support projects that span beyond 1 year? I know this will complicate things significantly since the formulas all have been developed around a 12 month timeline.
Hi, thanks for watching.
You should establish the absolute maximum end point for your actions, and use that in your formula. For example, if you have activities that span 20 months, you change the month striping width to (stageWidth/20) and instead of dividing by 365, divide by how many days are between your start and end date. You could calculate this manually, or, make a 'set up' screen with date pickers for start and end date, and use the DateDiff formula to calculate the amount of days between the two.
My day job is priority just now, but I do intend to revisit this build to address stuff from the comments, and I'll include this aspect
@@WorldOfPlatform Thank you this is helpful. I've developed an excel calculator that builds project timelines so the dates are uncertain, sometimes the projects start/end within 6 months sometimes years. Any tips you can provide to manage this uncertainty plus the timelines can span years sometimes are greatly appreciated. This would be a great addition to a future video. Also, if you could talk about ways to connect to databases that would also be super helpful! Great job!
Could you explain how to create the status drop down in lieu of the status label like you did in the video. Also the steps to creating that user and category option as well?
Hi Dominique! Sure. add your drop down input, and set Items to ["active","complete"] or whatever you want your options to be, then using the OnChange property for the dropdown, you need to add a function in here to Patch the record with its new status.
Patch( YourCollectionName, First( Filter( YourCollectionName, YourIDField= -CurrentItemID- ) ), { status: dropdownMenu.Selected.Value} )
Where YourCollectionName is the name of your datasource, YourIDField is the name of whatever you're using as your unique ID, CurrentItemID should be a reference to the current selected item, and dropdownMenu should be whatever you've called your Drop Down Menu.
This video has just under 3500 views, way more than any of my other videos and way way more than I ever expected any of my videos to get. You're not alone in asking about the end version of the app, and I'm planning on revisiting this and covering the stuff I glossed over in this video.
Can you give me an example of the unique ID from your video. I used the tutorial verbatim to see if it would work. I need the code for the drop down and steps for the adjacent box.
I am trying to solve for something and this video had everything except the last two things 😞
Absolutely! In my example I created an ID field (in the formula around 09:00 ). If your naming conventions are the exact same as mine, your patch formula to change the status will be:
Patch(TaskList,First(Filter(TaskList,ID=GanttTasks.Selected.ID)),{Status: dropdownMenu.Selected.Value}) . dropdownMenu is whatever you named the status drop down you swapped in for the label at the bottom.
for the dark blue box, the dropdown there would have an Items property of Distinct(TaskList, AssignedTo) to populate it with each of the people. The two labels below that, you can do a count of matching users with the formula CountIf(TaskList,AssignedTo = UserDropDown.Selected.Value) where UserDropDown is the name of your new dropdown menu.
To calculate the average, you can use the formula SUM(Filter(TaskList,AssignedTo = UserDropDown.Selected.Value),DateDiff(DateValue(StartDate),DateValue(EndDate)))/CountIf(TaskList,AssignedTo = UserDropDown.Selected.Value)
To break that down, We are filtering TaskList to only return records where AssignedTo is your selected user, then we are going to take the difference between the start date and end date for each of those rows, and sum them together, and then divide that by the count of rows that match that assigned to person.
I don't have the app easily available to just send you the code, but what I've typed above should be pretty close to right. If you're having trouble, break the calculation down into parts, I'll check back in when I've had a chance to pull the formula from my app.
Hye. I already can do it the gantt chart base on your video.. but i want to change the colour by category ( like the end of your video ) can you show how you do it. I really need your help.
Sorry about the delay in responding. Yes! In the Fill control for your label, you can use an If statement to control the color. This example will change the color based on who the task is assigned to:
If(ThisItem.AssignedTo = "Person 2", RGBA(108, 92, 231,1.0) RGBA(179, 55, 113,1.0))
You can continue adding IFs to that formula, but this quick version will color Person 2 tasks a different color from everyone else. Change the column ThisItem is looking at if you want to by a different metric. Good luck!
can you please advise how you did the end product
You want to add Nested Galleries. Set your background gallery to get the striping, then Add a blank gallery with variable height. The source of this gallery should be set to your DataSource with a distinct operator for the category field. So now this gallery will have as many items as you have categories. Then inside that gallery, add a new gallery like in the video. the source for this gallery will be set to a Filter on your DataSource where category matches ThisItem (the category name). That should get you on your way to the solution. Let me know how you get on, thank you for watching.
Amazing!!! All I needed to know. Congrats. nice job. Is there a way to download it in somewhere? Had you share it?
Not yet, message me on Twitter and I can send you a copy. The idea is to publish working documents on a blog site to accompany the videos. I'm glad you enjoyed the video.
@@WorldOfPlatform thanks. I could manage it myself with your helper video. Thanks a lot.
You've put substantial effort into this explainer video, thank you @PowerApps Road Map. It's content-wise of very high quality.
I hope you continue soon submitting more of these...
Is there a way to access your Gantt chart sample code?
very nice
Hello do you have any idea
How you go about saving the information inputted? When I come out of the app it wipes
Hi John. I built this demo using a local collection. If you want to store the data somewhere and recall it, there's a lot of great videos that can help with this. I haven't personally covered the topic, but Shane Young has - czcams.com/video/gX5q_V3U8-s/video.html
Your SharePoint list will need to have all the fields in it that we create in the video, and then the button would Patch that data to the list. The chart itself would then use the SharePoint list as it's data source to display the data.
Hope that helps. I can try and make a companion piece talking through saving the data to a list in the future. If you need any more help you can always reach out of Twitter too (@PowerAppRoadMap).
Thanks for watching!
Does the video cover The indicator bar on the Gantt Chart wiping too ,is there a way of keeping that on the screen when you close the App please
@@johnbrennan8442 Do you mean the bars for each task? When you have your data saving to SharePoint or an external source, you'll update the gantt chart gallery's data source control to that external source too.
If you set up a SharePoint List called GanttTasks and save the form data to that, you'd change the Gallery controls to read the data from that list.
When I click on the Gantt Task Gallery the Data Source option is greyed out
@@WorldOfPlatform what fields would I need to put in the sharepoint list please
Hey, please provide this app
Nice "hack" :)
Thanks Frank! It's far from a fully fleshed out Gantt Chart layout, but I've had a few projects cross my desk now where this layout has come in handy