Skip to main content

Dependent Lookup in MS CRM 2016 and D365

Dependent Lookup in MS CRM 2016 and D365

Requirement: When a value selected in a lookup, related records for that lookup should be filtered in another lookup.

Eg: let’s say, we have Out Of SLA Reason and Out Of SLA Sub Reason lookup (entities). When a value is selected from Out Of SLA Reason Lookup, only related records of that value should be visible in Out Of SLA Sub Reason lookup.

Implementation:

  • Create two custom Entities – Out Of SLA Reason and Out Of SLA Sub Reason
  • Create a 1: N relationship (Referential) in Out Of SLA Reason with Out Of SLA Sub Reason. Which creates a lookup of Out Of SLA Reason in Out Of SLA Sub Reason entity.
  • Now go to Out Of SLA Sub Reason form and Out Of SLA Reason lookup on the form.



  • Now populate the data in Out Of SLA Reason and Out Of SLA Sub Reason.
  • Once data populated, go to Out Of SLA Sub Reason and select the related SLA Reason records from lookup for Out Of SLA Sub Reason records.
  • Now go to SLA Reason, SLA Sub Reason entities and create 1: N relationship (referential) to related entities.
  • Eg: If we want to show these lookup on Case. Create 1: N relationship (referential) from Out Of SLA Reason and Out of SLA Sub Reasons to Case entity. Which creates two lookup on Case entity.
  • Open case form and add these two lookup on the form.
  • Open Field Properties of Out Of SLA Sub Reason lookup from case form and go to Related Records Filtering section. Click on Only Show records where, choose Out Of SLA Reason (cases) and in contains Out of SLA Reason (Out Of SLA Sub Reason).

Now, when we click on Out Of SLA Reason and selects a record, only related records of that will show on Out Of SLA Sub Reason.


Comments

Post a Comment

Popular posts from this blog

Validate an email input in a Canvas Application | PowerApps

Validate an email input in a Canvas Application | PowerApps In this post let us see, how to Validate an email input in a Canvas Application UI Validations helps us to ensure, valid data is received from the End User to complete an operation helps end user to provide right information the validation action depends on the type of the input control for Text Input Control - mostly we go with "OnChange" for check box control - "OnCheck and On uncheck" for Drop Down and Combo Box Controls - "OnChange" or "OnSelect" etc., Now, let us see how can we validate an email input, a phone number input and a name input. How to validate an email input value is valid? We can leverage "Regex" (Regular Expressions) to valid user inputs. Let us consider the Email Input Control Name as -  txtEmail.Text. OnChange of this Control let us i
Post a Comment
Read more

How to create a "pop-up box" in PowerApps

in this post, let us see how to create a Pop-Up in Canvas App required controls: rectangular icon label buttons - 2 take a "rectangular icon" and make it screen size update it's "Fill" - with RGBA(175, 191, 224, 0.5) . Take another "rectangular icon" and adjust it to center Take "label" - and add required text (Eg: "do you want to proceed?") Take two buttons. Update text of Button1 to "OK" and other to "Cancel" On Click of the respective control (to open the pop-up), add this expression : UpdateContext({locOpenPopup:true}) select "cancel" and "ok" button and add UpdateContext({locOpenPopup:false}) on "OnSelect" property. add appropriate actions on "cancel&quo
Post a Comment
Read more

Success confirmation on a record submission - Canvas Application

In this post let us see, how to show a successfully submitted record's data back on to the form, as a confirmation. Take two screens  Home Screen Success Screen On Home Screen: Take a Form Control on the Home Screen and map it to respective entity. In this post we are mapping it to Registrations entity. Take a Button Control and input the below expression, to create records into Registrations Entity. SubmitForm( frmRegistration ) Now, let us implement how to redirect the user to Success Message screen to successful record submission. In order to achieve this, we are going to make use of one of the Form Control's properties - OnSuccess. So, OnSuccess we are going to implement Success Screen navigation as below Navigate(' Success Screen ')   Success Screen Take a label to show - success message, as below "Registration was successful. Registration Id: " & frmRegistration .LastSubmit.'Registration Number' LastSubmit  property of a From Control helps u
Post a Comment
Read more