Canvas App writes same Login info in Excel - LookUp or Patch?

[wristtattoo]

Hi all,

I can't find anything on this forum similar hence my post. The user journey I'm trying to achieve is the standard one we're all familiar with - already registered? Enter your email / password and login. I need a formula that checks the datasource (excel in my case) as currently if you use the login details it writes a new _PowerAppsID_ which I do not want it to. I've tried a LookUp formula and Patch formula but both haven't worked.

Canvas App noob - first one I've produced! Thoughts and suggestions welcome. Thank you!

[Carlosr]

Patch updates the information in the Excel spreadsheet, it doesn't retrieve it.  Try the Search function.

[Carlosr]

Try this:

Set(Result, Search(UserTable,  UsernameInput.Text, "Username")); 
Set(PasswordResult, First(Result).Password);

[wristtattoo]

Thank you for your reply. Would this formula go on the Button? Currently it checks if the form entries are valid and submits.

[wristtattoo]

Thank you for your reply. Sadly your method didn't work and may have not described my problem as accurate as I thought. I want this screen to behave like any standard web site sign up form, if the account exists tell the user it does and offer a password reset.

I wussed out for demo purposes and used User().Email to simulate the user already logged in with their Office365 account!

[Carlosr · Accepted solution]

May I ask what kind of user would be logging in with such a screen?  Canvas apps require the user to already be authenticated in Microsoft 365.  Why log in again?