Announcements
Hi, could anyone tell me if there is an issue with filtering on a calculated column within a gallery. I have a gallery where i would only like to show items that were only created today I know we cant filter on date therefore i have created a calculated column with yes or no based on a date column but this still doesnt seem to work 😞
Any recommendations?
If you want use Date then:Filter(Datasource,IsToday(DateColumn))
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Thanks for your reply however the data set is SharePoint list therefore is will face delegation issue any other ideas?
If you are facing delegation, use a collection OnStart or Onvisible of the screen:ClearCollect(MyTable,Datasource)
Then on the Gallery item, replace Datasource with MyTable
Im not sure what you mean? How do i pull todays data to a collection?
As a way of dealing with the delegation issue, you will use a collection. Are you not farmiliar with collections? Follow the reply i gave and it will resolve the issue.
For more information on collection:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect
Hi @Kmayes ,
Actually, it is an known issue with Calculated type field of SP list in PowerApps -- The "Calculated" field could not be delegated within PowerApps app.
As an alternative solution, you could consider use a Text type column to store the Date value, and then you could filter your SP List records based on the Date Text value. Please check and see if the following thread or video could help in your scenario:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Delegation-on-Sharepoint-List-date-column/m-p/354931
https://powerusers.microsoft.com/t5/Building-Power-Apps/Problems-with-delegation-when-filtering-by-date/m-p/319796
https://youtu.be/eCMuXPI1Qok
In addition, you could also consider bulk-load your SP list records into collection in your app. Then use the collection as data source within your Filter function instead of your Original SP List, then the Delegation issue would disappear. Please check and see if the following threads would help in your scenario:
https://powerusers.microsoft.com/t5/General-Discussion/Pulling-in-large-ish-SQL-tables/m-p/243777#M71518
https://powerusers.microsoft.com/t5/Building-Power-Apps/Loading-60-000-SharePoint-List-Items/m-p/448633/highlight/false#M133427
https://powerusers.microsoft.com/t5/Building-Power-Apps/Sort-gallery-with-multiple-fields/td-p/379730
Note: The Collection is not subject to Delegation issue
Best regards,
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 842
Valantis 563
Haque 402
