Unanswered

Unable to get the logical name of the optionset associated to a field

(0) Share

Report

Posted on by paula12-29

Hello,

I have a model-driven app with several option sets being used. For example, "kdj_option1", "kdj_option2", and "kdj_option3".

I need to retrieve only the fields that use "kdj_option2" and "kdj_option3" using JavaScript.

Currently, I have the following code:

function test(executionContext) {
 var formContext = executionContext.getFormContext();
 formContext.ui.tabs.forEach(function (element) {
 if (element.getVisible()) {
 element.sections.forEach(function (section) {
 section.controls.forEach(function (control) {
 if (control.getControlType() === "optionset") {
 console.log(control)
 }
 });
 });
 }
 });
}

How do I modify this line

if (control.getControlType() === "optionset") {

to only perform some code on the fields that do not use "kdj_option1"?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

ebLott 14 on at

Like
a
(0)

Report
Copy link

Link copied!
You can add an additional logical check, like this:
if(control.getControlType() === "optionset" && control.getAttribute().getName() !== "kdj_option1") { console.log(control); }

Was this reply helpful? Yes No
paula12-29 8 on at

Like
a
(0)

Report
Copy link

Link copied!

This is not filtering out the logical names of option sets. This seems to be returning the fields that have a logical name of "kdj_option1".

Was this reply helpful? Yes No
ebLott 14 on at

Like
a
(0)

Report
Copy link

Link copied!

@paula12-29 The if statement is filtering out the controls with the control.getAttribute().getName() !== "kdj_option1" argument. The console log is just a placeholder for example.

Was this reply helpful? Yes No
paula12-29 8 on at

Like
a
(0)

Report
Copy link

Link copied!
Maybe I am doing something wrong. But when I just include

if (control.getControlType() === "optionset") { console.log(control) }

It returns 3 objects

When I update the code to:

if(control.getControlType() === "optionset" && control.getAttribute().getName() !== "kdj_option1") { console.log(control); }

The same 3 objects are returned, even though "kdj_option1" is one of the option sets being used in one controls.

Using the same code, if I change "kdj_option1" to the logical name of a column that is using this optionset, then I only (and correctly) get back 2 objects.

Was this reply helpful? Yes No
ebLott 14 on at

Like
a
(0)

Report
Copy link

Link copied!
Try this without getAttribute:
if(control.getControlType() === "optionset" && control.getName() !== "kdj_option1") { console.log(control); }

Was this reply helpful? Yes No
paula12-29 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately, still get back 3 objects, even when I remove getAttribute() from the line of code. Once again, if I change "kdj_option1" to the logical name of a column that is using this option set, then I get back the 2 objects.

Was this reply helpful? Yes No