I am trying to create an automated email to be sent once a new record is created on PowerApps using Dataverse. But when I select the dynamic content it returns the GUID and not the readable values I want.
At the moment I've tried to add "@OData.Community.Display.V1.FormattedValue" to the end of a variable and place it in the email as an Expression as I see others doing the same but with no result.
The image attached here is my current flow - I would be very grateful for any thoughts on how to progress this further.
From what type of column are you trying the show the label/text value? And can you share the outputs of your trigger action? This might gives us a clue on what the expression should be.
Btw, if it is a guid from a related table you would probably need to use that guid in a Get a Row by ID action to get the record with the actual text value.
I appreciate you coming back to me! I have attached 3 images below.
At the moment my email is resulting in showing nothing at the end. Originally I had a flow of a trigger being "Adding a Dataverse record" connected to send an email, but that would only show me the GUID in the email.
So are you saying I need to place "Get a Row by ID", equate the GUID to the text value between the Trigger and Email ?
The column is a LookUp. I have attached the images of my flow result
Yes, that is correct. I am proposing to place a Get Row by Id action between the trigger and e-mail action.
Would be something like the example below.
Lookup your assettables table name in the dropdown. Enter the tradename property in the row id.
Sorry I must be misunderstanding, below is my current Flow and the resulting email but my result is the GUID. How would I equate that to a name field?
Depends a bit on which fields are available on the Assets Tables table. My guess is that the correct label is probably called Asset Name (value) or something similar like that.
Just to double check, did you use a dynamic content field from the Get Row by ID or from the original trigger action in your Send an Email action? It should be a field listed under the section Get a row by ID.
I get you now for "Get Row By ID" the table name is the parent and the row is the child.
By playing around with your input I have managed to get part of my email to return the results.
Big thank you for your help!
Keep up to date with current events and community announcements in the Power Automate community.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Check out the latest Community Blog from the community!