Delegation Question

(0) Share

Report

Posted on by DerrickH

196

Hey everyone,

I'm running into some delegation errors and I was curious if there might be a fix to my formula that I'm not aware of. Could someone take a look and see if there's a different formula I could add to get away from the delegation issue?

!IsBlank(LookUp('Brad''s Maintenance Calendar',DateValue(SDate)= DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days)).'Equipment Name')

The delegation warning refers to the DateValue(SDate) section. For reference, SDate is referring to a calculated column in SharePoint that is producing just the "Date" from a Date/Time column separately. Equipment name is a simple Text column.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 155,983 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @DerrickH ,

First what is your Data Source, how many records are likely to be in it and what type of field is SDate ? You are correct that DateValue() is not Delegable and you also have an issue with your DateAdd relational lookup.

Was this reply helpful? Yes No
DerrickH 196 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz ,

Data Source is a SharePoint List and I can't imagine more than 100 records per month being added to the list. The field "SDate" is a calculated date column, which is pulling data from a separate date/time column. I originally tried the first date/time column in place of the "SDate" column in the originally formula, though I couldn't seem to get it to work, because of the time value associated with the date/time column.

Was this reply helpful? Yes No
WarrenBelz 155,983 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@DerrickH ,

That explains the issue somewhat. SharePoint Calculated columns are far from reliable/consistent with Power Apps and really should not be used. They are also not Delegable. You can do the same calculation in Power Apps as you should have the relevant fields available.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
DerrickH 196 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
I'm not very familiar with doing this specific calculation in powerapps, could you explain?

Was this reply helpful? Yes No
WarrenBelz 155,983 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@DerrickH ,

I would need to know the Calculation in SharePoint, however you still may have Delegation issues - it is far better to populate a Date column with the result any time you change any of the dependant values.

Was this reply helpful? Yes No