0

I am trying to flatten a Power Automate array I have extracted from SharePoint to pass into an Apply to Each loop with Search for Users (V2).

The data I have extracted look like this [ { "UserID": "E234567" }, { "UserID": "E123456" } ] However I need the data to look like this

[ "E234567", "E123456" ]

I Have tried adding to an array variable but I always get an object. I have a co-pilot license and it is completely useless.

Improve this question

1 Answer 1

Reset to default
0

You'll want to use a Data Operation > Select action to to this.

  1. Add the action to your flow

  2. Switch the mode to text mode

enter image description here

  1. Use the function item()['UserID'] to map your passed in array to the output array

enter image description here

Your mapped array can then be used from the output of the Select action

Improve this answer

Your Answer

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.