Skip to main content

Notifications

Community site session details

Community site session details

Session Id : UrXiiYvedp4SQesP+D57bl
Power Apps - Microsoft Dataverse
Unanswered

Setting Owning Business Unit programmatically or via API

Like (0) ShareShare
ReportReport
Posted on 16 Nov 2023 22:25:54 by 105

We have a solution in which a healthy portion of the tables will be propagated from a master data source.  We are leveraging modern business units to track data that is tied to a partner.  In our sync process, we are trying to add new records and apparently we can't set the owning business record in that insert?  Instead it's defaulting to the top-level business unit.  Is there something that needs to be configured to allow for this or does the API call need to be setup in a particular way?  Or does it have to be assigned programmatically after insert?

Categories:
  • IanJB Profile Picture
    93 on 31 Jul 2024 at 14:34:36
    Setting Owning Business Unit programmatically or via API
    This is a bit dated, but curious if you ever figured out a good solution.
     
    I have a similar workflow, and I use a recurring cloud flow to check for records that still belong to the root business unit, then assigns those records accordingly to various modern business units. The downside to this is that it can only process 5000 records per table per run, so on new projects where I have hundreds of thousands of records to bring in, this flow needs to run many, many times to catch up. Not sure if this is universal or not, but in my company's workspace/license I can only call 200,000 power platform requests per day, so its really not a great solution for the initial import/establishment of large data sets. Once it's caught up the cloud flow solution is fine, since there aren't that many new records created daily that need to be patched up. 
     
    It would be fantastic if there were a better way to manage this as part of the Dataflow that is bringing the data in, rather than dealing with it post-fact as a separate cloud flow. Any new thoughts out there on this topic?
  • mhomol Profile Picture
    105 on 21 Nov 2023 at 13:14:57
    Re: Setting Owning Business Unit programmatically or via API

    Unfortunately, this was a feature that I specifically turned off within this environment, since I knew I was syncing the majority of this information from a master source (this is part of the modern business units matrix security setup).  

  • Fubar Profile Picture
    7,867 Super User 2025 Season 1 on 21 Nov 2023 at 05:32:10
    Re: Setting Owning Business Unit programmatically or via API

    Not sure if this helps or not, usually you wouldn't directly set the BU, what you would do is set the Owner of the record to a System User or Team, the system will then set the BU of the record to the BU of that Owner (note all BU's have a default Team - but you have to assign a Security Role to the Team with enough privileges to own the records in question).

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 15

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading started