cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tobystatham
Level: Powered On

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
Power Apps Staff rgruian
Power Apps Staff

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

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
Power Apps Staff rgruian
Power Apps Staff

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

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

tobystatham
Level: Powered On

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

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

 

tobystatham
Level: Powered On

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

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

Power Apps Staff rgruian
Power Apps Staff

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

Great, glad to hear that.

Radu Gruian [MSFT] ** PowerApps Staff

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (4,956)