Answered

Calculate value based on Dropdown

(0) Share

Report

Posted on by srqdewfffffffff

Hi everyone,

I have a dropdown DataCardValue144_1 (Mês) where I have all the months (January to December) and each month has a multiplier factor of 12 to 1, respectively.

When I select a month like July it multiples the value from DataCardValue150_4 = 10000 (Total Mensal) with the number 6, and the result in Label39_5 (Total Ano) is 60000.

This is my code inside Label39_5:

If(DataCardValue144_1.Selected.Value = "Julho"; Text(Value(DataCardValue150_4*6)); "")

I want to know if is possible to make this code work to all months inside Label39_5.

Today I make it work with 12 labels that are only visible when a especific month is choose on the dropdown.

Thanks for the help!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

CarlosFigueira Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hello @srqdewfffffffff

The Items property of the dropdown can be a table with multiple columns. So if you set it to the following expression:

Table( { Nome: "Janeiro"; Multiplicador: 12 }; { Nome: "Fevereiro"; Multiplicador: 11 }; { Nome: "Março"; Multiplicador: 10 }; { Nome: "Abril"; Multiplicador: 9 }; { Nome: "Maio"; Multiplicador: 8 }; { Nome: "Junho"; Multiplicador: 7 }; { Nome: "Julho"; Multiplicador: 6 }; { Nome: "Agosto"; Multiplicador: 5 }; { Nome: "Setembro"; Multiplicador: 4 }; { Nome: "Outubro"; Multiplicador: 3 }; { Nome: "Novembro"; Multiplicador: 2 }; { Nome: "Dezembro"; Multiplicador: 1 }; )

You can update the code in your label to something along the lines of

Text(Value(DataCardValue150_4.Text) * DataCardValue144_1.Selected.Multiplicador)

Hope this helps!

Was this reply helpful? Yes No
srqdewfffffffff 5 on at

Like (0)

Report
Copy link

Link copied!

Sorry for the delay!
This solution worked for me!
Thank you so much, @CarlosFigueira

Was this reply helpful? Yes No