cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

Progress bar across multiple screens

I have progress bars that are to show how many of the text input fields have something entered into them.  For example in one section there is 50 questions that span over 3 screens. So each question is worth 2 out of a 100.

 

I would like to use the screen's OnVisible & all save buttons OnSelect to calculate the progress bar total.  So I am wondering what is the best way to go through all the columns in a data source record, determine how many are not blank and then multiple that by 2 to get the progress total.  

 

Is this possible?  Or is there some other way I should be looking at this?

 

For the main dashboard I am planning on using these custom component progress bars, and on the individual screens I will simply use a simple line progress bar across the very bottom.  https://powerusers.microsoft.com/t5/Canvas-Apps-Components-Samples/Circle-Progress-Bar/m-p/434925/hi...

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

@Sacred_Totems 

I'm not trying to be smart here but maybe try asking the author of the Component if they think it's possible to do what you want? @R3dKap would likely have a better understanding of the capabilities.

 

Personally, I wouldn't be relying on Components in a production app just yet. They still seem like they have a few gremlins at the moment. I guess though, so long as you are prepared to accept that they may play up a little then by all means use them, they really are a great addition to PowerApps.

View solution in original post

3 REPLIES 3
Super User
Super User

@Sacred_Totems 

I'm not trying to be smart here but maybe try asking the author of the Component if they think it's possible to do what you want? @R3dKap would likely have a better understanding of the capabilities.

 

Personally, I wouldn't be relying on Components in a production app just yet. They still seem like they have a few gremlins at the moment. I guess though, so long as you are prepared to accept that they may play up a little then by all means use them, they really are a great addition to PowerApps.

View solution in original post

@Eelman 

 

Okay, thank you... Ya it is for production. 

 

Well I was starting to think it wasn't me but had not seen anyone mention anything since February.

Super User
Super User

Hi @Sacred_Totems,

As I understand your need here, you have 50 fields that your users have to fill-in and you want to show a percentage of completion for the fields that have values.

Based on your explanation, I assumed you preferred to keep the /100 value (to show like a "100%" value), thus multiplying by 2 the number of filled fields.

Well, to ease your work I just updated the component: now you can choose to display a real percentage value inside the circle progress bar, instead of a value like X/Y. So just set the Max property of your component to the real number of fields that have to be filled and set the Value property to the real number of already-filled fields. Then, as explained on my post here(https://powerusers.microsoft.com/t5/Canvas-Apps-Components-Samples/Circle-Progress-Bar/m-p/434925 or on Github https://github.com/e-gallis/PowerApps/blob/master/Components/CircleProgressBar/readme.md) set your component's ValueMode to YourCircleProgressBarComponent.ValueModeEnum.Progress and that will do the trick.

Oh, and about counting the number of fields that are empty, here is how I would do it:

  • I would concatenate all fields from the item into a string, seperating the values with commas (use the Concat function for this)
  • Then I would split the resulting string using the comma as a separator (use Split for this)
  • You will end-up with a "vertical version" of your item where each field value would be a row in the resulting collection
  • Then just use the CountIf function to count the number of fields that are not blank (or blank and substract it from the total number of columns)

Of course, if the comma could be a character entered by your users in the fields, choose another separator (like '#' or '|').

Hope this will help...

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (19,862)