filter by created (SP source) date gives delegation warning

(0) Share

Report

Posted on by Winterorse2014

Perhaps a simple one, I am using the below expression to filter and sort a gallery. There was no delegation warning until I added the && Created>=Today()-7.

Is there a way to do this fully delegeable? Thanks

SortByColumns(
 Filter(
 'Forms Database',
 'Development Site String' = galMysettings.Selected.Item
 &&
 Created>=Today()-7
 ),
 "Created",
 Descending
)

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Winterorse2014 15 on at

Like
a
(0)

Report
Copy link

Link copied!

It was the -7 that some reason made this expression not delegeable. I replaced the today()-7 with a variable that was set to today()-7 and now it works.

Was this reply helpful? Yes No