Announcements
Hi!
I'm wondering if it's possible to create user account based on the data that they used to log in. All the data is in Excel Table, but i cannot figure out a way to do that.
Can you explain what you mean a little bit more in depth?
You can link an Excell table to a Power App and use it like a data source.
You can also use a LookUp function to find a row based on the user's info that is logged into the Power App.
You can also use that info from the row to create a user profile page in the app.
If these arent what you are trying to do then try to explain it in a bit more detail and we will be able to help you out more!
Hi! Thank you for your help ❤️ I will try to explain it a little bit better.
So i created log in page, now i want to create user account, but i can't really figure out how to do it.
I have all of the data in excel, login and password too, is there a way to automatically open user account based on the data that they used to log in after they click login button?
Yeah here is something you can try:
Login button OnSelect:
Navigate(UserProfileScreen, ScreenTransition.None, {userData: LookUp(YourExcelTable, UserName = User().FullName}) you can also use email such as UserEmail = User().Email or LoginName = TextInput.Text where the blue text is above.
At this point you will be on the User Profile screen and can then either use a form or build your own screen. I like to build my own screen using labels etc but this is really up to you either way. If you use a form then make the data source your excel table and make the item userData. If you use a custom built form using controls then you can put your labels whereever you wish and then set them individually. For example place a label for the user's name wherever you want it and set its text property to userData.FullName where FullName would be the column name in the excel table. Repeat this for all the data/info you want to show.
Hi! can you explain how to do it a bit more?
I'm adding my formula at the moment, i cannot really understand how to do it
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 337 Most Valuable Professional
11manish 173
Valantis 86
