Filter Gallery by Current User

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I'm trying to figure out how to filter the gallery so that the current user only sees its own data entries.

I've read many posts in the forum but none was able to provide me the correct solution.

This is what I did so far:

Set(VarUser; User()) //declared in App

SortByColumns( //in Items in Gallery
Search(
Filter(
[@MonthlyStatement];
   "EmployeeName" = VarUser.FullName);
   TextSearchBox1.Text;
   "crb06_MonthlyStatementID");
   "crb06_MonthlyStatementID";
   If(SortDescending1; Descending; Ascending)
)

This shows me no results at all even though the entry was successful.

This is the code without the filter and it's working properly:

SortByColumns( //in Items in Gallery
Search(
[@MonthlyStatement];
   TextSearchBox1.Text;
   "crb06_MonthlyStatementID");
   "crb06_MonthlyStatementID";
   If(SortDescending1; Descending; Ascending)
)

My table from which I'm retrieving the data looks like this:

MonthlyStatementID	EmployeeName	Project
0001	Jack Wick	Data security

The data is connected via Dataverse.

Any suggestion on what I could try?

Thanks!

Categories:

Building Power Apps

All responses (7)

Answers (2)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

The solution that works for me is to create a global variable in the OnStart of the app.

Set(useremail, User().Email) or Set(useremail;User().Email)

Then the Items property of the gallery

Filter( AddColumns( Orders, "UsersEmail",'Created By'.'Primary Email' ), UsersEmail = User().Email )

This takes advantage of the metadata stored in a Dataverse table for the individual who created the record in the Orders table. In your case:

With( {wMonthlyStatement:Filter( AddColumns( [@MonthlyStatement];"UsersEmail";'Created By'.'Primary Email' ); UsersEmail = User().Email ) }; SortByColumns( Search( wMonthlyStatement; TextSearchBox1.Text; "crb06_MonthlyStatementID" ); "crb06_MonthlyStatementID"; If(SortDescending1; Descending; Ascending ) ) )
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@Drrickryp

Thanks for the reply. This worked.

Now I still have two questions though:

- Why did we set the global variable usermail and then didn't use it in the filter but used?
UsersEmail = User().Email

- Now if I want to see the monthly statements that I created, Power Apps displays an error that the formula
BrowseGallery1.Selected
is invalid because a "DataSource" compaitble values was expected. The name "BrowseGallery1" is correct.

Do you know how I can fix this?
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Yep,

You need to use

Lookup([@monthlystatement],ID= Browsegallery1.Selected.ID)

Since you changed the datasource in the gallery it is no longer identical to the datasource in the form so you need a more specific item property that matches the datasource.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

With regard to the usersEmail I pasted an older version but should have used the variable instead. The app will work much more efficiently if the variable userEmail replaces User().Email.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp this worked perfectly as well.

Nonetheless, if I actually try to use the global variable useremail then it doesn't work because it says that "This formula has side effects and cannot be evaluated" and it has created an internal error evaluating the expression.
Set( UserEmail; User().Email )

If I use the other version, i.e. no global variable and therefore

UsersEmail = User().Email

it works with no error.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Very odd. I wonder if you Set(xxx;User().Email) in the OnStart and in the formula

AddColumns( [@MonthlyStatement];"UsersEmail";'Created By'.'Primary Email' ); UsersEmail = xxx

whether that would make a difference. Setting a global variable for a single value should reduce the communication between the device and the server every time the formula is used.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@Drrickryp

I did exactly that. I even tried to just create the variable
Set(varUser; User())
and then in the gallery view use
UsersEmail = varUser.Email
but that didn't work either.

For now my app is not very complex, so I assume it's not going to be a big deal but it's still very strange.