Answered

Users based on login data

(0) Share

Report

Posted on by Martaaa

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

mmollet 3,187 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Martaaa 6 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Martaaa 6 on at

Like (0)

Report

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

image.png

Was this reply helpful? Yes No