Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
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,928 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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

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

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 37

#2
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#3
LA-30040116-0 Profile Picture

LA-30040116-0 21

Overall leaderboard

Featured topics

Loading started