Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

Make a option set for every option in a option set

(0) ShareShare
ReportReport
Posted on by 52

Hello everyone

 

I'm trying to make an option set of every option set item. For example:

i have an option set option1 option2 and option 3.

Is it possible to make of option1 another option set option 1_1 option1_2 option1_3?

So when you select option1, you only get the items that are linked to that option.

 

Thanks in advance!

Categories:
  • jorenchristiaen Profile Picture
    52 on at
    Re: Make a option set for every option in a option set

    Sounds like a great solution!

    I will defintely try that, thank you for the fast reply.

  • Verified answer
    Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on at
    Re: Make a option set for every option in a option set

    Hi @jorenchristiaen,

     

    This is not possible with option set (choice) fields.  This is something you can definitely do with Lookups though.  I would create two tables, first table could be for your values represented in option set 1 and the 2nd table can be the values represented in option set 2 with another foreign key lookup field on that table being the lookup to table 1.  You can then add to the form with a dependent lookup and it will filter the values in table 2 to only show the values related to table 1 value selected.  

     

    An article written that reflects this concept here:   https://www.sikich.com/insight/how-to-create-dynamics-crm-ce-dependent-lookups/ 

     

    Hope this helps.  Please accept if answers your question or like if helps in some way.

     

    Thanks,

     

    Drew

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 19

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 15 Super User 2025 Season 1

Overall leaderboard

Featured topics