Like Dual Authentication - verifying info in data

(0) Share

Report

Posted on by Jeffrey_H

118

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

Student Thank You...

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

scalca on at

Like
a
(0)

Report
Copy link

Link copied!

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 118 on at

Like
a
(0)

Report
Copy link

Link copied!

Here's the Item's property I believe.
Jeffrey_H 118 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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 118 on at

Like
a
(0)

Report
Copy link

Link copied!

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 on at

Like
a
(0)

Report
Copy link

Link copied!

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