Loading

How to set Dataverse Owner field dynamically using Power Automate

Uwak Peter

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:

systemusers([email protected]), 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.

1 Reply

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

Tuhin Paul1y ago
If you're using a sandbox environment, check that the user's email address is valid and exists in your Azure Active Directory (AAD).

You can use the following expression to get the user's GUID:

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

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