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) Share

Report

Posted on by pallavigade 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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
pallavigade Microsoft Employee on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No