web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Create business rule t...
Power Apps
Unanswered

Create business rule that checks other records in the same table

(0) ShareShare
ReportReport
Posted on by

Hello. I need to create a business rule in a table where I have three fields called Lease StartLease End, and Email. This rule would show an error message whenever the Lease End overlaps with the Lease Start of another record with the same email in this same table.

 

Thing is, apparently It is not possible to create business rules that lookup other values in the same table. Is there a workaround for this case or is it really not doable?

Thanks!

I have the same question (0)
  • a33ik Profile Picture
    3,306 Most Valuable Professional on at

    Hello,

    You can develop a plugin that will handle create/update of your record, perform checks, and throw an exception if overlap exists.

  • arthurmilanez Profile Picture
    on at

    Thanks for the tip, I looked it up and there's even a D365 extension for VS Code. Will definitely try it out.

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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 405 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 280 Super User 2025 Season 2

#3
Kalathiya Profile Picture

Kalathiya 272

Last 30 days Overall leaderboard