Hello Folks, As committed I am starting a new series called "PowerGuide Mentorship Program"
Intention of the PowerGuide Series is to share very interesting Ideas, Tips and Tricks related to Power Apps, Power Automate, Power Virtual Agent, PowerApps Portals and many more interesting stuff.
Today, I am going to share my first post of this series, where we'll learn about implementing Duplicate Detection in PowerApps while creating record in Dynamics 365.
Scenario - While creating a lead in Dynamics 365, check whether lead of same emailadress already exist or not, If exist then display duplicate emailaddress error message.
Let's get started...
Step 1: Screen 1 - Create a Blank Canvas App > Connect with Dynamics 365 Data Source > Connect Lead 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(Leads,emailaddress1 = emailAddress_1.Text)),
UpdateContext({result: "Duplicates Record not found"}),
Navigate(DiuplicateDetectionDialogBox,ScreenTransition.CoverRight)
);
You can use following formula also on Button Control (onSelect property) to find Duplicate Record
UpdateContext({recordCount: CountIf(Leads,emailaddress1 = emailAddress_1.Text)});If(recordCount > 0, Navigate(DiuplicateDetectionDialogBox,ScreenTransition.Fade))
Step 6: Test the App
Stay Tuned for PowerGuide - Tip 2 - Upsert/Patch Record in Dynamics 365 using PowerApps.
Cheers.
Thanks Arpit for such good initiative.
ReplyDeleteIt is truly a great and useful piece of information. how can i subscribe for a blog site? It is truly a great and useful piece of information.thanks for sharing these information
ReplyDeletec language interview questions
great and useful info. thanks
ReplyDelete