Model Driven Apps Showing Choice based on Multiple Choices from another Table

(0) Share

Report

Posted on by Brook_C

Hi,

I have been trying to show a choice column based on multiple choices column from another table
for example :

Choice : Task contains different options as "A ,B, C, D, E"
Table : Ex1 contain Team Name = "Team-A" and selected Choices : Task = "A, B, C"
Table : Ex2 contain Team Name = "Team-A"(Lookup from Table Ex1) and I want option in Choice Task that showing in here has only data that reference in Team Name = "Team-A" from Table : Ex1 which is "A, B, C"
I tried with business rules but it seem impossible, So I wonder if model-driven have a method to do something like this?

hopefully this is understandable, and Thanks in advance.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

Hello @Brook_C,

You cannot achieve the same by using Business Rules, you can try achieving this by using JavaScript

Steps:

1. get the Team Name from Table
2. Make an ODATA call by passing Table 1 as Parameter and Retrieve CHOICE FIELDS
3. Get the Choice Field and set the same in the Table.

let me know if you need more clarity

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Brook_C 7 on at

Like (1)

Report

it's work with JavaScript, Thanks.

Was this reply helpful? Yes No
ShriniA on at

Like (1)

Report

@Brook_C
Can I get the code, please?

Was this reply helpful? Yes No