Hello all,
I have a Sharepoint list column with a drop down selection checklist that allow to select multiple undertakers of respective task. While I use a power automate flow to extract relevant information from this column to an Excel row, I can only see a single result (only one undertaker) not all of them.
When I use the dynamic content "@{triggerOutputs()?['body/OData__x627f__x8fa6__x4eba_2']}" the out-put result are as follow:
[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"Edward"},
"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"Jimmy"}]
When I use the dynamic content formula"@{items('apply to each item')?['Value']}" the output result will be only one undertaker "Jimmy".
Is there any method to extract all the undertaker shown in a multiple selection checklist?
Thanks!
