Answered

Offline password database

(0) Share

Report

Posted on by pal95

266

Hi,

I would like to make an app that is working offline too.

Currently, I have a standard login and password functionality with all passwords (and password creation functionality) stored in Excel --> One Drive. The user types his login/password and the app checks if it is correct in Excel.

What would you suggest as a database (if anything) so the application can work offline and does not need to use an excel file it can't connect to anyway? Can I do something like, for example, storing this database internally in users' devices and just update it when people are online?

tl.dr. - I need offline password verification which can be updated by users by creating new logins/passwords when they are online and still verify the correctness of the passwords when they are offline.

Thank you for your time!

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

If you are already having a login code, that can be modified to enable users login offine. Can you display the existing code?
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
pal95 266 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

Thank you for your reply. Here is my code:

If( IsBlank( LookUp( UsersTable, Username = TextInput2.Text && Password = TextInput3.Text ) ), Set(errorMessage, "Wrong account name or password") & Reset(TextInput3), Set(errorMessage,""); Navigate(FacilitySelect, ScreenTransition.Fade, {ValName: TextInput2.Text}) & Reset(TextInput3) & Reset(TextInput2) )

Screens of the app attached too. I would like to keep the functionality of registering new users, if possible.

Thank you,
Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

If you want to add new entries while offline, watch:
https://youtu.be/aIwbcCag9B4?t=13
pal95 266 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, will watch soon and if it is the solution, I will mark it
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

That is fine