Glad it helped!

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.

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.

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!

You're welcome!

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!

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!

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.

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!

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!

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.

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 KZfaq have already covered that kind of thing. Shane Young is a great resource: kzfaq.info/get/bejne/g8mcfcKAnq7aeoU.html Thanks for your kind words. You're not the only person to ask about this, so a companion video might happen!

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.

@@WorldOfPlatform thanks. I could manage it myself with your helper video. Thanks a lot.

Or is there a way to contact you, unfortunately you can no longer be found on X?

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 - kzfaq.info/get/bejne/nb5lpMKHmLucXac.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

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