Answered

Sharepoint user base with power apps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I am working on a power apps project meant to help my company's employees to receive trainings via online education. The platform is meant to present to the students all the necessary information, course content, and other files in a concentrated manner. Students would be able to enlist themselves into specific courses and their progression within those courses would be recorded and displayed to them as either "ongoing" courses or "finished" courses. Right now, I have managed to create and connect a sharepoint list with my login and sign up pages. In this list, I store some basic user information such as username, password, role...etc. The authentication does work. But after this is where I am kinda stuck.

There are some functions for the web app that I would like to deploy to be restricted to specific user type. And considering I want to display some basic user information such as course progression, I must make the app run on individual sessions and load the corresponding information of the current user.

Essentially, at the current moment, even if there is an authentication process whenever the app is launched, no matter who the user is, they are all presented to the same app with the same information. I want to be able to load user specific data that only the current user can see. Would appreciate any kind of help. Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

zmorek 3,272 on at

Like (0)

Report
Copy link

Link copied!

I would caution against usernames and passwords in a SharePoint list - PowerApps implicitly shares that information with every user. A savvy user will find that list easily.

That said, you can use your userlist with the "role" column, and then on app start, look up that user's role and assign it permissions.

Set(varUser, LookUp(UserList,User().Email=EmailColumn))

Then you can apply varUser.Role on your controls. You can also use their identifying information (e.g. email) to filter your galleries, if you had to. For example, that way they only see things from a given datasource that have their email associated with it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you for the reply, could you perhaps specify more on the last part of your reply? How do we filter galleries? Is there any online ressource where I can take reference from?

Was this reply helpful? Yes No
Verified answer

zmorek 3,272 on at

Like (0)

Report
Copy link

Link copied!
Of course! You'll use Filter() on your gallery, and you can supply the function with a bunch of arguments to show specifically what you'd like. For example, something like:

Filter(DataSource,User().Email = Email)

That would make a gallery only show items from the data source whose email column is equal to the current user's email. You can expand on that with more filters, as well!

I like Shane Young's channel; he has a video for everything. Try these:

https://www.youtube.com/watch?v=kLGglidmPxg
https://www.youtube.com/watch?v=nlhWQg03TL0

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thank you very much for the answer, this channel you recommended is indeed very informative. Much appreciated.

Was this reply helpful? Yes No