Announcements
Hello,I have a clearcollect function that used to work in a previous version of my app. If I remove one of the logical tests from the Filter function it works, but when I use both it does not. I've verified that my SQL datasources have the proper names.
@VFRoderick
Can you give some more detail on what the error message is?
Certainly,The error is: The function 'ClearCollect' has some invalid arguments. Invalid Argument Type.I've also attempted to replace the ',' between the two logical tests with a and operator but this doesn't work as well.
So you mentioned that you removed one of the arguments and it worked...which did you remove? That would seem to be the suspect.
If you hover over the ComponentCollection in that formula, what error pops up on that?
Also, you mention this was working at one point. Has there been a datasource change? You might want to consider removing the ComponentsReceiving data source from your App and then add it back in. It's harmless to do and the app will then refresh all the underlying information about the datasource - possibly fixing your issue.
@RandyHayes Thank you very much. It looks as though deleting the datasource and pulling it back in solved the issue.Thanks, VFRoderick
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 397 Super User 2026 Season 2
Mohsin Ali 354
WarrenBelz 232 Most Valuable Professional