Any way to resolve delegation here

(0) Share

Report

Posted on by astrontelstar

287

I have a sharepoint list with delegation warnings. Newbie to PowerApps.

Any way to easily resolve this?

Order Date is a date/time column in my list.

Filter('Mprinted Business Operations', Year('Order Date') >= 2021 And Month('Order Date') = 2)

I have many "date" related calculations I want to build into my app and this delegation thing seems very limiting.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@astrontelstar

You will not be able to delegate that criteria. Only because you are trying to perform a PowerApp function (Month and Year) in the criteria. That by itself say ... PowerApps needs to do the calculation, thus it needs all the records, thus it cannot delegate it.

What I would recommend is, if you need to perform date filtering like that, is to have a Text column in your list that represents the date of the order (in this case) in the following format: yyyymmdd

The format is highly important.

Now, you can delegate criteria such as this:

Filter('Mprinted Business Operations', StartsWith(orderDateText, "202102")

This makes it very easy to get around the delegation issues and gives you more flexibility for using these results as a pre-filter for other levels of date filtering that you might need.

I hope this is helpful for you.

Was this reply helpful? Yes No
astrontelstar 287 on at

Like (0)

Report
Copy link

Link copied!

Love it, thank you. So could I build a calculated column that pulls from the Order Date column (which is a Date/Time) and converts the order date into a yyymmdd format for the text value? If so, any suggestions on the formula? Not looking for everything, just thought I'd ask in case I can't do a calc column to build this date. I don't want to have to have the user manually put in that date.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@astrontelstar

No...calculated columns are not delegable. This has to be a Text Column. If you have existing data and need to add this extra column, then I would look to PowerAutomate to go through and enter the date into the new column from the existing.

It is a bit of a "gotta remember" from your PowerApp that you need to set BOTH the Date Column and the Text Column, but this is pretty easy to work through. And, after a while, you start to realize that the real Date column is not really needed. It becomes more for the user that might be looking at the list in the SharePoint view.

Was this reply helpful? Yes No