How to get Dataverse Created by in Power Automate

[Anonymous]

Hello there,

I have created a Model driven app. when an Item is created, I need to send an email to a user and CC to Created By user.

I am using Power Automate. the action I am starting with is 

In email body I should display created by(standard column) user display name. 

However, I am getting only Created by 'Unique identifier' not the value i.e. display name or email ID

and another column Assigned to is a lookup from 'Users'(standard table) also not getting display name or email.

What should I use. I understand it should be simple. though I am new to Power platform.

Thanks.

[Mira_Ghaly]

@Anonymous 

So what is your preference send email from Data verse or using outlook connectors?

[Anonymous]

Hello @Mira_Ghaly ,

Thanks for the reply. I don't mind using one of them. I need to send email to a user CC to created by and some email body with created item fields(currently I am getting those) and display name of created by user.

[Mira_Ghaly · Accepted solution]

@Anonymous 

 I found it easier to use outlook connector in case u do not want to save the Email activity in Dynamics.

So to get the created by Email you need to call the Get Row on the user entity and pass the createdby(value) and then use the Primary email from the output of this step to send the email.

[aanyoti]

Hi @Mira_Ghaly ,

Could you please elaborate on the call the Get Row on the user entity part, its not very clear. Which action is this specifically in power automate?

[Mira_Ghaly]

@aanyoti 

This is the below step , I meant in the solution above:

[aanyoti]

Thanks so much @Mira_Ghaly , this has worked!

👍

[CoolBoyAnurag]

Hi Mira,

Thanks for this solution It saved my day. I would like to ask in the same request if we want to CC the manager of creator of the record any clue??

Thanks in advance!

[Mira_Ghaly]

@CoolBoyAnurag 

So if you are using get user you can do another GetRowbyId and pass the manager from the Get User.