hi,
Is it possible to fetch/drill down options based on other entities/ columns? Please take a look at the below example:
I would like the choices filtered based on the value i choose from Category field. From the above e.g. when I choose PC, only the related brands and desc should appear in the brands and description fields and not all.
@EricRegnier
Hi @Teresa24486,
if you’re using entities as your brands and categories than you can filter out-of-the-box. Look at this post for the steps: https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Filter-LookUp-Field-to-Related-Record-From-Previous-LookUp-Field/m-p/717718
If you’re using option sets then you can but will require code with JavaScript.
Hope this helps...
lookup shows the value of the primary field of the entity and thats not the lookup field.. how can i have that changed to the lookup field itself?
That's the standard behavior in CDS and cannot be changed. The primary field has to be a text field (single line of text). What do you mean by "not the lookup field"? Another lookup field on the lookup entity? If you need that, then suggest to setup a workflow (or Power Automate) to update the primary value with the lookup value from that entity.
Instead of a workflow, I created separate entities for Category and Sub-category keeping fields category and sub-category as primary fields, then tried to apply filter on the change properties page of the main form of another entity. For some reason the Category loads, sub-category is empty. Not sure i am doing it right.
And do you have a Category lookup filed on Sub-Category entity? If not, create one which will allow you to filter the related sub-categories. You will then need to apply the filtering on the form as per my previous post:
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 836 Most Valuable Professional
Michael E. Gernaey 327 Super User 2025 Season 2
MS.Ragavendar 231 Super User 2025 Season 2