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

View solution in original post

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (72,584)