Answered

Progress bar of each gallery item's complete percentage

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I have a gallery that is connected to a SharePoint list. Each record in the list is a checklist for different customer installations. I am trying to figure out how I can display a progress bar of the installation in the gallery view so that I can quickly tell without opening the item how far along it is. Most of the values are from toggles. There are a few text boxes that also need to be counted. The record is large. 80 Columns. I have a tabbed form broken up into days. I can't for the life of me figure out how to count up each column that has a "true" or if the text box has a value in the single SharePoint record. All I have found is how to count the values in each row's column in the list. I have already put together a progress bar that compares completed tasks (has "true" or text value) with number of totals tasks (number of columns that require "true" or text input).

Any advice would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Community Power Pla... on at

Like (0)

Report

Hi,

So I was about to suggest something similar to what you mentioned at the end of your post. So you do currently have the progress of how many of the total 80 tasks is completed? If I have assumed that correctly, what is it your are wanting to get a progress of?

One thing I was also thinking is that you could have a weighting column added to the list. So everytime a box is selected, based on the number of boxes selected, it increments the column with a number that could then help you to determine the status.

That is another question. Are you just wanting to see something like 4/80 tasks completed or should it be as a percentage based on 80 being 100?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Thank you for the reply.
I am teaching myself as I go and have taken this on as a hobby/side project for work to make my teams job easier.

I only know how many tasks are complete because I can look in the SharePoint list or open the gallery item. What I do know is that there are 82 columns that require information for the record to be complete. I want the Gallery to display the % complete. There could be 20+ jobs going on at a time. A quick way to look and get an update from the gallery view would be great.
I can get the progress Bar to work on the individual form pages but I would still need to open the record to see it.

I hope this make it clearer on what I am trying to do.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,

I am sure there are better ways but here is an example.

I then have a progress button I could refresh and run the following formula or also have it run on start of the app:

Default value of slider:
LookUp(colProgress,Id = ThisItem.ID).Progress

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Default value of slider:
LookUp(colProgress,Id = ThisItem.ID).Progress

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hello,
Thank you for your answers.
I took the weighted column approach and made 3 additional columns in my SharePoint list. The 1st column counts how many ""Yes" are present in the record. The 2nd column looks at the single line text fields and counts them if they are not blank. The 3rd Column SUMs the other 2 columns. I set the NumberOfTasks as a global variable of 81. On a Test Screen I am able to get the value of the "CompletedColumns" in number format by using ---> Value(GalleryRequests.Selected.CompletedColumns) in the current record the value is 79 this works on the test screen. .

When I insert the HTML text box into my gallery and use the same code it gives me an error on the last line &
The full HTML text box formula is.

"<div style=""height:16px;position:relative;border-radius:10px;border:5px solid #111313;margin:25px 30px 10px 30px;overflow:visible;box-sizing:border-box;"">
<div style=""position:absolute;top:-5px;left:" & If(And(Value(GalleryRequests.Selected.CompletedColumns)>NumberOfTasks,NumberOfTasks > 0),100,Round(If(NumberOfTasks>0,Value(GalleryRequests.Selected.CompletedColumns) * 100.0 / NumberOfTasks,0),0)) & "%;"">
<div style=""position:relative;width:45px;height:21px;background-color:#292837;border-radius:3px;margin:-25px 0 0 -20px;text-align:center;color:white;font-size: 15px;padding-top: 0px;box-sizing: border-box;border-bottom:1px solid #292837;"">" & If(And(Value(GalleryRequests.Selected.CompletedColumns)>NumberOfTasks,NumberOfTasks > 0),100,Round(If(NumberOfTasks>0,Value(GalleryRequests.Selected.CompletedColumns) * 100.0 / NumberOfTasks,0),0)) & "%
<div style=""position:absolute;width:0;height:0;top:20px;left:3px;border-left:15px solid transparent;border-right:15.5px solid transparent;border-top:4px solid #292837;""></div></div>
</div>
<div style=""height:10px;position:absolute;border-radius:10px;background-color:#41e17f;top:-2px;left:-1px;width:" & If(NumberOfTasks>0,Value(GalleryRequests.Selected.CompletedColumns) * 100.0 / NumberOfTasks,0) & "%""></div></div>"

Any ideas why it works on a test screen but not in the gallery?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

duplicate

Was this reply helpful? Yes No