Delegate filter of calculated field to SharePoint List

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have two columns in my SharePoint List (Date Outcome and Length of Registration) which I use to create a calculated field in SharePoint: Date Expiry = Date Outcome + Length of Registration.

Then I am trying to build a gallery which filters out the rows without a Date Expiry this way:

Filter('Data Source', DateExpiry<>Blank())

It works, however, I get delegation warnings. Is there a way to get around the delegation warning?

I have had a look at the SharePoint Connector docs and the way that I see it is that operations using SharePoint calculated columns can be delegated if the Calculated Column is a text field - is that correct?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 153,032 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

Calculated columns are not Delegable. Try adding a new numeric column and making the Default this value and populate it. It will then be Delegable.

Shane Young @Shanescows recently released a video concerning column types you should consider using in SharePoint with Power Apps - it is worth a watch.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No