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?

All responses (2)

Answers (1)

Blue_Cat82 4 on at

Like (0)

Report

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

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.
Verified answer

v-bacao-msft on at

Like (0)

Report

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

Hi @_pcillawa ,

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

Best Regards,