web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Model Driven Apps Show...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 7

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.

I have the same question (0)
  • Verified answer
    Ram Prakash Duraisamy Profile Picture
    5,699 Super User 2026 Season 1 on at

    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

  • Brook_C Profile Picture
    7 on at

    it's work with JavaScript, Thanks.

  • ShriniA Profile Picture
    on at

    @Brook_C 

    Can I get the code, please?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard