Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Filter Data from Sharepoint List with Multi data in Single Column

Hi all, 


I am having a list of Teams which contains from A to G and each Team having responsibilities of Multiple department. so I am having separate list in SharePoint for Teams & Department.


I am getting the responsible department ID using below Command:



ClearCollect(RespDepartmentID, Filter(DepartmentList,ResponsibilityTeam = "Team B").ID)




some Teams having the responsibilities of more than one Department like Team B having 2 Department  and Team A having 4 Department.


So my Issue is I need to filter the Data using single column with multiple ID like below code i used.



ForAll(RespDepartmentID,Collect(RespIssues,Filter('Issue Report List', DepartmentID= First(RespDepartmentID).ID)))



the above code is working and its get the list of items only for First Department  ID NOT for responsilbe of Department ID.


from above Team B having 2 department but it list only one department Data (that is First in the collection).


Please help anyone how to resolve this.

Super User
Super User

Re: Filter Data from Sharepoint List with Multi data in Single Column


It would be easier to make a recommendation if some sample data were supplied.


Can you please provide:

  • Sample rows from your SharePoint list
  • An example of what rows the Filter should return when applied

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Helpful resources


Power Apps Super User Class of 2020

Check it out!


New Badges

Check it out!


Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,460)