Answered

SharePoint Calculated Column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have an SP list with columns for Title (Single Line Text column), DteofAwrd, CurrentDte (both date columns), and ComplianceStatus (calculated column).

I am using the below to determine compliance status. If DteofAwrd column is blank return "Noncompliant". This is working.

If Title is DteofAwrd

Calculated Column Formula:

=IF(ISBLANK(DteofAwrd),"Noncompliant",IF(Title="Medical"&(DteofAwrd)+1095<(CurrentDate),"Compliant","Noncompliant"))

The above still returns are blank DteofAwrd as 'Noncompliant' as desired, however it calls all other Medical WITH A DATE regardless of date as 'Noncompliant', even though some award dates are as current as last month.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 154,908 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,
SharePoint Calculated columns are non-Delegable in Power Apps. Have you tried doing the same query in Power Apps instead?

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I have not. How would I achieve such a feet through Power Apps? And, would that process circumvent the delegation issues?

Was this reply helpful? Yes No
WarrenBelz 154,908 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Anonymous ,
As long as the fields you are referring to are Text or Numeric, then delegation will not be an issue.
A Variable in Power Apps would be something like
Set( vCompliant, If( DteofAwrd=Blank(), "Noncompliant", If( Title = "Medical" && DateAdd( DteofAwrd, 1095, Days ) >Today(), "Compliant", "Noncompliant" ) )

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.

Was this reply helpful? Yes No