Select multiple items for table

(0) Share

Report

Posted on by FGRODRIGUEZ

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

"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.

All responses (1)

Answers (1)

Verified answer

FGRODRIGUEZ 129 on at

Like (0)

Report
Re: Select multiple items for table

I found a solution, in case someone else has to do it.

replace(replace(replace(replace(string(xpath(xml(json(concat('{"root":{"choices":', string(item()?['Asignado']), '}}'))), '/root/choices/Value/text()')), '["', ''), '"]', ''), '"', ''), ',', ', ')