Filter array on Sharepoint multi-value lookup column

(0) Share

Report

Posted on by jfcole70

Hello all!

After much head banging on desk, any help would be much appreciated please 🙂

I have the list, '..Master' that has a lookup multi-value lookup column called Staff_in_attendance which is a list full of staff names.

I'm attempting to filter the Master list by entries that have a particular staff member within the multi-value lookup column.

the output is always null. I've tried quotes around 'System Operations', I've also verified that the staff entry does exist several of the master list entries. I'd like to reformulate this into a power app triggered query sending the flow the staff name and returning the ID's of all the Master list entries that contain the staff name in the multi-value lookup column, staff_in_attendance.

I've accomplished this purely in the power app but because of delegation limits looking for a more scalable solution.

Thank you!

James

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Paulie78 8,422 Moderator on at

Like (0)

Report

I think it would be better to have your query as an odata filter, then you'd have no need of the subsequent filter in the first place. Do you know what I mean?

The problem is with your query is that the "Name" of the person is gone and it is just an ID reference to the master list. If you look at the output of the Get Items query you will see what I mean.

Was this reply helpful? Yes No
jfcole70 4 on at

Like (0)

Report

Thank you Paulie78, that did the trick!

Thank you for pointing me in the right direction - what threw me off was info from another post with outdated info saying you couldn't reference underlying lookup info in the odata query of getitems and the workaround was the filter.
This is the working query - Staff_x0020_in_x0020_Attendance/Id eq 3321

Could not get the value query supplying the name working though (as you pointed out) here's the output of GetItems:
"Staff_x0020_in_x0020_Attendance": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 2692,
"Value": "John Smith"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 3321,
"Value": "System Operations"
}
],
"Staff_x0020_in_x0020_Attendance@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
"Staff_x0020_in_x0020_Attendance#Id": [
2692,
3321
],
"Staff_x0020_in_x0020_Attendance#Id@odata.type": "#Collection(Int64)",

Was this reply helpful? Yes No