Answered

Default Owning Business Unit to that of parent table

(0) Share

Report

Posted on by kazut

Suppose I have two tables: Project and its child Issue. The relationship is one to many.

I want the records in Issue to have the same Owning Business Unit as that of its parent Project, instead of the business unit of the user who created the issue. How can I achieve that?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Fubar 8,487 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
First question is do you need to maintain it over time or just when it is created?

'server-side' For on create, create a Plugin, Workflow, or Flow and on create copy from the parent (plugin or workflow if needs to be realtime).

If only need 'client-side' in model driven app, Switch to Classic and update the relationships' Relationship Mappings and map the ownerid.

For changes that may occur later, Edit the Relationship and under Advanced set its 'Assign' Cascade Rule to cascade e..g. Cascade All (note the cascade does not apply to the initial create, just subsequent owner changes on the parent)

Was this reply helpful? Yes No
kazut 13 on at

Like (0)

Report
Copy link

Link copied!

Thanks! I was able to use the Table Mapping (your second bullet) to make it work.
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/map-entity-fields

We don't really assume any changes of owning business unit, but wonder if "Parental" behavior works instead of your third bullet?

Was this reply helpful? Yes No
Fubar 8,487 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@kazut wrote:

We don't really assume any changes of owning business unit, but wonder if "Parental" behavior works instead of your third bullet?

Parental has them all set to Cascade All except for Rollup. Unfortunately the new interface doesn't display all the individual relationship behaviors like the Classic interface does (except for when you have chosen Custom)..

Was this reply helpful? Yes No
kazut 13 on at

Like (0)

Report
Copy link

Link copied!

Got it! Thanks again so much.

Was this reply helpful? Yes No