web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How to Change Datavers...

Power Automate

Answered

How to Change Dataverse Owner Record based on user Email Address in Power Automate

(0) Share

Report

Report

Posted on by Mfon

41

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

The record in the table only shows the user who created the record as owner of all the records, this is because we are importing the data 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:

The compose action has these codes:

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

Error message:

And

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

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!
Your first formula expression is wrong which could be the reason why its returning with error.

Try following:

first(outputs('List_rows')?['body/value'])['systemuserid']

This returned me the systemuserid value when I did a compose action with the items from List_rows action.

Hope this helps.

Cheers!

Was this reply helpful? Yes No

Join the conversation