Unanswered

Dataverse column as a choice of 2 other column values from the same table

(0) Share

Report

Posted on by SajidSalim

I am trying to build a Model-drive Application and trying to identify the best way to tackle the below problem.

I have a table with location columns - initial location, customer location and current location. The current location can be one of the following:

Initial location
Customer's location
Empty (meaning it is at customer's location)

Initial Location - can never be empty

Customer Location - can be empty as the item is still at the initial location.

Now, I would like the current location choice to only display three possible values - initial location, customer's location, N/A.

How can I achieve this? Because, the values are going to be dynamic and can only be really shown once the Initial Location and Customer Location has values.

Is there a better way to approach this problem? Like, at the form level instead of trying to achieve this at the Dataverse level?

If I have to do it at the form level, how can I do this?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Jonathan Manrique 2,687 on at

Like (0)

Report
Hi @SajidSalim

To address this challenge you can do it in several ways but I recommend at the backend level because of the result you expect.

First in the frontend it is through JS to perhaps make a switch and depending on the combination of values the value of the current location is completed. You should do this JS in the initial location onchange, client location, remove current location values and only show those three that you mention, something you should see is that if it is an option set change, the ideal is that they are the same values and perhaps for current location add N/A.

I give you an example code of how to hide the value of option set, you must do this dynamically because you will have to hide all the values and only leave three values

function ocultarOpcion(executionContext) { var formContext = executionContext.getFormContext(); var pickList = formContext.getControl("nombre_del_conjunto_de_opciones"); // Elimina la opción con valor 1 pickList.removeOption(1); // Elimina la opción con valor 2 pickList.removeOption(2); // Puedes seguir eliminando más opciones según tus necesidades }

Was this reply helpful? Yes No
Shashank Bhide 942 Moderator on at

Like (0)

Report

You can perhaps create a PCF control doing that, but I guess whichever route you take this will require JS customization work.

Was this reply helpful? Yes No