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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Is there any OOB featu...
Power Apps
Unanswered

Is there any OOB feature available to restrict the user from setting up the relationship beyond certain level\depth, when we have a 1:Many relationship assigned on a same entity.

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Is there any OOB feature available that will set the depth, when we have a 1:Many relationship set on a same entity.

 

Here is the scenario:

I have a 1: Many relationship on the same custom entity i.e., contract. So that I can create a contract and have another contract (from the same contract entity) assign to it as a parent and set up the parent\child relationship.

Now, I am checking if there is any OOB functionality available that I can use to restrict the user from assigning the relationship beyond certain depth level e.g 4 as shown in below diagram?

 

Here: P referrers to parent contract and C refers to child contract. Appreciate any input\guidance available on this.

 

pallavigade_1-1697236492802.png

 

I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,960 Moderator on at

    @pallavigade 

     

    you would have to create a workflow or a plugin. Since you said OOB it would be a workflow. But a plugin wouldn't be that difficult for what you want. And it would have pre-insert, so you could simply block it and give back an error.

     

    A power automate flow wouldn't work as it would require you to roll back (using an update), versus blocking it.


    If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • pallavigade Profile Picture
    Microsoft Employee on at

    Thank you @FLMike Appreciate your reply. Can you please elaborate more on the workflow e.g which criteria or condition to use. I am also curious to know if using javascript webresource would be helpful? Thank you so much!

  • Michael E. Gernaey Profile Picture
    53,960 Moderator on at

    Hi @pallavigade 

     

    No Javascript wouldn't help. You need something that can perform a pre-action (like a workflow or plugin), which would intercept any attempt to do what you are wanting to block.

     

    That being said, it also depends on if you do it in Dataverse Model Driven or Canvas Apps or Power Pages. Because you could also do additional pre-submit login in the UI of a canvas app that would not even allow them to save it.

     

    I will respond tomorrow, sorry going to a movie, but I will.


    If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard