Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Announcing Category Subscriptions!
News and Announcements icon
Power Platform Community / Forums / Power Automate - Building Flows / How to set Dataverse O...
Power Automate - Building Flows
Unanswered

How to set Dataverse Owner or Created By field value dynamically using Power Automate

(0) ShareShare
ReportReport
Posted on by Mfon 26
 
I have a list of users in an Excel document that was shared with me, I want to use Power Automate to populate a dataverse table with the list dynamically and set the Created By or Owner field with the information on the Excel document (Name or Email address). I have tried using this on the flow Owner field for the table:
 
systemusers(xxx@xxx.onmicrosoft.com), but it wasn't working.
I
do not want the Created By and Owner field to show the flow signed-in user information. Any support will be appreciated.
 
Categories:
Business Process Flows
Power Automate Ow...
  • sroo Profile Picture
    sroo 880 on at
    How to set Dataverse Owner or Created By field value dynamically using Power Automate
    @Mfon if they aren't part of 365 Dynamics they can't be added as owners. You can create a column and add their email address to keep track of who it belongs to but it won't be with the innate Owner field. If you need it to be the Owner field you first need to add then to 365 Dynamics as users.
  • Mfon Profile Picture
    Mfon 26 on at
    How to set Dataverse Owner or Created By field value dynamically using Power Automate
    Thank you for your response.
     
    The users that are in the Excel file have not been created on dataverse before, this is the first time they are going to be uploaded into dataverse, so how am I going to use the internalEmailAddress to filter?
  • sroo Profile Picture
    sroo 880 on at
    How to set Dataverse Owner or Created By field value dynamically using Power Automate
    Hi,
     
    You need to get the owners systemuser id to be able to assign it. You can make a List rows action, filter it on InternalEMailAddress for the right email address and then add that id in the Dataverse action where you need it. You can use this expression 
    first(body('List_rows')?['value'])?['systemuserid'])
    Then you don't need to use the Apply to each action...
     
     

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

News and Announcements

Welcome to the Power Platform Communities
Announcing Category Subscriptions!

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,609

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,420

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans