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

Re: (=) suddenly Invalid argument

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.


 

Data_Enthusiast
Level: Powered On

Re: (=) suddenly Invalid argument

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.

Super User
Super User

Re: (=) suddenly Invalid argument

@Data_Enthusiast 

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.

Helpful resources

Announcements
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 343 members 5,570 guests
Please welcome our newest community members: