Referencing the Value of a Dropdown box in a Formula (Model Driven App)

(1) Share

Report

Posted on by MP-05081449-0

In a Model Driven App, I created a form with a dropdown field for selecting geographic State (NC, SC, FL, GA, etc...). I am trying to reference the selected value and use it as part of a formula within a Text field. For example, I want the Text field to be a concatenation of a Builder Name and State.

So, the formula would look similar to the snapshot below. 'Builder Name' is simply referencing another Text box. 'State" is trying to reference the value selecting in the Dropdown box, but I keep getting an error.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Kameshm05 310 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi,

I understood your question and found a solution. I've replicated the same in my environment. However, it seems that the choice column is not yet supported in the formula column. You can refer to this link for more details:
Formula Columns - Power Apps.

I've found an alternative workaround that you can use if you're okay with it. In my environment, I used the "ChoiceFieldState" column, which is a choice column. I applied a switch statement to check each option with a hardcoded value. Please review the outputs below.

Thanks

Was this reply helpful? Yes No
Suggested answer

Inogic 1,291 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi,

In the formula type of field we can’t concate the Dropdown field with the text field. We can concate the text field with another text field, Date field, Date and Time field and Number field.

But, if you want that your one text field should be the combination of two field then you can use the synchronous workflow which will update the record after the new record is created or there is change in the State or name fields.

Thanks!

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Was this reply helpful? Yes No
MP-05081449-0 13 on at

Like (1)

Report
Copy link

Link copied!

Thank you both for your replies. I believe both solutions will work, I went with Inogic's since it was more efficient and opened up the doors for other programming opportunities.

Was this reply helpful? Yes No
MP-05081449-0 13 on at

Like (1)

Report
Copy link

Link copied!

Inogic,

I tried using this solution with a dropdown field where multiple values can be selected. However, the field wasn't available when using the synchronous workflow. IS this a limitation? If you are not aware of this, can you test to see if it works for you?

Thanks,

Mike

Was this reply helpful? Yes No