Announcements
Hello Team,
Could anyone help to filter a Gallery with last 30 entries from the current date?
Hi @Nisha_Innola ,
Assuming you are using SharePoint as a data source. Try this,
SortByColumns(FirstN(Filter(YourSharePointList, // Replace YourSharePointList with the actual name of your SharePoint listDateColumn <= Today()),30),"Created",SortOrder.Descending)
Thanks!!!
Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.
Hello @Prabhakar_S ,
Thank you so much for your reply. It worked and the gallery filtered out 30 entries . But the filtered results are different as i m using collection along with the filters. Does that affect the result?
ClearCollect(collection name, SortByColumns(FirstN(Filter(Sharepoint name,User = Username And Created <= Today()),30),"Created",SortOrder.Descending));
I want the result from current date to 30 entries. But my gallery showed entries in the month of September with two days only. But I have data till current date.
Can you help me out with this please?
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 271
Mohsin Ali 239
