Unanswered

Creating a "Sign In Page" using data from an Excel formatted Table

Like (0) Share

Report

Posted on 31 Jan 2021 16:54:01 by Community Power Pla...

I'm trying to create a login page for a student project using credentials that are stored in an excel table. The data has already been formatted into a table ('Capture') and has already been linked to the "data" section of PowerApps. The code used in the screenshot 'Capture2' is what I found from other tutorials. 'Capture3' is the text I want to be displayed to the user upon an unsuccessful Login however it seems to pop up regardless even when the correct user credentials are inserted into the text inputs. I am unsure where to go from here

Categories:

General Questions

Using Apps Using Formulas

Mobile App

Capture2.JPG

Capture.JPG

Capture3.JPG

I have the same question (0)

All responses (5)

Answers (0)

LRVinNC 2,297 on 31 Jan 2021 at 18:35:50

Like (0)

Report

Re: Creating a "Sign In Page" using data from an Excel formatted Table

I believe that is because your actual column name in the excel file is UserEmail, not UserID. UserID was what I used in my test file. Try modifying the formula to replace UserID with UserEmail and then try this again.

Was this reply helpful? Yes No
Community Power Pla... on 31 Jan 2021 at 18:22:52

Like (0)

Report

Re: Creating a "Sign In Page" using data from an Excel formatted Table

(I changed UserEmail to UserID in excel and PowerApps before this screenshot was taken thinking it could be a naming issue)
Despite there being a successful connection between the excel dataset and PowerApps, it is displaying that no data could be found. I deleted the connection then re-established it however the same issue persists

Capture5.JPG

Was this reply helpful? Yes No
LRVinNC 2,297 on 31 Jan 2021 at 18:01:48

Like (0)

Report

Re: Creating a "Sign In Page" using data from an Excel formatted Table

Use the formula bar to view exactly what PowerApps is seeing. Go to you button OnSelect and then highlight the Table1.UserID portion. It should bring up a small > pointing down. Click to expand and you should see exactly what has been loaded from the table.

Repeat with the TextInput field to see exactly what PowerApps thinks is in the two fields.
Then repeat, if necessary with the Password fields.
Send me screenshots if that doesn't show you the disconnect.

Was this reply helpful? Yes No
Community Power Pla... on 31 Jan 2021 at 17:53:22

Like (0)

Report

Re: Creating a "Sign In Page" using data from an Excel formatted Table

I added the new code to the 'OnSelect' function however the label I have set to display when there is an unsuccessful login still displays even though the textinput1 matches the data within the excel document

Capture4.JPG

Was this reply helpful? Yes No
LRVinNC 2,297 on 31 Jan 2021 at 17:37:01

Like (0)

Report

Re: Creating a "Sign In Page" using data from an Excel formatted Table

The problem is the way the email address is coming in. I created a similar table. If you you look at the data actually in the table, you will see that Excel is appending mailto: on the front of each email address.

This appears to occur even if you enter the email address as text, not a hyperlink. So the easy solution to this is to simply append this same value to the text entered.

If(Concatenate("mailto:", TextInput1.Text) in Table1.UserID && TextInput2.Text in Table1.UserPassword, Set(GoodPW, true), Set(GoodPW, false))

This results in a successful match (as indicated by the value of GoodPW being set to true) when email1@test.com and Password1 are entered in the two text blocks. I display OK when true and Not OK when false to validate.

Was this reply helpful? Yes No