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 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?
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
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?
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 ?
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.?
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!
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!
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!
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 RU-vid have already covered that kind of thing. Shane Young is a great resource: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MclJ_O9HvJQ.html Thanks for your kind words. You're not the only person to ask about this, so a companion video might happen!
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!
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.
9 месяцев назад
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
9 месяцев назад
Or is there a way to contact you, unfortunately you can no longer be found on X?
Any way you could view this Gantt chart from data already collected in hourly format vs. day format? I have a calendar that we are using to see items by day in a monthly view and a 2-week view, but we also need to be able to click on any day in those views to show the daily schedule by hours as well. Any tip you could give me to produce that would be sensational!
Hi William, I've been thinking of revisiting this walkthrough to cover some of the stuff in the end project, and I'd definitely talk about a day view. As a pointer to get you started, like how we're saying 0 is January 1st and splitting the width of the gallery into 365 parts for each day of the year, you want to split it into 1440 parts for the amount of minutes in a day.
@@WorldOfPlatform I actually took some time to think about it and did it for the hours we're open for testing and broke the day down into 16 segments by the hour from 6am to 10pm. It really saved my bacon!
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!
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?
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.
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 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gX5q_V3U8-s.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.
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.
