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? Commented Oct 13, 2022 at 2:02
  • No, in some cases there will be multiple names in the section field Commented 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'] Commented Oct 14, 2022 at 14:23
  • Great, glad it worked for you! Commented 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. Commented Oct 14, 2022 at 19:10
  • Use "Outputs" of compose action as input to "Apply to each" action. Commented 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.). Commented Oct 15, 2022 at 11:57

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.