Return actual values in email from Dataverse lookup column

(0) Share

Report

Posted on by hasnie_ibrahim

I’m working with Dataverse and sending an email from a flow. I’m able to display normal column values fine, but when I include a lookup column, the email shows “weird” values (e.g. GUIDs / table logical names.

cr0bf_l4processstep (normal column) > abcde

cr0bf_l3_processcategory(lookup column) > cr0bf_dimprocesscategory,48f84904-7993-453f-bc30-03e69b4ddc90

Below is my formula. Any help would be appreciated! Thank you.

if(

empty(outputs('List_rows')?['body/value']),

createArray(),

coalesce(

json(

coalesce(

first(outputs('List_rows')?['body/value'])?['changedata'],

'{"changedAttributes":[]}'

)

)?['changedAttributes'],

createArray()

)

)

Categories:

General topics

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

MS.Ragavendar 7,162 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@hasnie_ibrahim,

item()?['_cr0bf_l3_processcategory_value@OData.Community.Display.V1.FormattedValue'] - Use this expression for the lookup columns

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
hasnie_ibrahim 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @MS.Ragavendar, many thanks for your reply. Unfortunately I have multiple lookup fields, do i need to list them all in the expression? Apologies I'm quite new with the code.

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,151 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @hasnie_ibrahim,

This is expected behavior of lookup column, when working with lookup columns in Dataverse, they return the table name and GUID by default. If you want to get the actual display value, you need to use the formatted value.

To get the actual value, you need to use the correct expression based on your action.

#1. If you are retrieving the value from trigger then expression should like this:

triggerOutputs()?['body/_cr0bf_l3_processcategory_value@OData.Community.Display.V1.FormattedValue']

#2. If you are retrieving the value from get row by id action then expression should like this:

outputs('Get_a_row_by_ID')?['body/cr0bf_l3_processcategory@OData.Community.Display.V1.FormattedValue']

#3. if you are storing this value in Select then your expression like this:

tem()?['cr0bf_l3_processcategory@OData.Community.Display.V1.FormattedValue']

Note: Based on your action that expression will be different so please use accordingly.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No
hasnie_ibrahim 4 on at

Like (0)

Report
Copy link

Link copied!

Just to be clear, I'm accessing Dataverse Audits table so the formattedvalue might not work.

Was this reply helpful? Yes No