How to Display Data for the Current User in Power Apps
Question details
Create a Power Apps screen that shows records belonging only to the currently signed-in user.

- Product
- Microsoft Power Apps
- Device & OS
- not provided
- Scenario
- Filtering an app gallery or data table to display personalized or private records based on the user's Microsoft 365 identity.
- Observed behavior
- The user wants to successfully filter a SharePoint list or other data source so that each user only sees their own assigned records using their User Principal Name.
Ensure your Power App is connected to the Office 365 Users connector and that your data source (such as a SharePoint list) contains an email or User Principal Name column to match against.
Filter Data Using the Office 365 User Principal Name
Store the current user's profile information in a global variable when the app starts, then use it to filter your gallery or data table.
By setting a variable on the App's OnStart property, you avoid querying the user profile multiple times, which improves app performance.
This variable can then be used across different screens to filter galleries, forms, or data tables so that only the signed-in user's data is displayed.
Go to the Data panel on the left sidebar, click 'Add data', and search for 'Office 365 Users'. Select it to add the connection to your app.
Select the 'App' object at the top of the Tree view. Change the property dropdown to 'OnStart' and enter the formula: Set(UserProfileUPN, Office365Users.MyProfile().UserPrincipalName)
Select your Gallery or Data Table. Change the 'Items' property to use the Filter function, such as: Filter(YourSharePointList, UserEmailColumn = UserProfileUPN)

Looking for a fast, reliable alternative for your daily Office tasks?
While Power Apps handles your specialized business application needs, you might be looking for a smoother experience for everyday documents. WPS Office is a lightweight, fully-featured office suite that seamlessly handles Word, Excel, and PowerPoint files.
- 1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install seamlessly: Run the installer and follow the quick setup guide to get WPS Office ready in minutes.
- 3. Open your files: Launch WPS Office to directly open, edit, and save your existing Microsoft Office documents without format loss.

Frequently Asked Questions
Can I use the built-in User() function instead of the Office 365 Users connector?
Yes, you can use User().Email to capture the current user's email address without an external connector. However, using the Office 365 Users connector guarantees you get the exact User Principal Name (UPN) and provides access to additional profile details like Manager or Department.
Does filtering the gallery secure my data from other users?
No. Filtering data on the client side in Power Apps simply hides it from the user interface. Tech-savvy users could theoretically intercept the network traffic to see other records. For true data security, you must configure Row-Level Security or item-level permissions in your backend database (like SharePoint or Dataverse).
Why is my Power Apps gallery showing no items after applying the filter?
This usually happens when the data types in your comparison don't match, or if the variable hasn't been populated. Ensure that the column in your data source is a simple text column matching the UPN, and remember to right-click 'App' and choose 'Run OnStart' to populate your variable during editing.




