cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tobystatham
Advocate IV
Advocate IV

Invalid Argument Type in Filter function on a Common Data Model entity

I have the following Filter function Filter(Request, 'Site Type'.SiteTypeId=SiteTypeGallery.Selected.SiteTypeId, 'Request Status'="New Request")

 

On both the equal operators there a red squiggly line that says "Invalid Argument Type"

 

SiteTypeId is a number sequence field and 'Request Status' is a text field.

1 ACCEPTED SOLUTION

Accepted Solutions
rgruian
Power Apps
Power Apps

In PowerApps, the '=' operator can only compare primitive values: text, booleans, numbers, date/time values, etc. Please make sure that the values being compared in this case for each row are, in fact, primitive. That not being the case is the most likely reason you are seeing this error.

 

Radu Gruian [MSFT] ** PowerApps Staff

View solution in original post

4 REPLIES 4
rgruian
Power Apps
Power Apps

In PowerApps, the '=' operator can only compare primitive values: text, booleans, numbers, date/time values, etc. Please make sure that the values being compared in this case for each row are, in fact, primitive. That not being the case is the most likely reason you are seeing this error.

 

Radu Gruian [MSFT] ** PowerApps Staff

Thanks, it was partly user error Smiley Sad I had two columns with similar names. Using the other one works.

 

Just to let you know that you can use the Number Sequence field for this type of situtation and it works

Great, glad to hear that.

Radu Gruian [MSFT] ** PowerApps Staff

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,545)