login screen with barcodescanner

[gennarodp]

Hello,

i would like to create a loginscreen in an app that use Barcode scanner.

In specific i have imported in my mobile app the excel table "Operators" with username and password columns.

I would like to concatenate this two values to enable the login with barcodescanner's support.

How could i do ? 

Thank you

[gennarodp]

Nobody ?

[MatthewInwards]

Could you include some screenshots of you application along with how you would like the app to work. I should then be able to help you. Also, are you using an external barcode scanner that plugs into your device, or are you using the powerapps element that taps into android and ios scanners?

[gennarodp]

Hello @MatthewInwards thank you for your answer.

i am using powerapps element that thap into ios.

the image is a simply login screen. At moment, I have two inputs (login and password) and a button that lookup login and password and permit login.

i would like to substitute those two inputs with barcodescanner element of powerapps that check concatenate username and password in an excel source.

[MatthewInwards]

So just to be crystal clear before I offer any code solutions. 

The barcode that is going to be scanned will contain the username and password within it.

e.g. if the persons user name was "John" and their password was "Crystal123" then the barcode would contain the value "JohnCrystal123"?

Then you would like the scanner to compare the barcode value to a concatenation of the username and password columns within your table that stores the logins. Then if they match allow them access.

Does what I have  wrote above sound right?

[gennarodp]

Exactly !

If it is correct, you should use a navigate to a browse screen, if not, there is a error message.

Can you help me ?

Thank you

[MatthewInwards]

Give me a little bit, I will see what code I can come up with for you 🙂

[gennarodp]

Ok thank you very much @MatthewInwards

[MatthewInwards · Accepted solution]

Use the following code on the OnScan property of the scanner element.

If(
CountRows(
Filter(
TableOfLogins,
Concatenate(Username,Password) = BarcodeScanner1.Value
)
) = 1,

Navigate(Screen2,ScreenTransition.Fade),

Notify("Incorrect login, please try again",NotificationType.Error)
)

You will need to change the table name to your and the column names if your column names arent Username and Password.

I hope this helps 🙂

[gabibalaban · Accepted solution]

Hi @gennarodp,

If(

     BarcodeScanner1.Value in

     AddColumns

          (TableOfLogins,"CheckValueColumn",Username&Password).CheckValueColumn,

     ....,

     ....

)

Hope it helps !