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...
Solved! Go to Solution.
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.
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.
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.
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:
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...
User | Count |
---|---|
222 | |
97 | |
95 | |
55 | |
34 |
User | Count |
---|---|
273 | |
108 | |
106 | |
64 | |
60 |