My power automate solutions works fine for my single value columns, but I can't figure out how to identify and pull out the LookupValue(s) from the array of a multi-select columns.

{"__metadata":{"type":"Collection(SP.FieldUserValue)"},"results":[{"LookupId":2886,"LookupValue":"John Doe","Email":"[email protected]"}]}

I appreciate any help solving this.

enter image description here

  • Will there be only one user selected all the the time in multiple selection field? Oct 13, 2022 at 2:02
  • No, in some cases there will be multiple names in the section field Oct 14, 2022 at 12:48

1 Answer 1


Try using below expression instead of using "Outputs" from compose action:


If you are adding expression from Dynamic content > Expression popup, then use:



enter image description here

Don't forget to click on "OK" or "Update" after adding expression.

  • 1
    Thank you, that worked. I just had to modify it to item()['DisplayName'] Oct 14, 2022 at 14:23
  • Great, glad it worked for you! Oct 14, 2022 at 15:01
  • Ok after further testing what happens with the item()['DisplayName'] it displays the current name, not the previous name captured in the HTTP request. Oct 14, 2022 at 19:10
  • Use "Outputs" of compose action as input to "Apply to each" action. Oct 15, 2022 at 2:20
  • That works for cleaning up the previous name captured in the HTTP request, but now I can't get it to display the current name. (i.e.) It has changed from Joe to John. When I mess around with expressions and use triggerOutputs()?['body/CASC'] I get the whole CASC user info; name, email, id, etc.). Oct 15, 2022 at 11:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.