Building a Progress Bar in Power Apps

[@CigarDoug]

Thank you for this video. My math is a little more complicated, but I was able to apply your solution easily and just change the formula. I like the container within a container look, the final option.

[@michelhegeraat5430]

My progress bars are usually made from a slider. Nice to share your ideas.

[@DamoBird365]

Cheers Michael, hopefully something new to try out 👍

[@franknielsen3219]

Very cool THX. I allways watch your Power Automate videos because they are great, so keep up the good work 👌👌

[@DamoBird365]

Cheers Frank 👍 appreciated

[@basehumax]

Thanks Damien

Good one Damien. 👍💡 Love PowerApps, you can build the same thing in so many ways. SVG images can work for Progress Bar and the good old HTML Text Control can as well. Keep those videos coming. 🎥📺

[@marina_peixoto]

Thank you so much! Your video made my day!

[@DamoBird365]

I would love to see what you came up with 👍

[@jasonralston6610]

Nice work, I think it's crazy that you have to use a patch statement to update a collection value in application that you have full control. you would think you could use set(). Also you seleted the first three items in your control? Please tell me that isn't because you can only leverage the check and uncheck properties for control state? If that really is the case once again wouldn't just use a if(), case() switch() or whatever PowerApps call it?

[@imran002ali]

Hi @DamoBird365, very nice and great video, thank you!! 👍

[@DamoBird365]

Thank Imran.

[@inspectorlife85]

Like this one! Thanks for these video and tutorials. Can you make one on taking an existing Sharepoint List (lots of data columns, use inputs information/tracks start for each row) and make it automatically move to an Excel File for a single person to review? Including a list from TEAMS?

[@DamoBird365]

Let me know if this helps kzbin.info/www/bejne/iHPCqoagndJsick

[@lxz86]

thanks Damo, this is so much useful, but these five states require dependency logic, and the next step can only be taken after initiation. How should this be implemented?

[@DamoBird365]

I’ve used a gallery to demonstrate updating the Boolean values via oncheck but you could base it on a table/list being updated or maybe navigation between screens via an onselect. It really depends on your use case and why the progress bar should update.

[@aceco4431]

Good day! Can this be done in cases where there are separate activities on a single canvas app? If so, how would we do it? Thank you

[@DamoBird365]

@@aceco4431 do you mean separate progress bars on separate processes? I don’t see why not. You just need to maintain a separate variable.

[@CarlosAlmeida-s3m]

Hello @DamoBird365, Is there any way of getting data of a ".xls" file in order to make a flow automation? either convert .xls to csv or .xlsx? I would like to know if this is possible only by using power automate flows, and no PADesktop?

[@DamoBird365]

I’ve looked into this in the past, I don’t believe it is possible. There are 3rd party connectors, for instance encodian that can handle xls to xlsx. If you find a way, please let me know 😉

[@shashankgwl]

So the formula for calculation of completion will show 60% if "Monitoring , Execution and Closure" alone are ticked?

[@DamoBird365]

Correct, but hopefully you can apply this to your own logic.

[@dpibob]

I am getting an error that says "invalid operation:division by zero." Do you know how I could fix this?

[@CigarDoug]

Somewhere in your code, like the width of one of the controls, you are dividing. So, if you are dividing a / b, and b is empty or null or blank, it's 0. So it's a division by zero error. Do a search for the division symbol "/" and check the value to the right of the "/". More than likely, it's a collection that's not populated, so the COUNT is zero.