Unanswered

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:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

xzDan 350 on at

Like (0)

Report

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"))

Was this reply helpful? Yes No
Lewkir on at

Like (0)

Report
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.

Was this reply helpful? Yes No
xzDan 350 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@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.

Was this reply helpful? Yes No
Lewkir on at

Like (1)

Report

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.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@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!

Was this reply helpful? Yes No