Next delegation problem...

(0) Share

Report

Posted on by BiTry

313

Hi,

I do not understand..

Power Apps delegable functions and operations for SharePoint

The following Power Apps operations, for a given data type, may be delegated to SharePoint for processing (rather than processing locally within Power Apps).

Operation/Function Number Text Boolean DateTime Complex [2]

Filter

Yes

My simple filtering.. ->Filter(portal,MA_OK_CALC="OK") /'MA_OK_CALC sharepoint short text column/, why delegation problem ? /source data 10 000 record/. What should be written differently? :(((

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Are you saying that MA_OK_CALC is a single line of text column in the portal data source (SharePoint) and that you are getting a delegation warning? If so, then that should not be happening. Or are you having a different problem? Even with delegable functions you still can't return more than the data row limit of rows. So for example if there are 3,000 records in that 10,000 record data source where the column equals "OK" you still can't retrieve more than 2,000 of them. With a non-delegable function it would return the records that match "OK" out of the first 2,000 records. With delegation it will return the first 2,000 records out of the 10,000. But it will never return more than the data row limit.

Could you explain a bit more about the problem you hare having.

Was this reply helpful? Yes No
BiTry 313 on at

Like (0)

Report

Thx,

Claculated column, based on https://docs.microsoft.com/en-us/connectors/sharepointonline/ the calculated column should count as a text column and text columns are able to delegate.
The calculation, I search for a date /now()/in the text , if it finds it then "OK", and all matches must be from the full database. /example, in which '2022.08.01-2022.07.06-2022.09.12' if today /NOW()/ 2022.08.01 result "OK" /

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@BiTry

Powerapps doesn't handle SharePoint calculated columns well. Do the calculation in PowerApps and save the result to a slot or number type column in SharePoint.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

I assume you are using Now() in the formula for the calculated column. The problem is that calculated columns only update when an item is edited and saved. So yes you should be able to filter on "OK" but it won't be accurate because the column was calculated when it was last saved, not today. If you actually want to filter on todays date you need to do it using a date field. The calculated column won't work.

Was this reply helpful? Yes No
BiTry 313 on at

Like (0)

Report

Current daily data is filtered from a subscription list, unfortunately calculated fields, not delegable, the solution is to have a run after midnight Flow, which converts to a value.
The idea came from you:) Thx !

Was this reply helpful? Yes No