Filtering list by currrent user not working

[Borja]

Hi,

I want to filter a linked sharepoint list to only show items created by current user. I read other posts about this but none of these solutions works for me.

I have this filter on my gallery:

SortByColumns(Filter('Time Report'; User().Email = Author.Email); "Title"; If(SortDescending1; Descending; Ascending));

But the list does not show items. Author is a person type? How can i refer to the list item creator?

Thanks.

[Meneghino]

Thanks. Do I put the code on the OnSelect for a button and then just add Navigation to the BrowseScreen?

Yes

Also, not sure what is needed in my case based on your example for: '[Access].[Instruments]' 

Try this first:

ClearCollect(CachedKMlog, 'KM Log'); Navigate(BrowseScreen, None, {CachedUserEmail: User().Email})

This will only collect the first 500 items, but you mentioned this may be enough.  If not, then use my nested code.

Also, if you call User().Email in a filter, it calls the function for every row of the data source, so PowerApps performance slows to a crawl.  We save the user identity in a context variable since it is a constant, then performance should be lightning fast when filtering a cached list.  We use this variable below.

What I need my BrowseScreen items to do is: SortByColumns(Filter('KM Log',Employee.Email=User().Email),"Date",If(SortDescending1,Descending,Ascending))

Now use this instead:

SortByColumns(Filter(CachedKMlog,Employee.Email=CachedUserEmail),"Date",If(SortDescending1,Descending,Ascending))

Apologize for my lack of knowledge on this. I have a multiple lists that would be useful PowerApps and to be able to filter by user (when list is large) is holding us back.

If your list is large, I also suspect things were not working because you were using the User() function directly in a filter of a data source.  You can experiment just caching the user identity and not the data source and vice-versa.

Please let me know of the results as I am curious.

[pattysicks]

Not getting any more errors or warnings, but I guess I was wrong where I do need to filter more than 500 items. I believe it's just looking at the first 500 (as you mentioned), and since my email is not associated with those first 500 items, it displays no items.

I attempted to use your nested code, but the change you provided me with your updated post, I got lost. My list is over 4000 items. How would I implement your nested code in my case?

I am so close to a working solution, thanks for your help so far.

I also adjusted to use a Context Variable instead, thanks for the tip.

[Meneghino]

Are you using SharePoint as a datasource?

It is not yet delegable, I believe, so any filtering, caching etc. will only ever see the first 500 rows.

If so, any chance you can migrate to CDS? 

Otherwise you need to wait for delegation to be extended to SharePoint lists

[Meneghino]

Apologies, I re-read the list and SharePoint is now delegated!

Come back in 5-10 minutes and I will post the code.

[Meneghino · Accepted solution]

Please use this for the navigation button, but please check that I am closing the correct number of parentheses in the penultimate line.

This will cache up to 6000 rows so you have space to grow your list.

Please let me know how you get on.  Interested to see how long the navigation now takes.  It should be quicker in a browser than in run mode in Studio, by the way.

ClearCollect(CachedKMlog, Sort('KM Log', ID, Ascending));
UpdateContext({MaxID: Max(CachedKMlog, ID)});
If(CountRows(CachedKMlog)=500,
	Collect(CachedKMlog, Filter(Sort('KM Log', ID, Ascending), ID > MaxID))
;
UpdateContext({MaxID: Max(CachedKMlog, ID)});
If(CountRows(CachedKMlog)=1000,
	Collect(CachedKMlog, Filter(Sort('KM Log', ID, Ascending), ID > MaxID))
;
UpdateContext({MaxID: Max(CachedKMlog, ID)});
If(CountRows(CachedKMlog)=1500,
	Collect(CachedKMlog, Filter(Sort('KM Log', ID, Ascending), ID > MaxID))
;
UpdateContext({MaxID: Max(CachedKMlog, ID)});
If(CountRows(CachedKMlog)=2000,
	Collect(CachedKMlog, Filter(Sort('KM Log', ID, Ascending), ID > MaxID))
;
UpdateContext({MaxID: Max(CachedKMlog, ID)});
If(CountRows(CachedKMlog)=2500,
	Collect(CachedKMlog, Filter(Sort('KM Log', ID, Ascending), ID > MaxID))
;
UpdateContext({MaxID: Max(CachedKMlog, ID)});
If(CountRows(CachedKMlog)=3000,
	Collect(CachedKMlog, Filter(Sort('KM Log', ID, Ascending), ID > MaxID))
;
UpdateContext({MaxID: Max(CachedKMlog, ID)});
If(CountRows(CachedKMlog)=3500,
	Collect(CachedKMlog, Filter(Sort('KM Log', ID, Ascending), ID > MaxID))
;
UpdateContext({MaxID: Max(CachedKMlog, ID)});
If(CountRows(CachedKMlog)=4000,
	Collect(CachedKMlog, Filter(Sort('KM Log', ID, Ascending), ID > MaxID))
;
UpdateContext({MaxID: Max(CachedKMlog, ID)});
If(CountRows(CachedKMlog)=4500,
	Collect(CachedKMlog, Filter(Sort('KM Log', ID, Ascending), ID > MaxID))
;
UpdateContext({MaxID: Max(CachedKMlog, ID)});
If(CountRows(CachedKMlog)=5000,
	Collect(CachedKMlog, Filter(Sort('KM Log', ID, Ascending), ID > MaxID))
;
UpdateContext({MaxID: Max(CachedKMlog, ID)});
If(CountRows(CachedKMlog)=5500,
	Collect(CachedKMlog, Filter(Sort('KM Log', ID, Ascending), ID > MaxID))
))))))))));
 Navigate(BrowseScreen, None, {CachedUserEmail: User().Email})

[pattysicks]

Thank you! Works like a charm. The navigation only takes about 3-5 seconds, so pretty speedy.

Thanks for all your help and dedication to get me working.

[Lexnnn]

This did help me to filter on User = email from people field: (I was using people field and it did not work well with powerapps)
https://wonderlaura.com/2018/10/26/powerapps-filter-by-me/

Solution in short: use variable "on start" + "OnVisisble" refresh of the list and use same variable in filter +  single line of text field instead of poeple field.

SortByColumns(Filter('Sandwich shop',(Salesrepemail = CurrentUser.Email) And ((StartsWith(Account_x0020_name, TextSearchBox1.Text)) Or (StartsWith(Street, TextSearchBox1.Text)) Or (StartsWith(City, TextSearchBox1.Text))Or (StartsWith(Postal_x0020_Code, TextSearchBox1.Text)))), "Account_x0020_name", If(SortDescending1, Descending, Ascending))

To let the users still be able to use the people field, I use flow to auto populate the new single line of text field with a copy of email adress from people field.