How to Change Dataverse Owner Record based on user Email Address

Uwak Peter

I'm trying to do a filter in a table where the current user can only see their own records.

The records in the table only show the user who created the record as owner of all the records, this is because we were importing the records from excel.

I want to be able to reassign ownership of each record to individual users using their email addresses.

I have tried the below, but it is not working, any assistance will be appreciated.

I have tried the codes below on the compose action:

first(body('list_rows_2')?['value']?['systemuserid'])

first(outputs('List_Rows_2'))['systemuserid']

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tuhin Paul1y ago
Use the List Rows action to fetch all users from the systemuser table in Dataverse. check to include the systemuserid and emailaddress fields in the columns to fetch. Use another List Rows action to fetch the records from your target table. Include the Email Address (or equivalent) field. For each record, find the corresponding user based on the email address and update the Owner field.
Tuhin Paul1y ago
To get the system user ID, you can use the following compose action:

first(body('Get_User_Profile')?['d']?['systemuserid'])

Replace 'Get_User_Profile' with the actual name of your Get User Profile action.