web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Delegate filter of cal...

Power Apps

Answered

Delegate filter of calculated field to SharePoint List

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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 Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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

Join the conversation