I read through several other posts on filtering and being new, I just don't understand how to apply it. I have a page, that takes a selected project id from the previous page and displays all the project tasks. This works great. However, I want to filter the list based on the "% Complete" not equal to "100" and the resource name being the user. I've been trying to add a Filter to the Items, but it doesn't like the ProjectOnline.ListTasks as a datasource.
Below is how the "Items" is set. Any suggestions on how to add the filters would be appreciated.
Solved! Go to Solution.
Just answered my own question....Microsoft Project Online. I don't have access to this but maybe I can help clear up Filter command.
Filter wants a 'Table' as the datasource. Your "Items" pictured is drilling all the way down to .Value
Instead, try removing .Value and wrap a filter around that...
Filter(ProjectOnline.ListTasks(ProjectList.Selected.Id,"url"), PercentComplete<>100, <condition2>, <condition3>)
No idea what "PercentComplete" actually is, that's just a guess. It should provide you a list of the items when you reach that point in the expression
While I was playing with the gallery I found If I remove the ".value", my gallery won't display any data. Removing it now, and adding the Filter, the Filter command errs for an "Invalid Argument type" for the data parameter.
I'm really embarrased I would have swore I tried that exact syntax and it erred. I tried again and it worked. I've been poking it from so many different directions I may have had a typo. I greatly appreciate your assistance.
Don't be, it's buggy. I find that cutting the text and re-pasting it back in the expression box works many times. You very well may have had it before. Sometimes it shows you one thing but actually has something else 'stored'....
I've saved/closed an app, restarted browser, and re-opened an app to find that "Items" contained "Filter(mycolle" when it was actually showing me "Filter(mycollection, blah=blah)" before I saved it. It's like it doesn't register everything typed at times
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200