Answered

HELP! {"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"

(1) Share

Report

Posted on by AustineHype

Hi!

I have created a sen an email v2 flow based on my sharepoint list values and I have a column in SP called Status which is a choice column, when it comes to send a notification in terms of the progress of the ticket I usually just put a dynamic content 'Status' however when I sent it out via oulook everything looks good except the status which shows error like this

{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":5,"Value":"Completed"}

any help would be appreciated

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (10)

Report
Copy link

Link copied!

Hello @AustineHype ,
when you check the available dynamic contents, you should have 'Status' = the whole object, 'Status Id' = id of the status and 'Status Value' = the status text, e.g. 'Completed'.
'Status Value' is the one you want to use in the email.

Was this reply helpful? Yes No
Nicang1 3 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much - the use of 'value' sorted the same issue for me

Was this reply helpful? Yes No
Matan_EinEli 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @tom_riha ,
If I didn't use dynamic content, I used expressions and got the same message.
How can I fix it?

Thanks a lot.

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report
Copy link

Link copied!

@tom_riha
Can you help me?..
I am stuck for 3days to solve this problem.
I tried to use your solution but it does not provide column name's value.

Was this reply helpful? Yes No
Andre-Radtke 92 on at

Like (0)

Report
Copy link

Link copied!

To take the dynamic content "FieldName Value" instead of "FieldName" fixed it for me also.!!

Was this reply helpful? Yes No