web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Calculate value based ...

Power Apps

Answered

Calculate value based on Dropdown

(0) Share

Report

Report

Posted on by srqdewfffffffff

5

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 Img

All responses (2)

Answers Img

Answers (1)

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

Join the conversation