Is it possible to create two collections whereby there is a parent child relationship, the data needs to loaded into the app as live connection cannot always be guaranteed.
So I have collection of parent (colParentItems) items already filtered on load to be valid, what I want is an additional collection of all child (colChildItems) items from SharePoint where the child parent.id is in the colParentItems.
Sounds like a simple query, but it's beating me.. Tried following..
ForAll(colParentItems, Collect(colChildItems, Filter(SharePointList, Parent.Id = colParentItems[@ID])))
and
Filter(SharePointList, Parent.Id in colParentIems[@ID])
but neither is working for me, so am stumped..
Solved! Go to Solution.
Many thanks for coming back with a suggestion..
I tweaked mine again back to this and it seems to get all the items I want.. whereas previously it was only returning afew items..
ForAll(colParentItems,Collect(colChildItems,Filter(SharePointList,Parent.Id=colParentItems[@ID])));
I'm not certain, but the top solution might not be working correctly because the inner filter is meddling with the scope of your collections/data sources.
You could try:
ForAll(colParentItems, Collect(colChildItems, Filter([@SharePointList], Parent.Id = ID)))
Many thanks for coming back with a suggestion..
I tweaked mine again back to this and it seems to get all the items I want.. whereas previously it was only returning afew items..
ForAll(colParentItems,Collect(colChildItems,Filter(SharePointList,Parent.Id=colParentItems[@ID])));
User | Count |
---|---|
197 | |
125 | |
88 | |
49 | |
42 |
User | Count |
---|---|
284 | |
163 | |
138 | |
75 | |
73 |