Filter a Gallery based on a values belonging to a collection

[anilrambhajan]

Please Help.. I want to filter data in my gallery based on a list of values in a collection. 

I get delegation warning. Requests is the name of my sharepoint list which is the data for the gallery.

myTeamName is the collection which has several values

[BCLS776]

Hi, try adjusting your filter so that it references Team.Value to something in the Requests Sharepoint list. Filter() acts by comparing the records in Request to your expression. If the expression does not return true for any record in Requests, then no records will be returned.

Hope that helps,

Bryan

[anilrambhajan]

What is the syntax to filter the gallery against the collection which can contain multiple values?

[BCLS776]

Try:

Filter(Requests, Team.Value in Concat(myMultiChoiceColumnName,Value))

This assumes Team.Value is a string and you have replaced myMultiChoiceColumnName with the name of the applicable choice column from the Requests list.

[anilrambhajan]

Thank you for your responses. I appreciate it but this is the current scenario:

The 'Requests' sharepoint contain a field called 'Team'. This field will only have one value.

I want to filter all requests in my gallery where the Team resides in my Collection.

This is my collection. My collection can have one or more values

Can you help with the syntax to filter my gallery?

I want all items in the Request list where the Team Name is in my collection of Teams

[BCLS776]

That additional information helps tremendously. Most users want to use a dropdown control to handle multiple filters such as the myTeamName collection. To do that, please do the following steps:

• Insert a dropdown (assume it is called Dropdown1) outside of the gallery and set its Items property to myTeamName.Title
• Set the Items property of the gallery to Filter(Requests, Team = Dropdown1.Selected.Title)

When the user selects each team in the dropdown, the gallery will auto-update the filter to match the new selection.

Hope that helps,

Bryan

[anilrambhajan]

Thank you for your suggestion but my use case is slightly different.

It's a help desk system and based on the category selected at the time of creating a ticket, it it automatically assigned and routed to a Team.

A team can consists of one or more users and the same person can belong to multiple Teams

I want to have an interface where the user can see all the tickets assigned to his/her team

The collection has one or more teams the logged in user belongs to.

I want to filter the gallery to say, give me all requests where the team assigned is equal to any of the teams in which the user belongs to.

This listing should be automatically loaded when the user lands on a page called "Tickets assigned to my team"

Does the above give some context as to what I need to acheive?

[BCLS776]

OK, if I understand you correctly, then the myTeamName collection is the list of teams that this user is a member of, and you want to bring up all requests that pertain to any of their teams. That's a slight adjustment to the filter:

Filter(Requests, Team in Concat(myTeamName,Title," "))

This assumes the Team column in Requests contains single line of text (string) data. It pulls the team names from the myTeamName collection together into a string for comparison to the string from the Team column.

[anilrambhajan]

Thank you for taking the time to understand my troubles and assist me. This does in fact return the current results but I am faced with a delegation warning (see img. below) which I would like to avoid. Any suggestions to help with this?

[BCLS776]

The "in" operation is causing the delegation warning - we can make adjustments to go around that, but at the moment is that filter working?

If you never expect to have more than 2000 records in Request, we can completely ignore the delegation warning. If you do expect lots of records, let us know and we'll help you build a delegable (but slightly more complicated) filter query.