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

6 REPLIES 6
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

View solution in original post

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!

 

👍

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,978)