Unanswered

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

(0) Share

Report

Posted on by Mfon

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.

do not want the Created By and Owner field to show the flow signed-in user information. Any support will be appreciated.

Categories:

Building flows

Power Automate Ow...

I have the same question (0)

All responses (3)

Answers (0)

Gyllentid 894 on at

Like (1)

Report

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...

Was this reply helpful? Yes No
Mfon 41 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Gyllentid 894 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No