2

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

Improve this question
2
  • Will there be only one user selected all the the time in multiple selection field?
    – Ganesh Sanap - MVP
    Oct 13, 2022 at 2:02
  • No, in some cases there will be multiple names in the section field
    – Sam Albrecht
    Oct 14, 2022 at 12:48

1 Answer 1

Reset to default
0

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

@{item()['LookupValue']}

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

item()['LookupValue']

Example:

enter image description here

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

Improve this answer
7
  • 1
    Thank you, that worked. I just had to modify it to item()['DisplayName']
    – Sam Albrecht
    Oct 14, 2022 at 14:23
  • Great, glad it worked for you!
    – Ganesh Sanap - MVP
    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.
    – Sam Albrecht
    Oct 14, 2022 at 19:10
  • Use "Outputs" of compose action as input to "Apply to each" action.
    – Ganesh Sanap - MVP
    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.).
    – Sam Albrecht
    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.