Answered

How to create a login page

(0) Share

Report

Posted on by mAlazraki

Hi! I'm making a login page that has the users connected to a List in SharePoint.

My problem is that i don't know how to validate the email and password that is in the textfield. i tried with this formula:

If( UserField.Text = Filter(contraseña_prueba2983;Título);
Reset(UserField) & Navigate(HomeScreen;Cover) )

But i know i'm comparing a Table with a String and i don't know how to do it. I appreciate any kind of help.

Thank you!!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

timl 36,415 Super User 2025 Season 2 on at

Like (1)

Report
Hi @mAlazraki

Here is a similar post that I wrote about creating a login page for Excel. The logic will be the same for a SharePoint data source.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Created-Log-In-But-cant-log-in/td-p/196312

Let's suppose that you create an email text box called txtEmailField and password text box called txtPasswordField. This is the formula that you would use.

If(CountRows(Filter(contraseña_prueba2983; Email=txtEmailField.Text && Password=txtPasswordField.Text))=1; Navigate(HomeScreen;cover); false )

The caveat I always add is that this method is not particularly secure. Any user with access to the SharePoint list can see the email and password entries that you store there.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (2)

Report
Hi @mAlazraki ,
Try this syntax - note you have not given the field names
If( Lookup( contraseña_prueba2983; YourUserField.Text = YourUserFieldName; Título //I assume this is the password )=YourPasswordFieldName; Reset(UserField);; Navigate(HomeScreen;Cover) )

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.

Was this reply helpful? Yes No
mAlazraki 11 on at

Like (0)

Report

It worked perfectly! thank you very much!!

Was this reply helpful? Yes No