Answered

Sign process percentage

(1) Share

Report

Posted on by Joost Cuppes

Goodmorning! I've got a order process in PowerApps. In the order process we've got a table as shown below.

I want to show a percentage of how far this order is signed. In this case there are 6 people who have to sign, but it can also be just 2, 3, etc... Max is 7. What could be a good code for this? It's in a gallery right now and can the field "thisitem.SSP Required", etc.. can be used. I do think i am able to figure something out, but that would be a really ugly piece of code.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@JoostCuppes

Try like this:

// Initialize a variable to store the count of approvals and required signatures ClearCollect(colApprovalCounts, {Signer:"SSP", Approved:ThisItem.'SSP Approved', Required:ThisItem.'SSP Required'}, {Signer:"SM", Approved:ThisItem.'SM Approved', Required:ThisItem.'SM Required'}, {Signer:"CPO", Approved:ThisItem.'CPO Approved', Required:ThisItem.'CPO Required'}, {Signer:"CEO", Approved:ThisItem.'CEO Approved', Required:ThisItem.'CEO Required'}, {Signer:"SCM", Approved:ThisItem.'SCM Approved', Required:ThisItem.'SCM Required'}, {Signer:"COO", Approved:ThisItem.'COO Approved', Required:ThisItem.'COO Required'}, {Signer:"CFO/CEO", Approved:ThisItem.'CFO/CEO Approved', Required:ThisItem.'CFO/CEO Required'} ) // Calculate the percentage Set(gloApprovalPercentage, RoundDown( (CountRows(Filter(colApprovalCounts, Approved = true)) / CountRows(Filter(colApprovalCounts, Required = true))) * 100, 0) )

See if something like this may work for you @JoostCuppes

Was this reply helpful? Yes No
Joost Cuppes 80 on at

Like
a
(1)

Report
Copy link

Link copied!

HI @poweractivate will try to implement this. But where should i put it? As this is in a gallery?

Was this reply helpful? Yes No
Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@JoostCuppes You can try to simply put it in the Text property of a Label control that is in the Gallery, and if you do, you can try the version below for that formula:

With({ colApprovalCounts: [ {Signer:"SSP", Approved:ThisItem.'SSP Approved', Required:ThisItem.'SSP Required'}, {Signer:"SM", Approved:ThisItem.'SM Approved', Required:ThisItem.'SM Required'}, {Signer:"CPO", Approved:ThisItem.'CPO Approved', Required:ThisItem.'CPO Required'}, {Signer:"CEO", Approved:ThisItem.'CEO Approved', Required:ThisItem.'CEO Required'}, {Signer:"SCM", Approved:ThisItem.'SCM Approved', Required:ThisItem.'SCM Required'}, {Signer:"COO", Approved:ThisItem.'COO Approved', Required:ThisItem.'COO Required'}, {Signer:"CFO/CEO", Approved:ThisItem.'CFO/CEO Approved', Required:ThisItem.'CFO/CEO Required'} ] }, RoundDown( (CountRows(Filter(colApprovalCounts, Approved = true)) / CountRows(Filter(colApprovalCounts, Required = true))) * 100, 0) & "%" )

See if this may help @JoostCuppes

Was this reply helpful? Yes No
Joost Cuppes 80 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @poweractivate Did someone already called you a hero today? If not, you are my hero today! Thanks man!
Added a progress bar as well. Looking nice now! (still have to make the order block better, but this is already really nice!
Thanks.

Was this reply helpful? Yes No