Filter calculated SharePoint List column

Like (0) Share

Report

Posted on 30 Mar 2020 11:26:00 by Kmayes

786

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?

Categories:

General Questions

I have the same question (0)

All responses (6)

Answers (0)

eka24 20,921 on 30 Mar 2020 at 13:31:48

Like (0)

Report

Re: Filter calculated SharePoint List column

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.

Was this reply helpful? Yes No
Kmayes 786 on 30 Mar 2020 at 14:47:57

Like (0)

Report

Re: Filter calculated SharePoint List column

Thanks for your reply however the data set is SharePoint list therefore is will face delegation issue any other ideas?

Was this reply helpful? Yes No
eka24 20,921 on 30 Mar 2020 at 15:08:18

Like (0)

Report

Re: Filter calculated SharePoint List column

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

Was this reply helpful? Yes No
Kmayes 786 on 30 Mar 2020 at 17:06:21

Like (0)

Report

Re: Filter calculated SharePoint List column

Im not sure what you mean? How do i pull todays data to a collection?

Was this reply helpful? Yes No
eka24 20,921 on 30 Mar 2020 at 18:40:25

Like (0)

Report

Re: Filter calculated SharePoint List column

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

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.

Was this reply helpful? Yes No
v-xida-msft on 31 Mar 2020 at 07:56:14

Like (0)

Report

Re: Filter calculated SharePoint List column

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,

Was this reply helpful? Yes No