web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Filter by array elemen...

Power Automate

Answered

Filter by array element within array

(0) Share

Report

Report

Posted on by FabvE

79

Hi all,

I used the Select-action to create an array of planner tasks from a planner board.

I managed to filter the information by bucketID to get only the tasks from a specific bucket. Now I'm trying to filter for the tasks which are assigned to a specific userId.

My problem is, that the assignments list per task is an array of 1 or more users within each task.

Array code

How can I use a second Filter Array action to get only tasks which contain a specific assignee (see within red box)?

item()?['_assignment']['userId']

as part of

body('Filter_Array')

did not work.

Anyone has a good idea? 🙂

Best regards

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hello @FabvE ,

you could convert the whole '_assignment' to string with the string(...) expression and then check if it contains the specific user id.

string(item()?['_assignment']) <contains> userId

Was this reply helpful? Yes No
FabvE 79 on at

Like (0)

Report
Copy link

Link copied!

That did the trick, thx! 👍

I used this second filter action on the first and it outputs only my tasks.

Was this reply helpful? Yes No

Join the conversation