cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrstian89
Helper III
Helper III

Update row owner in Dataverse table

Hi!
I am creating an app where I keep track of equipment in several locations.

For each location I have 4 security groups (read / loan / maintain / admin).

 

I want to use PowerAutomate to give the different rows team owner dependent on a column value.

 

If Location column = Location 1, I want the four security groups from that location to own the row/record.

 

I have tried the following in Power Automate, but it fails:

 

When a row is added or modified

  • Equipment list table
  • Scope: Organization

Apply to each

  • Select an output from previous steps. I think this is the issue. I have tried using OData Id and the uniqe identifier of the table. I still get an error.
  • Condition: If Location column = Location 1, then Update row

Update row:

  • Row ID: Is it correct to use the table unique identifier?
  • Owners: I input the ID's of the security groups, separeted by commas.

 

I am obviously missing something at the beginning of the Apply to each step. But does the rest seem to be an OK way to solve this?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @mrstian89 

 

Follow the below steps:

 

Here I am checking the name is Location 3 as an example.  Next step I am getting the Team Id (Location 3). Finally setting the team id as the owner of the newly created record.

 

image.png

image.png

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

3 REPLIES 3
abm
Super User
Super User

Hi @mrstian89 

 

Not sure I understood correctly. After the trigger why do have a apply to each loop. So that means you are filtering something? Could you please post a screenshot of your flow? Also you haven't mentioned the error.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

My solution clearly didn't work, and I am probably not even close!

How can I accomplish the following:

  • Everytime a new row is added to the dataverse table, I want to change the owner of that row to specific team IDs.
  • If the value of the Location column is Location 3, I want that row to be owned my all Location 3 teams.
  • The same for my other locations. 

Hi @mrstian89 

 

Follow the below steps:

 

Here I am checking the name is Location 3 as an example.  Next step I am getting the Team Id (Location 3). Finally setting the team id as the owner of the newly created record.

 

image.png

image.png

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,746)