You’re offline. This is a read only version of the page.
129
I'm creating a flow to send and email with a table of items on a sharepoint list, I'm able to create the table as needed, but I'm having trouble with a field that is a multi select lookup column on sharepoint.
This is what my flow looks like currently
This is what the value from the get items returns for the field I need
Share
Report"Asignado": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 4,
"Value": "Name of Person 1"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 7,
"Value": "Name of Person 2"
I would need the value from this items (I censored the actual names for privacy), I tried using the Item().Asignado.Value and Items().Asignado.value but it seems to not work.
I found a solution, in case someone else has to do it.
All responses (
Answers (
replace(replace(replace(replace(string(xpath(xml(json(concat('{"root":{"choices":', string(item()?['Asignado']), '}}'))), '/root/choices/Value/text()')), '["', ''), '"]', ''), '"', ''), ',', ', ')
