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.
It would be easier to make a recommendation if some sample data were supplied.
Can you please provide:
---
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."
Hi @mdevaney
thanks for replay,
we are having three List in sharepoint.
1. Team List
2. Department list
3. Issue Report list
So In PowerApps OnVisible Screen, I need to get the list of the department responsible for Team (like Team A,B etc) and need to collect the List of issues in collection based on the Department.
The collection data need to shows in PowerApps Gallery.
Note: I am having RespDepartmentID integer column in Issue Report List which contains the ID of the Department List.
Thanks
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
272 | |
256 | |
87 | |
39 | |
34 |
User | Count |
---|---|
348 | |
262 | |
130 | |
68 | |
48 |