Answered

Delegation How to Avoid it?

(0) Share

Report

Posted on by Lewkir

I have a few galleries that pull from SharePoint lists and it's pretty essential that they are filtered on the date field.

The lists are currently quite small but will likely grow much larger, is there an way around this delegation issue?

I thought of using a calculated column to convert each date into a number which are aparently delegatable only to find that calculated columns are not.

Perhaps using flow or similar would allow me to fill a field with a number version of the date?

Very stuck for ideas now as it seems this is the last major hurdle I need to get over.

Cheers,

Categories:

General Questions

All responses (6)

Answers (1)

RandyHayes 76,287 Super User 2024 Season 1 on at

Like (0)

Report

Re: Delegation How to Avoid it?

@Lewkir good old SharePoint designer - its days are numbered, but it still works well in some cases.

I would take the time though to try to figure out how to do the same in Flow as that is the future for a lot of this.

Cheers back!
Lewkir on at

Like (1)

Report

Re: Delegation How to Avoid it?

Cheers for the advice.

In the end I have used a SharePoint Designer workflow to copy BookingsDateCalc into a further column where it is formatted as a number (I tried Flow but couldn't work it out) so it now works.

Cheers.
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on at

Like (1)

Report
Re: Delegation How to Avoid it?

@Lewkir
Typically text columns are a good avenue for avoiding delegation issues on complex types (anything beyond a number usually). However, as you have noticed, a calculated column does not abide by these rules.
You can, in your App or through a Flow, populate an alternative column with a calculated value. So, having another BookingsDate as a text column (like bookingDateCalc), but you would be the one putting in the calculation in either your App or in Flow (when a record is created or modified).

Also though, like @xzDan suggests - if you don't try to convert and you are looking for an exact filter (i.e. = ) then you can do that with a date to date comparison and skip the delegation issue.
Filter('Rooms Booking List', BookingsDateCalc = DateValue(GanttDateFormat))
Hope this helps some.
xzDan 350 on at

Like (1)

Report

Re: Delegation How to Avoid it?

Can you try without converting the Date column to text? Like with mine, I keep the date column unchanged and just convert the filter to text.
Lewkir on at

Like (0)

Report
Re: Delegation How to Avoid it?

Hi Dan,

Yeah I've used:

Filter('Rooms Booking List', Text(BookingsDateCalc) = Text(GanttDateFormat))
which is filtering a SharePoint list on the date column "BookingsDateCalc" by a date picker "GanttDateFormat".

This still gives me the delegation warning unfortunately.
xzDan 350 on at

Like (0)

Report

Re: Delegation How to Avoid it?

You can in fact filter on the date column, althought you have to convert it to text.

Try doing Filter(<Source>,<Date Column> = Text(<Date to Filter>,DateTimeFormat.ShortDate))
Instead of SHortDate you can do Text(,"yyyy-mm-dd") I think which works better.

E.g. for me

Filter(<Source>,Date=Text(Combo_Date.SelectedDate,"yyyy-mm-dd"))