Dear friends I have a simple flow that:
1. Gets items from SharePoint List
2. Filters SharePoint List items that have empty cells in specific column
3. Selects Filtered Data
4. Creates HTML table from the Selected Filtered Data
5. Creates Email Message and inserts HTML table into the body of the email
6. Submits email message to user
The fact is that SharePoint List contains Choice Field. When I use SELECT action to take Choice Field Element Value I get the following statement:
{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"РЗН"}
How to get the value of the Choice Field directly using SELECT action? Or is there any other means I can reference the Choice Field Value?
Here is my flow
