How to get Dataverse Created by in Power Automate

(0) Share

Report

Posted on by Power Platform Comm...

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.

All responses (6)

Answers (0)

Power Platform Comm... 4 on at

Like (0)

Report

RE: How to get Dataverse Created by in Power Automate

Thanks so much @Mira_Ghaly , this has worked!
Power Platform Comm... 4 on at

Like (0)

Report

RE: How to get Dataverse Created by in Power Automate

@aanyoti

This is the below step , I meant in the solution above:
Power Platform Comm... 4 on at

Like (0)

Report

RE: How to get Dataverse Created by in Power Automate

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?
Power Platform Comm... 4 on at

Like (0)

Report

RE: How to get Dataverse Created by in Power Automate

@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.
Power Platform Comm... 4 on at

Like (0)

Report

RE: How to get Dataverse Created by in Power Automate

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.
Power Platform Comm... 4 on at

Like (0)

Report

RE: How to get Dataverse Created by in Power Automate

@sshivaprasadsp

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