Single Sign On for PowerApps - SSO

(1) Share

Report

Posted on by nhtkid

188

Dear Power Users,

I am building an activity log type app and will be distributing to the whole org.

The app is built off a SharePoint list. Right now, I have a column of user ID so when user uses the app, they will manually type their ID and that gets recorded to the list. There is an ID field in my form to type that in.

I imagine for anyone to run the app, they need to have Power Apps license so the authentication has already happened with Office 365. Can I incorporate the SSO experience into the app that when different people uses this app, their UPN or email address will be automatically recorded into the list each time they create a new row of data (entering activity log).

Thanks all!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report
Hi @nhtkid ,

The User's name will be recorded in SharePoint if they add a record in the 'Created by' (name) and Created (date and time) columns and will remain there. Is this what you are meaning?

You could however also have a log file that gets patched with the same data each time a user logs in

Patch( ActivityLog, Defaults(ActivityLog), { OpenedBy:User().Email, OpenTime:Now() } )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
nhtkid 188 on at

Like (0)

Report

Hi @WarrenBelz ,
Thanks for the response.
Yes that will do, it will solve my issue.
We can use the "Created By" column to filter out specific users or even generating PowerBI report.
Thanks.

So if my list did not have that "Created By" column, do I just create it? Or is it something built in to the SP list?
Cheers,

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

Hi @nhtkid

'Created by' is an automatically generated field in SharePoint and contains the name of the user whose connection created the file. From Power Apps, this would be the logged-in user.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

Hi @nhtkid ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No