Skip to main content

Notifications

Power Automate - Building Flows
Answered

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

(0) ShareShare
ReportReport
Posted on by 26
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']
 
 
  • Verified answer
    narayan225 Profile Picture
    narayan225 2,425 on at
    How to Change Dataverse Owner Record based on user Email Address in Power Automate
    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!

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard