Compare two datetime columns in a SharePoint List gives Delegation Warning

(0) Share

Report

Posted on by Naviya89

Hi all,

I have got a SharePoint list which contains a column called "ExpectedReturnTime" and another column "ReturnTime"

I wanted to check in PowerApps, who are the late people in a gallery using Filter function.

When I use ExpectedReturnTime<ReturnTime it gives me an runtime error. (Requested operation is invalid)

Then I used: DateTimeValue(ExpectedReturnTime)< DateTimeValue(ReturnTime) in the filter function

Now I'm getting Delegation warning.

So I created a calculated column called "LateRetruns" in share point list

=IF(ExpectedReturnTime<ReturnTime,"Late","Not Late")

Then tried to filter in PowerApps using LateReturns="Late"

Now I'm getting correct data, but still that Delegation Warning exists.

At the moment I have only 20 records.. But It will be more than 1000 records when its up and running.

Will this be an issue? or is there anyway we can fix this..

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @Naviya89 ,

Firstly, DateTimeValue is not Delegable, nether are Calculated columns (which have many other issues and should not be used in Power Apps). If however ExpectedReturnTime and ReturnTime are Date/Time columns in SharePoint then you do not need DateTImeValue and can compare them directly the same as your Calculated column

If( ExpectedReturnTime < ReturnTime, TrueResultHere, FalseResultHere )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Naviya89 54 on at

Like (0)

Report

I want to use it for a gallery filter . It gives me an error.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
@Naviya89 ,

Assuming the following

Your SharePoint list is called StaffMovingChecker

It has two Date/Time fields called ExpectedReturnTime and ReturnTime

The code below is being used as the Items of a gallery

Filter( StaffMovingChecker, ExpectedReturnTime < ReturnTime )

then the code is valid and will return any records where the ReturnTime is greater than the ExpectedReturnTime and will be Delegable.

What in the above assumptions is not true?

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Naviya89 54 on at

Like (0)

Report
Your SharePoint list is called StaffMovingChecker Correct
It has two Date/Time fields called ExpectedReturnTime and ReturnTime Correct
The code below is being used as the Items of a gallery Correct

Was this reply helpful? Yes No
Naviya89 54 on at

Like (0)

Report

It works when I add DateTimeValue()... But comes with a warning

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report

@Naviya89 ,

I am now getting the same thing here - this has got to be a bug as the query should work.

DateTimeValue() however is not Delegable and the warning is to be expected. Unless the bug is fixed, there is no Delegable solution to this.

Was this reply helpful? Yes No
Naviya89 54 on at

Like (0)

Report

@WarrenBelz Thanks for your time and effort. Highly appreciated .

Was this reply helpful? Yes No