Hi,
This is something that has been bugging me and maybe it is a limitation? I have a Canvas app for users to submit a daily report. Once the app is submitted I have a Flow that fires off When a record is created (CDS) to Send an email notification. I'm able to include all the values from the Canvas app in the body of the email that's being sent but I can't figure out how to include the user that submitted the form. I tried to add Get user profile before Send an email notification and include Display Name in the subject but trying various things I've seen in the forums I could only get it to display my name or nothing at all.
I would like the Subject to read: Daily Report: [Name of User that submitted form] - [Date created]
Any suggestions?
Solved! Go to Solution.
You need to add a new CDC current action Get Record, Entity:users, And pass the createdby(value) from the Dynamic Content to the Id, from the output of this step you can use the Full Name property to display the User Name.
Hi @kcgov ,
The method provided by @Mira_Ghaly is correct, like this:
Please take a try and feel free to let us know if you have any questions.
Best Regards,
So are you passing the user from the Canvas App to the Entity that has the Create Trigger?
So do you expect the Submitted form to have the Created By = User who submitted the form?
@Mira_Ghaly yes. It seems entities have the default field Created By and displays the first and last name of the user when I check the records. The problem is displaying the user's name in the email that is sent. In the image below I am able to display my name in the email just fine. The problem is figuring out how to display the name of any user that submits the form via the app. I tried using Created By but that didn't work. I then tried using triggerbody()?['_createdby_label'] but that didn't work either.
You need to add a new CDC current action Get Record, Entity:users, And pass the createdby(value) from the Dynamic Content to the Id, from the output of this step you can use the Full Name property to display the User Name.
Hi @kcgov ,
The method provided by @Mira_Ghaly is correct, like this:
Please take a try and feel free to let us know if you have any questions.
Best Regards,
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
64 | |
23 | |
16 | |
15 | |
11 |
User | Count |
---|---|
118 | |
35 | |
30 | |
28 | |
26 |