Filter Drop Down on Current User

(1) Share

Report

Posted on by LA-20082220-0

Hi All,

This might be a very simple issue (I'm very new to Power Apps), but I have a Canvas App with a Dataverse data source and I'm having trouble getting a drop down that should be filtered on the current user to work.

Basically, the formula for the drop down is:

Filter(

'Power BI Datasets',

'Report User'.'User Principal Name' = User().Email

)

"Power BI Datasets" is the table name. "Report User" is a field in that table that's a lookup field connect to the "Microsoft Entra IDs" table.

I get the following error with this drop down:

Any help that could be provided would be much appreciated!

Thanks!

Categories:

Using Apps Using Formulas

All responses (8)

Answers (0)

LA-20082220-0 20 on at

Like (1)

Report

Filter Drop Down on Current User

Hi @FLMike,

Thanks for the response. The data matches between what's in the Dataverse table and what appears in the Edit screen of the datasource on the app. Here are the screenshots (with the environment name):

Yet, the app gives the error I mentioned:
Suggested answer

Michael E. Gernaey 41,007 Super User 2025 Season 1 on at

Like (1)

Report

Filter Drop Down on Current User

Hi,

It has to be published before it works in other environments.

But not for your Dev... Well it can in fact sometimes cause issues, but only because, well thats too long to explain.

I want you to do something else please

1. Go into your App

2. Go to your Data Tab

3. Go to your Source and click the ...

4. Click the Refresh Data

5. After it does Click ... and Edit

It should open the datasource, and thats on the back end. So, you need to look there. If they are not the same then again I need you

If that doesn't work, then I want you to click ... and click Remove

Then immediately save/publish

Then immediately Add it back

Then Save / Publish it

Now see if it works.

If not

1. Show me a picture of the Table, IN the right environment (DV orSharePoint), don't tell me, show a picture

2. Then show me a picture o fthe environment this app is in, again a picture please.
LA-20082220-0 20 on at

Like (1)

Report

Filter Drop Down on Current User

Hi @FLMike,

I tried your suggestion. However, when I play it, only a blank screen shows up with one red dot, and no errors show up in the Monitoring section.

Question though: Does the app need to be published before this works? Because it does say "Play published app". My app is not published yet.
LA-20082220-0 20 on at

Like (1)

Report

Filter Drop Down on Current User

Hi @Meekou,

I tried the formula you suggested, it still leads to an error.

Question: What is the "Result" supposed to be? Should I be defining it elsewhere?

Thanks!
LA-20082220-0 20 on at

Like (1)

Report

Filter Drop Down on Current User

Hi @nirace,

Thanks for the response. I can load all the data, just can't filter it. Without the filter and just loading "Power BI Dataset" into the drop down, all items show up in the drop down.

I can also load the data from the "Microsoft Entra IDs" dataset. So it seems like all the data is there, but it just doesn't filter. Any thoughts on what might be the issue?

Thanks!
Meekou 189 Super User 2025 Season 1 on at

Like (1)

Report
Filter Drop Down on Current User

For this issue, it is caused by that "User Principal Name" is not available in RelationShip Table. If you try code below

Set(T3, First('Power BI Datasets').'Report User');

You will see you can only get rows below

For your request to filter by user, I suggest you try below:

Set(Result, Filter('Power BI Datasets', 'Report User'.Id = User().EntraObjectId));

Best Regards
Meekou
米可爱分享 - YouTube
Power Apps
Power Automate
nirace 9 on at

Like (1)

Report

Filter Drop Down on Current User

Seems like a permission issue.

Are you able to load any data from CRM?

Or it is just with "Power BI Dataset"?

If it is a custom table, then Premium license is required.
Suggested answer

Michael E. Gernaey 41,007 Super User 2025 Season 1 on at

Like (1)

Report

Filter Drop Down on Current User

HI,

Its possible its a permission issue.

Can you please do this.

1. Stop the App

2. Go to the Apps Tab

3. Select the ... at the end of the row with your app name

4. Select Detail => Monitor

5. Once Monitor Launches, click Play Published App

6. It will open your app in another tab

As soon as the error happens, close your App Tab

Click back over to the Monitor Tab

7. in the Filter Box (Top Right), type Error

8. Look through the Errors. You will find that when you get to the area where your error happened you probably will have 2-4 rows of Errors in a row.

You want to find the one that has 4 Tabs. The 4rth tab is the Response (its a window that opens on the right side)

Click the Response Tab

Make sure to Open the Body and the Header JSON

The body should tell you a better error message, so you'll know what to do.