Answered

Including a Sharepoint List Choice Column to the details in a Microsoft Flow email, not clear

(0) Share

Report

Posted on by _pcillawa

Running a Microsoft Flow for approvals when a new item is created in a Sharepoint List. I have attached all the fields of the Sharepoint List to the details of my Flow email sent out to the approvers. The Sharepoint column with type Choice-radio buttons does not print properly in the emails that are sent out. They look like this:

{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":3,"Value":"Custodian write-off"}

How do I get the Choice column within Sharepoint list to print properly in the emails?

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @_pcillawa ,

You could choose Choice value and fill it in the email body:

Best Regards,

Was this reply helpful? Yes No
Blue_Cat82 4 on at

Like (0)

Report
Copy link

Link copied!

Help please! I have always used the Status Value option, but recently it's has started returning odata strings or instead of putting all items in one field (or email), it will only update with the last item. (or send multiple emails with only 1 value). This is driving me crazy becuase it used to work fine.

Was this reply helpful? Yes No