Like Dual Authentication - verifying info in data

[Jeffrey_H]

Hello,

I'm working using a button to look up 2 variables in a Sharepoint List

The 2 variables are:

  Student ID

  Security Code

When I click on the button, I'm want to go out and verify both

If it's TRUE then it will show in a display box.

here's an example

I used this before when just looking for a Student ID = 'sbox - ID'

On Select = UpdateContext({varSearch:'sbox - ID'.Text})

Now I would like to add a second level of verification with the same search button.

On Select =

UpdateContext({varSearch:'sbox - ID'.Text});
UpdateContext({varSearch:'sbox - Security_ID'.Text})

I'm sure its fairly simple to accomplish this - please give suggestions.

Again, I am attaching an Excel file that has the data from the Sharepoint List:  [Student Thank You Cards for Donors]

I have also attached the app that I am creating.

After this works I will be looking at screens CheckOut_1 and CheckOut_2

My vision for CheckOut_2 is to scan the QR code next to the Fund and then send a command to the printer to print that address to a label printer.

Kinda outside of the norm, but it's a work in progress.  I would also appreciate suggestions for this but only after the Search button and lookup up is resolved on the 'Lookup Info' screen

[scalca]

are you trying to search for a student record based on student id and/or security code provided in search box ? 

so records would show up in the gallery below ? 

is there an error message ?

this code snippet you proposed 

On Select =

UpdateContext({varSearch:'sbox - ID'.Text});
UpdateContext({varSearch:'sbox - Security_ID'.Text})

would end up to update the same variable varSearch, I think you need two different one in order to have the correct search query
can you pls share the items property of the gallery below

[Jeffrey_H]

Here's the Item's property I believe.

[Jeffrey_H]

Did you have a moment to look at what I sent you yesterday ?

[scalca]

LookUp returns always one record only if this is what you want.

But this formula in your items property can't work.

As I mentioned store Id and securiry code in two different variables e.g. varSecuritycode and varId

Then LookUp('Students', 'security code column' = varSecurityCode || 'Id column' = varId) 

With that you would retrieve the first record matching security code or id

If you want all records use Filter()

[Jeffrey_H]

it kinda works, but I would like to have both filters Student ID and Security Code to be filtered/searchable and only display in the gallery if both match in that record.

[scalca]

then you have to use && instead of || 
LookUp('Students', 'security code column' = varSecurityCode && 'Id column' = varId)

or Filter() if you want all matching records to be returned instead of one only