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

Announcements

News and Announcements icon
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. 
image_2024-10-25_153152132.png
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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
sannavajjala87 Profile Picture

sannavajjala87 38 Super User 2026 Season 1

#2
Valantis Profile Picture

Valantis 24

#3
Haque Profile Picture

Haque 16

Last 30 days Overall leaderboard