Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Kelli Wolf]

Hi, I’m very new to PowerApps! I’m currently trying to make a log in page of sorts. On my Excel doc, I have a table with two columns- Name and Employee ID. On the log in page, I have a dropdown list so the user can find their name and then a text input so they can type in their Employee ID. I want a button that will be able to check that those two values match (and eventually go to the next screen) what is on the Excel table. I’m not sure which function (Match, LookUp, etc) would be the best to make this work.

——————————
K. Wolf
——————————

[Brian Scott]

Not sure if this will work for your application, but it may be easier for the user if you just check the User against the list of people who are allow to use the app. Just add 
Set(var_User, User())
to the OnStart of the app, then you can check that against the list of people who can use the app. Of course, you can also limit the people who have access by who you Share the app with.
If I misunderstood what you’re trying to do, let me know.

——————————
Brian Scott
Chief Creative Officer
Concord NC
——————————
——————————————-

[Kelli Wolf]

Thanks for the response! Unfortunately it’s an app for a set of technicians who don’t necessarily log into any system, they just have a general login and go from there. But I want to be able to track who is using the app and what they’re doing on it, hence the log in screen.

So far I have this (which doesn’t work):
NextArrow(If(LookUp(Table2,ID = id_input && Name = name_dropdown), true, Notify(“Incorrect ID”)))

——————————
Kelli Wolf

——————————
——————————————-

[Rachel Albrecht]

Hi Kelli

Try:

If(id_input.Text <> (LookUp(Table1, Name = name_dropdown.Selected.Name, Text(‘Employee ID’))), Notify(“Incorrect ID”))

I’ve dummied up a table and put this on the OnSelect of a button (which I am assuming you are doing the same?)

See how that goes for you!

Rach 🙂

——————————
Rachel Harris
Business Applications Specialist
configatek
info@configatek.com
——————————
——————————————-

[Vishal Mistry]

Hi Kelli,

Use Lookup, Navigate & If combination

Lookup from your data source based on the Name and Employee ID, and if it does not return blank then navigate to the next screen else do nothing

If(!IsBlank(LookUp(<DataSource>, DropDown.Selected.Value = Name && TextBox.Text = EmployeeID, Name)),
Navigate(<NextScreen>, Transition.Fade)
)

——————————
Kind regards,

Vishal Mistry
——————————
——————————————-

[Kelli Wolf]

Thank you both! Vishal’s code had the least amount of errors when I put it so I stuck with that one. I had to change DropDown.Selected.Value to DropDown.Selected.Result but it works! Thanks again!!

——————————

——————————
——————————————-