Unanswered

Filter source based on user on app load

(0) Share

Report

Posted on by Krcmjaster

I have an app in which I want to present the data that is relevant to the user (data is stored in the SP list).
I did achieved this with

SortByColumns(
Filter('Training',
Email=User().Email,
TextSearchBox1.Text in Title)
,
"Training_x0020_Sort_x0020_Code",SortOrder.Ascending
)

on the Gallery under Data>Items.

However, I am getting delegation warning (my search bar is not working) and I am concerned about the performance of the app when I will have more users.

Is there a way to filter the data on load based on the user?

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

OnnStart oythe App create a variable;

Set(varUser,User())

Then change the formula to;

SortByColumns(
Filter('Training',
Email=varUser.Email,
TextSearchBox1.Text in Title)
,
"Training_x0020_Sort_x0020_Code",SortOrder.Ascending
)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Krcmjaster 76 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 thanks, but that didn't do anything, actually it just broke my app.
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Krcmjaster ,

Following the User() issue from @eka24 , the in filter is also not Delegable - the best you could do on larger data sets is

SortByColumns( Filter( 'Training', Email=varUser.Email, StartsWith( Title, TextSearchBox1.Text ) ), "Training_x0020_Sort_x0020_Code" )