Duplicate Detection in Dynamics 365 using power apps.

 

User Case: When setting up a contact in Dynamics 365, verify if a contact with the same email address already exists. If it does, prompt an error message indicating a duplicate email address.

Step 1:  Navigate to make.powerapps.com, screen 1 àCreate a Blank Canvas App à Connect with Dynamics 365 Data Source à Connect Contact Entity as Dataset (You can connect other entity also as per your requirement)




Step 2:  Screen 2 - Insert a new Blank Screen to show Duplicate Detection Dialog


Step 3:  Add few Text Input and Button Controls in Screen 1 or design as per your need.


Step 4:  Add below formula on Button Control (onSelect property) to find Duplicate Record.

If(IsBlank(

LookUp(Contacts,emailaddress1 =Emailaddress_Text.Text)),

UpdateContext({result: "Duplicates Record not found"}),

Navigate(DuplicateDetectionDailogbox,ScreenTransition.CoverRight));



You can use following formula also on Button Control (onSelect property) to find Duplicate Record

UpdateContext({recordCount: CountIf(Contacts,emailaddress1 = Emailaddress_Text.Text)});

 

If(recordCount > 0, Navigate(DuplicateDetectionDailogbox,ScreenTransition.Fade))

 

Step 5: Test the App

Before running the App, I’ve taken the existing email address from an existing contact.


And I’ve entered details into the App. Upon clicking 'Submit,' the Duplicate Detection Screen will appear.

If you provide a new email address that does not exist in the contact records, the result will be display as “Duplicates Record not found”. You can find result from variables.

Thank you..!

















Comments

Post a Comment

Popular posts from this blog

How to implement approval in Teams using Adaptive Cards

Image
  Adaptive Cards are self-contained user interface components that transcend platform boundaries. Crafted in JSON format, these snippets of UI can be seamlessly exchanged between applications. Upon reaching a particular application, the JSON content is dynamically rendered into native UI elements, seamlessly blending with the app's aesthetic. This approach facilitates the creation and seamless integration of lightweight UI elements across diverse platforms and frameworks. User Story: We're preparing to implement a leave approval workflow in Teams utilizing adaptive cards. Employees will submit their leave requests, and line managers will receive notifications within Teams. Step 1 – Design the Adaptive Card Prior to establishing the flow, let's initiate the card design process using the designer tool to ensure readiness. Visit https://adaptivecards.io/designer/   to access the designer interface and adjust the 'host app' setting to Microsoft Teams – Light /...
Read more

Open canvas app with Customize the command bar using command designer

Image
  This topic guides you through creating and editing modern commands using the command designer and Power Fx. Create a new model-driven app using modern app designer 1.      Sign into  Power Apps 2.      On the left navigation pane, select  Solutions  and then open or create a solution to contain the new model-driven app. 3.      Select  New  >  App  >  Model-driven app 4.      Select  Modern app designer , and then select  Create .    Enter a  Name  for your app, and then select  Create . More information:  Create a model-driven app that has an account table page 1.      On the left navigation pane, select  Solutions , and then open the solution containing the existing model-driven app. 2.      Select the model-driven app, and then select --  >  Edit ...
Read more

HTTP Request Methods

Image
  1. 𝗚𝗘𝗧 : GET Method is used to request information from a website, Server or from API. Example: GET/api/employee/{employee-id}   2. 𝗣𝗢𝗦𝗧 : POST Method is used to create a new resource in server. We can send data to the server in the request body. Example: POST/api/employee/department   3. 𝗣𝗨𝗧 : PUT Method is used to update an existing record by sending the updated data as the content to request body to the server. Example: POST/api/employee/55445   4. 𝗗𝗘𝗟𝗘𝗧𝗘 : DELETE Method is used to remove resources from the server. Example: DELETE/api/employee/55445   5. 𝗣𝗔𝗧𝗖𝗛 : PATCH and PUT are similar use to updates a resource, but it will update data partially but not fully. Example: PATCH/api/employee/55445{"Name: Employee Name"}   6. 𝗛𝗘𝗔𝗗 : HEAD Method is like the GET but it doesn't have any response body. Example: HEAD/api/employee   7. 𝗢𝗣𝗧𝗜𝗢𝗡𝗦 : OPTIONS Method is used to get the informatio...
Read more

Create email templates in dynamic 365 and send email using Power Automate

Image
We can utilize email templates with Power Automate to send emails. Follow these steps to use email templates with Power Automate. ·         Create Email Template in dynamic 365. ·         Configure Power Automate to Email Template. Create Email Template in dynamic 365: Navigate to Power Platform admin center, navigate to the Environments tab, and select your environment you wish to create email template refer below screen short. Click on setting and look for Templets and click on Email Template. Click on new on tool bar. The Email Template Type dialog box will open. Select the desired entity and then click OK. On the template form, provide a name for your email template and, if desired, add a description. Note that the email template name and description will not be visible to the recipient. Enter the text you want to send in the message. Use the formatting toolbar to edit and style your...
Read more