How to use Option Sets columns inside a Calculated text field?

(0) Share

Report

Posted on by testasdfasfsafa

309

Since I cannot find anything online, I'm hoping to tap into expert knowledge here...

I have a single entity with 3 options set columns in CDS, namely, Grade level, Genre, Format with their own internal IDs.

Goal

My goal is to have a text field with the concatenated corresponding label values such as (3 Writing Online) and not (100,003, 100,008, 100,010).

In the calculated form, the intellisense doesn't even show the options sets 😞

Any tips or example would be appreciated...

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Satish1024 279 on at

Like (2)

Report
Copy link

Link copied!
Easy with JavaScript. I wrote a function for you. You have to change the attribute names below to reflect your attributes.
You can call this function on the on-change event of the three option set attributes (adding the event handler). If you don't know how to upload JS & add an event handler, steps are described here:
https://docs.microsoft.com/en-us/powerapps/developer/model-driven-apps/clientapi/walkthrough-write-your-first-client-script

function ConcatLabels(executionContext) { var formContext = executionContext.getFormContext(); var gradeLabel= formContext.getAttribute("your_attribute_logical_name").getText(); var genreLabel= formContext.getAttribute("your_attribute_logical_name").getText(); var formatLabel= formContext.getAttribute("your_attribute_logical_name").getText(); var finalString = gradeLabel + genreLabel + formatLabel; // you can format your string here //set the finalString to your attribute formContext.getAttribute("your_attrbute_logical_name_to_set").setValue(finalString); }

Please mark it as answer if my code helps.

Thanks
Satish Reddy
https://pascalcase.com

Was this reply helpful? Yes No
Hamish Sheild 3,005 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi,

If you want a no-code approach then you can use CDS classic workflow. Trigger the workflow on change of your option set fields and use it to populate a text field that are the option set fields concatenated.

Details on classic CDS workflows are here https://docs.microsoft.com/en-us/power-automate/workflow-processes

Let me know if you need anymore help with this option.

Note, for the JavaScript solution provided previously. You might find that the onload trigger of the code will probably not work for you. You will need to trigger it on the onchange event of your option set fields.

Was this reply helpful? Yes No
Satish1024 279 on at

Like (1)

Report
Copy link

Link copied!

@HSheild I second that. The handler has to be added on on-change events, not on-load. I am editing my post.

Was this reply helpful? Yes No