web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / ClearCollect not worki...
Power Apps
Answered

ClearCollect not working with filter with multiple logical tests

(0) ShareShare
ReportReport
Posted on by 8

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. 

clearcollectissue.PNG
Categories:
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @VFRoderick 

    Can you give some more detail on what the error message is?

  • VFRoderick Profile Picture
    8 on at

    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. 

     
  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @VFRoderick 

    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.

  • VFRoderick Profile Picture
    8 on at

    @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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 397 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 354

#3
WarrenBelz Profile Picture

WarrenBelz 232 Most Valuable Professional

Last 30 days Overall leaderboard