I'm working on a cloud based flow that exports a SharePoint list to a SQL Database.
The flow is uses the SharePoint action 'Get Items' then iterates through them (Apply to each) and uploads row by row to a SQL database.
This seems to work fine for SharePoint list column types such as Number and Text, but for Choices, the value is replaced with:
[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"xxxxValue1xxxx"}, [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"xxxxValue2xxxx"} etc..
Any ideas on how to replace/trim this string down to the Values?
Many thanks!