web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Table Calculated field...

Power Apps

Answered

Table Calculated field based on drop down

(0) Share

Report

Report

Posted on by Lafsen

75

Hi,

trying to get a calculated value based on input from a drop down list but cannot get the syntax right.

If(Country = "Vietnam", 30, 0)

Country is a drop down field. "Vietnam" is one of the options.

How can I get the value from Country drop down and use it in IF formula?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Lafsen ,

Assuming your options are Dataverse choice fields.

For a Local choice, try:

If( Country.Selected.Value = 'Your Country Choice Field (Your Table Plural Name)'.Vietnam, 30, 0 )

For a Global choice, try:

If( Country.Selected.Value = 'Your Global Choice Field'.Vietnam, 30, 0 )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No

Join the conversation