If Statement Error

Like (0) Share

Report

Posted on 13 Aug 2022 01:04:12 by Alex-W

314

I am trying to apply the username and password function to my app and I am getting an error I cannot figure out. Please help me figure this out.

This is the code I am using on a button (OnSelect):

If(!IsBlank(LookUp(DataSource, Title=TxtUserName.Text And Password=TxtPassword.Text), Navigate('Screen2'), UpdateContext({ShowForgetMessage: true})))

I am not getting any red error lines. Instead I am getting two App Checker errors:

Error 1: Invalid number of argument: received 3, expecting 1

Error 2: Invalid number of argument: received 1, expecting 2 or more

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 149,482 Most Valuable Professional on 13 Aug 2022 at 03:18:27

Like (1)

Report

Re: If Statement Error

Hi @Alex-W ,

You can use any field in the record that would not be blank if the record exists with the LookUp.

Was this reply helpful? Yes No
Alex-W 314 on 13 Aug 2022 at 02:51:28

Like (0)

Report

Re: If Statement Error

@WarrenBelz Disregard my second question about the code not work. I signed out of Power Apps and went back in and its working now. Not sure what's going on with my tenant at the moment.

Was this reply helpful? Yes No
Alex-W 314 on 13 Aug 2022 at 02:30:35

Like (0)

Report

Re: If Statement Error

Hello @WarrenBelz

Thanks for the help. The errors went away, but I have questions. I saw that you added .Title after the lookup section. Is this what you mean by testing a field rather than a record?

Also, this is not working like the tutorials I saw online. When I tried to test it, the forget password label that I setup is popping up when I press the enter button to send the username and password even though I am using the right information. Is there something else I need to configure?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 149,482 Most Valuable Professional on 13 Aug 2022 at 01:41:36

Like (0)

Report
Re: If Statement Error

Hi @Alex-W ,

Just some bracketing and it is always good to test a field rather than a record

If( !IsBlank( LookUp( DataSource, Title = TxtUserName.Text And Password = TxtPassword.Text ).Title ), Navigate('Screen2'), UpdateContext({ShowForgetMessage: true}) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No