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 / Invalid argument type ...
Power Apps
Answered

Invalid argument type in Lookup after Filter

(0) ShareShare
ReportReport
Posted on by 16

Hello Poweusers, 

 

I have a weird problem. 

I want to AddColumns to my datasource, but I need to Filter it aswell. I have no errors if I just use my AddColumns methode as below:

 

AddColumns(Location;"Equipment ID";LookUp(Equipment;'Location ID'=Location[@'Location ID'];'Equipment ID'))


 

But when I then try to apply a filter to the first argument of AddColumns like below:

AddColumns(Filter(Location;Route=1);"Equipment ID";LookUp(Equipment;'Location ID'=Location[@'Location ID'];'Equipment ID'))


I suddenly get the error that '=' is an invalid argument type (in the LookUp function)

 

I have tried so many things, but really do not understand why this is a problem. 

 

Hope someone can help me 
Thanks!

Categories:
  • CU-18081211-6 Profile Picture
    9,272 Moderator on at

    Hi @NichlasKoeppen 

     

    Can you show me the error using screenshot to see the details ?

     

    Thx !  

  • Verified answer
    timl Profile Picture
    37,418 Super User 2026 Season 2 on at

    Hi @NichlasKoeppen 

    If you alias the result of your Filter function with a name (using the As keyword), does that make a difference?

    AddColumns(Filter(Location;Route=1) AS FilteredLoc;
     "Equipment ID";
     LookUp(Equipment;'Location ID'=FilteredLoc.'Location ID';'Equipment ID')
    )

     

  • Pstork1 Profile Picture
    69,665 Most Valuable Professional on at

    Try putting the Filter around the outside of the Add Columns.  I think you are getting an error because you are trying to add a column to the filtered location, but then using the whole location for the lookup.  If you complete the Add Column first you should then be able to filter the results.

  • NichlasKoeppen Profile Picture
    16 on at

    This did the trick!!! Thank you very much!!
    To all you others that also wrote thanks for contributing. 

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 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 194 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 150

Last 30 days Overall leaderboard