Unanswered

LookUp control doesn't work

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I'm new to power apps and I have a problem, I'm creating a login page for my application, and to do so the user has to enter his username and password. The application is linked to SharePoint, where the table containing this information is located.
but the problem is that my "OnSelect" entry doesn't work because there is an error I can't find. Here is the line :

If(LookUp(access_account, Title = username.Text, mukq) = password.Text,
Navigate([@HomeScreen], ScreenTransition.Fade), "")

the column of the identifier is "Title".
and the password column is "mukq".

thanks in advance and sorry for my english

Categories:

Power Apps portals

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-yutliu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

The right syntax of navigate should be like:

Navigate(Screenname, [, Transition [, UpdateContextRecord ] ] )

The third parameter should be like:

{ field1: ...,field2:... }

"" could not represent Record, it can only represent a string.

So if you do not want to pass any variable, you just need to use:

If(LookUp(access_account, Title = username.Text, mukq) = password.Text, Navigate(HomeScreen, ScreenTransition.Fade) )

// I think the screen name should be like : HomeScreen.

If you want to pass a variable(value is ""), you need to use:

If(LookUp(access_account, Title = username.Text, mukq) = password.Text, Navigate(HomeScreen, ScreenTransition.Fade,{variablename:""}) )

Here's a doc about Navigate function for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-navigate

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,
thanks for the answer but it still doesn't work, I've put a picture attached, so you can see.
Power apps gives me the error:
"Unexpected character. The formula contains "ParentClose" while "Error" is expected.
thank you for your answers.

Was this reply helpful? Yes No
TechnoKitty 68 on at

Like (0)

Report
Copy link

Link copied!

May I ask you why are you building login functionality? Portal provides both internal login (portal user) or external using Azure AD, Facebook or can integrate with other identities , here’s an awesome article from @nhayduk : https://www.engineeredcode.com/blog/power-apps-portals-authentication-overview
if you need to make look and feel custom, it’s also possible through css and scripts.
I presume there may be another reasons?

Was this reply helpful? Yes No