Set value for each multi select item

(0) Share

Report

Posted on by douglasfilipe

Hi all,

I have a SharePoint column (Checkboxes allow multiple selections)

In my powerapps I have a form, wich selection control:

For each item inside of column, I need to give a value for calculate an type of SLA:

"Vagas afirmativas" SLA value must be 5
"Assessment adicional" SLA value must be 10
"Teste de proficiência da língua inglesa" SLA value must be 15
"Testes/provas técnicas" SLA value must be 20

and I need to sum each for calculate total and get the SLA.

How can I do it?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

v-mengmli-msft on at

Like (0)

Report
Hi @douglasfilipe ,

Do you want to add SLA column to count each SLA of multiple choices column?

Please try this.

AddColumns(List,SLA,Sum(If(!IsBlank(LookUp(DEMAND,Value="Vagas afirmativas")),5),If(!IsBlank(LookUp(DEMAND,Value="Assessment adicional")),10),If(!IsBlank(LookUp(DEMAND,Value="Teste de proficiência da língua inglesa")),15),If(!IsBlank(LookUp(DEMAND,Value="Testes/provas técnicas")),20)))

Best regards,

Rimmon

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
@douglasfilipe ,

Alternative structure

AddColumns( List, SLA, If("Vagas afirmativas" in DEMAND.Value, 5, 0) + If("Assessment adicional" in DEMAND.Value, 10, 0) + If("Teste de proficiência da língua inglesa" in DEMAND.Value, 15, 0) + If("Testes/provas técnicas" in DEMAND.Value, 15, 0) )

Was this reply helpful? Yes No
douglasfilipe 14 on at

Like (0)

Report

Thanks a lot folks!
Both suggestions works great and solved my issue.
Regards!

Was this reply helpful? Yes No