How to filter options in a select field based on another select field in Dynamics 365?

Posted on by FA-24072047-0

Hello everyone,

I'm working on a form in Dynamics 365 that contains two select fields. I need the second field to display only the options related to the selection made in the first field.

For example:
- Field 1: "Fruits", "Animals", etc.
- If the user selects "Fruits" in Field 1, Field 2 should show only options such as "Apple", "Grapes", etc.

I tried setting this up using an entity relationship between the two fields, but Field 2 continues to display all options instead of just those related to the selection in Field 1.

Could someone guide me on how to correctly configure this filter so that Field 2 only shows options relevant to the selection in Field 1?