Others

How to Display Data for the Current User in Power Apps

Steven ParkerSteven Parker Nov 3, 2026 870 views

Question details

Create a Power Apps screen that shows records belonging only to the currently signed-in user.

How to Display Data for the Current User in Power Apps
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.
Before you start

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.

Solution 1Recommended

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.

1
Add the Office 365 Users Connector

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.

2
Set the OnStart Variable

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)

3
Filter your Gallery or Data Table

Select your Gallery or Data Table. Change the 'Items' property to use the Filter function, such as: Filter(YourSharePointList, UserEmailColumn = UserProfileUPN)

Filter Data Using the Office 365 User Principal Name
Manually Run OnStart During Editing: If your gallery is blank while building the app, right-click the 'App' object in the Tree view and select 'Run OnStart'. This manually triggers the variable creation so you can see your data.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
  2. 2. Install seamlessly: Run the installer and follow the quick setup guide to get WPS Office ready in minutes.
  3. 3. Open your files: Launch WPS Office to directly open, edit, and save your existing Microsoft Office documents without format loss.
Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx)Lightweight application that uses minimal system resourcesFamiliar user interface with no learning curve requiredBuilt-in robust PDF editing toolkit at no extra cost
microsoft office alternative - wps office

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.