Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

(=) suddenly Invalid argument

Suddenly most of the galleries and text items where filter and count formulas are used stopped working. It shows nothing and a warning states "Invalid argument type" where the "=" syntax is used. I.e CountIf('Open Critical Incidents',Status="Active") and Filter(Messages,Visibility="Visible"). Source is Sharepoint online lists.


My whole app is now not working cause of this error. It stopped working without me doing any change to the source or to the app,





For me the .Value don't change the problem

@Aswet wrote:

Thanks, the .Value worked!

Strange that things like this just happens. Someone must have change the syntax qualifier.


Post Patron
Post Patron

Hi. I am very new to PowerApps.


I am unable to create an if statement using the '=' operator. I am using a SharePoint list as my source.


The formula reads: if(SharePointList.Year = 2019, "Yes", "No")


This seems like a simple formula, but for some reason it is not working. Please help.


I would recommend starting a new thread on this forum as this is an old posting that has already been solved (it will get more attention as a new post)


However, consider that your If formula is trying to compare the Year of the entire list to 2019...that's not going to work.

You will need to compare a specific record field.  So something like this would work:

   If(Lookup(SharePointList, ID=someId).Year = 2019, "Yes", "No")

Again, you need a specific record/field to work with.



Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!
Frequent Visitor

ForAll(Shop;UpdateIf('Devices'; ID_ = ID; ({Qty: Qty - Qty_})) please solve my problem i want to minus my Share point list 
with my collection data field in power app i am use this formula but not working ?


ForAll(Shop;UpdateIf('splistDevices'; collection ID_ =sp list ID; ({Qty: Qty - Qty_}))

Helpful resources

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (6,325)