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
PowerApps Staff rgruian
PowerApps 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
4 REPLIES 4
PowerApps Staff rgruian
PowerApps 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
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

PowerApps Staff rgruian
PowerApps 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
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 132 members 4,543 guests
Please welcome our newest community members: