web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Missing records in use...
Power Pages
Answered

Missing records in user gallery for specific status value

(0) ShareShare
ReportReport
Posted on by 64
Hi all,
 
I have an issue where some users experience missing records in gallery screen specifically for "Pending" status. 
FYI, I have 3 status where the default is "Pending". The rest are "Checked" and "Rejected". 
Refer below screenshot for more details:
 
Example : USER 1
The code:
 
Gallery Screen: (this gallery is filtered based on OE/ME email and the default should display all status records, but here we can only see records with "Checked" status. The submission is succeed and I can see it in my sharepoint list, but it is not appear in the screen)
 
 
Example : USER 2
The code:
 
 
Gallery Screen: (this gallery is filtered based on OE/ME email and the default should display all status records. This filter works fine with this user, and she can view all records with different status.) *specifically Pending status
 
 
 
I'm stuck with this issue right now. I'm not sure what cause the problem since the app works well previously. I've tried to submit a new request under my name, then I experienced the same issue where my gallery is blank. It should appear in my screen since it is a new request and the status is still Pending.
 
I would appreciate if any one could help me and give some advice to fix it since this request is quite urgent.
 
Thanks in advance. 
Categories:
I have the same question (0)
  • Verified answer
    ran_dale Profile Picture
    71 on at
    Hi @Nbz78
     
    Could be a delegation (limit) problem.
    The operator "in" is not fully delegable in SharePoint.
     
  • Suggested answer
    Nbz78 Profile Picture
    64 on at
    Thank you @ran_dale for your assistance! Yes, I am now able to see the missing records in my gallery screen and the issue is now resolved. For those who encounter the same issue, i would suggest to use "=" instead of "in" since it will cause you trouble in the future when it involves large data. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 74 Super User 2025 Season 2

#2
Jerry-IN Profile Picture

Jerry-IN 55

#3
sannavajjala87 Profile Picture

sannavajjala87 31

Last 30 days Overall leaderboard