Hello everyone,
This is my first post so please be understanding 🙂
I have a problem, I want to create a login page with 4 criteria: first name, last name, contract and team.
After the user has filled in the 4 corresponding fields, the user should be redirected to another screen.
My data is stored in an Excel table. With Excel I can delete and modify my users, if a user does not exist anymore, the app should not give him access anymore. A user that does not exist on the Excel table should not have access to the rest of the app.
My problem is as follows: at present, my app only checks whether a user is mentioned in the table, but does not do so by line, for example.
In my table, I have :
See the following screen, it works :
but it also works if I do :
Because the app confirms that all the elements exist. However, they are 2 different users! So I don't want it to give him access. I have the same problem with the type of contract and the team my user is in. Everything is mixed up.
I tried 2 ways in Button do validate :
1st :
If(
FirstNameIn.Text in PeopleTable.FirstName &&
LastNameIn.Text in PeopleTable.LastName &&
ContratDd.Selected.Contrat in PeopleTable.Contrat &&
TeamDd.Selected.Team in PeopleTable.Team,
Navigate(HomeScreen)
)
2nd but I don't understand where I can insert Navigate() :
Filter(
PeopleTable,
FirstName = DataCardValue1.Text,
LastName = DataCardValue2.Text,
Team = DataCardValue8.Text,
Contrat = DataCardValue10.Text
)
I hope to be understandable
Thank you in advance!
