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)

Sort by

Verified answer

timl 37,229 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
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 155,927 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

It worked perfectly! thank you very much!!

Was this reply helpful? Yes No