Answered

Calculated Yes/No column as condition not working

(0) Share

Report

Posted on by LGREIF

I have a column that calculates if a review due date is within 90 days and the output is Yes/No. The column shows a checkmark and the filter works for 'Yes' when the parameters are met.

Yes_No SPOL.JPG

My flow is set up to get the file properties and then based on the Yes/No calculated column copy the file to a working library.

When I run the flow, the condition has a result of false, even though there is a test record that should be copied in the library.

I saw in other posts that the answer was to put '1' in the advanced mode of Condition, but advanced mode is no longer an option. I have tried True, 'True', "True", 1, '1', "1" and both True and 1 as expressions. Am I missing something?

Thank you!

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

ScottShearer 25,254 Most Valuable Professional on at

Like (0)

Report

Re: Calculated Yes/No column as condition not working

@LGREIF

First, calculated columns only get updated when the item is updated. So, it is likely that the column does not have accurate data.

One quick way to resolve the issue is to use an expression rather than referencing the calculated column. So, replace the column reference with something like this in the expression window:

equals(90daysBeforeReviewDate, formatDateTime(utcNow(),'yyyy-MM-dd'))

Enter true in the expression window on the right side of your condition.

Select 90DyasBeforeReviewDate from Dynamic properties.

Let me know if you need more help.

Was this reply helpful? Yes No
LGREIF 8 on at

Like (0)

Report

Re: Calculated Yes/No column as condition not working

@ScottShearer
I had originally started with trying to format the 90daysbeforereviewdate column in an expression without luck before adding the yes/no calculated column as a potential solution. I tried the expression above, but it wouldn't let me reference the 90days... from the dynamic content.

Thank you!

Was this reply helpful? Yes No
LGREIF 8 on at

Like (0)

Report

Re: Calculated Yes/No column as condition not working

@ScottShearer
I figured out the issue. It was a pagination limitation from my organization. For whatever reason, it was only running through 100 records instead of 5000. I fixed the pagination and then was able to successfully apply your recommendations to make this work.

Thank you!

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,254 Most Valuable Professional on at

Like (0)

Report

Re: Calculated Yes/No column as condition not working

@LGREIF

Sorry that I did not mention that... By default the SharePoint Get items and Get Files actions return only 100 items. As you found out, you can turn on pagination in the action settings and set the threshold up to 5000 (higher f you have a premium license).

Was this reply helpful? Yes No