User cannot view latest entries in gallery

(0) Share

Report

Posted on by TBHutch

Hi,

We are experiencing an issue with a user not being able to see their latest entries in the gallery. Some details below:

1. I have been able to confirm that entries they have submitted via the form have been added to the SharePoint Online list.

2. Other users are not experiencing the same issue and are able to see their latest entries immediately.

3. The filter on the gallery is below

FirstN(
 With(
 {wList: Filter('RAC Activities', 
 'Created By'.Email = User().Email &&
 (ddService.Selected.Result = "All" || 'RAC Service'.Value = ddService.Selected.Result
 && ddActivity_1.Selected.Result = "All" || Activity.Value = ddActivity_1.Selected.Result))
 },
SortByColumns(wList,"Created",SortOrder.Descending)), 100)

4. The clear collects onvisible on the gallery page are below

ClearCollect(RecentItems, FirstN(Sort(Filter('RAC Activities', Created <= Now() && 'Created By'.Email = User().Email), Created, SortOrder.Descending), 100));

ClearCollect(colRAC, {Result:"All"}); Collect(colRAC, Sort(ForAll(Distinct('RAC Activities','RAC Service'.Value), {Result: ThisRecord.Value}),Result));

ClearCollect(colActivity, {Result:"All"}); Collect(colActivity, Sort(ForAll(Distinct('RAC Activities',Activity.Value), {Result: ThisRecord.Value}),Result));

5. Note, that colRAC is only returning 9 rows where it should return much more.

Any advise would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

_minnies_ 91 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Tbhutch ,

because you are saying that the problem occures only for one user I would first analyse if there is any difference with the user object. We had an issue for example with uppercase letters in the user name.

Best regards
Jeanine

Was this reply helpful? Yes No
Sickle-Cell 600 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Are these latest entries entered into the app? Or do they come from an external source?

Was this reply helpful? Yes No
TBHutch 19 on at

Like
a
(0)

Report
Copy link

Link copied!

The latest entries are added via the app. The entries are submitted correctly as they are visible in the SharePoint Online list, but just not available in the gallery for one user.

Was this reply helpful? Yes No
Sickle-Cell 600 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

As Minnies has said, the issue could be with the user - does their user name have any unique characters?

Alternatively, are all of these users in different areas? If one user has less signal, that could explain the delay. If they return to the app later, can they view the full list or does it still only return a partial amount?

Was this reply helpful? Yes No
TBHutch 19 on at

Like
a
(0)

Report
Copy link

Link copied!

I was wondering the same thing @_minnies_ . There are no differences in the email the user is using.

@Sickle-Cell yes the users are from different areas. However, I tested logging in as the user with full connection and experienced the same issue. The app only ever returns partial results since 03/2023 and nothing beyond that.

Was this reply helpful? Yes No
TBHutch 19 on at

Like
a
(0)

Report
Copy link

Link copied!
We have discovered the issue is due to the user having over 2000 entries. It seems the powerapp gallery cannot handle this volume. I have since updated the filter on the gallery to include date but still does not return the latest entries.

FirstN( With( { wList: Filter( 'RAC Activities', DateDiff(Today(), "Created", TimeUnit.Days) < 90 && 'Created By'.Email = User().Email && (ddService.Selected.Result = "All" || 'RAC Service'.Value = ddService.Selected.Result && ddActivity_1.Selected.Result = "All" || Activity.Value = ddActivity_1.Selected.Result) ) }, SortByColumns(wList, "Created", SortOrder.Descending) ), 100 )
Can you suggest any improvements on this?

Was this reply helpful? Yes No
Sickle-Cell 600 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

If it's a delegation issue, I'm not going to be too much help as I'm only learning the ins and outs of this myself. From what I've read, creating a static text column in your datasource can help you filter using delegatable queries which should solve your issue.

There seems to be some good advice in this post here :- https://powerusers.microsoft.com/t5/Building-Power-Apps/Delegation-Issues-with-Filter-Function/m-p/151984#M51615

Hope this helps!

Was this reply helpful? Yes No
_minnies_ 91 on at

Like
a
(0)

Report
Copy link

Link copied!

The problem is that not all items of the sharepoint list will be searched. If you say the user has more than 2,000 items the search does only consider 2,000 items of the list and search within them.

I worked on a similiar project before where the sharepoint libary contained more than 10,000 items. We solved the problem by using the sharepoint search with power automate and give back the result to the power app. So we could search within all the 10,000 documents. The approach was also used in the user request: Solved: Returning sharepoint search results to powerapps f... - Power Platform Community (microsoft.com) Maybe this could help.

Was this reply helpful? Yes No
Verified answer

TBHutch 19 on at

Like
a
(0)

Report
Copy link

Link copied!
The gallery items was updated to the below which seems to have resolved the issue.

FirstN( Sort( Filter( 'RAC Activities', 'Created By'.Email = User().Email && (ddService.Selected.Result = "All" || 'RAC Service'.Value = ddService.Selected.Result) && (ddActivity_1.Selected.Result = "All" || Activity.Value = ddActivity_1.Selected.Result) ), ID, SortOrder.Descending ), 100 )

Was this reply helpful? Yes No