
Announcements
Greetings
I have a entity named Entity1
It has two choice fields and one lookup field
Lookup fields is a lookup to an entity called category which has only name field
I have a subgrid
The sub-grid should filter data based on the lookup field, and two option sets
How do i achieve this requirement?
Kindly guide
Best Regards
Enh
Hi @Enh
If I understand your requirements correctly, you want to filter the subgrid based on the fields that are on the parent form that the subgrid sits on. This isn't possible currently
There is an idea here for Microsoft to add this capability so it would be worth voting on it. However, you would still need to write JavaScript code.
An alternative is to create a Canvas app with a gallery to represent the subgrid and embed the Canvas app on your form. Through the Canvas app you will be able to easily filter the data, however, it's a lot more work than simply adding a subgrid to the form!