cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sshivaprasadsp
New Member

How to get Dataverse Created by in Power Automate

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 

sshivaprasadsp_0-1614647604569.png

 

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

 

sshivaprasadsp_1-1614647655491.png

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

sshivaprasadsp_2-1614647959805.png

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User II
Dual Super User II

@sshivaprasadsp 

 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.

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

8 REPLIES 8
Mira_Ghaly
Dual Super User II
Dual Super User II

@sshivaprasadsp 

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

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

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
Dual Super User II
Dual Super User II

@sshivaprasadsp 

 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.

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

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
Dual Super User II
Dual Super User II

@aanyoti 

 

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

Mira_Ghaly_0-1627550065568.png

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Thanks so much @Mira_Ghaly , this has worked!

 

👍

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!

@CoolBoyAnurag 

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

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Kudoed Authors
Users online (2,170)