Users records being assigned to Parent Business Unit instead of Child Business Unit, as per security model

[MrsRDj14]

Hello Community,

I have a Dataverse security model set up like this:

Parent Business Unit, and Child Business Units for each Division

Users are assigned to AAD Group of their Division, and an equivalent Dataverse Team is created within the Child BU, Security Role is applied to Child BU.

The security role is a copy of the Basic User role, with the custom tables permissions (Create, Read, Write etc.) set to Business Unit.

The security in terms of RLS works as expected, however when Users submit records, their OwningBusinessUnit is recorded as the Parent Business Unit, rather than the Child Business Unit.

Please advise of what step I may have missed here.

Many thanks in advance for your help.

[MrsRDj14]

Hi @SBax I have also tried that and receive the same error message

[SBax]

I'm not sure that you need the _ and _value and I think you may have a bracket in the wrong place 

Try first(outputs('List_Teams')?['body/value'])?['businessunitid']

[MrsRDj14]

With this expression I get the same html error as above.

I was trying to implement the item function with something along the lines of:

item()?['List_Teams']?['_businessunitid_value']

but I could not get that to work as expected either

[MrsRDj14 · Accepted solution]

Hi @SBax just wanted to get back to you to say I managed to get this flow to work.

Here is the screenshot of the final flow for anyone else hoping to use this solution - please do not hesitate to reach out for details.

Many thanks again for your support.

[SBax]

Hi @MrsRDj14 - what was the issue with your item()?['List_Teams']?['_businessunitid_value'] formula out of curiosity?

[MrsRDj14]

Hi @SBax I'm not really sure, but when I added the 'Apply to each' it worked when iterating over the rows (even though the dataset was filtered to one row). I would also like to know how that fixed it, if you have any ideas?

[Anonymous]

Can you please add the full power automate flow for reference. I have a same scenario that i'm working on but i'm new to power automate. if you could provide more details that will help me.

Thanks

[MrsRDj14]

Hi @Anonymous screenshot of full working flow is shared above