SharePoint Calculated Field not Functioning Correctly in Condition

(0) Share

Report

Posted on by cbbrown

I have a Flow setup to move one calendar date to a calendar on a different subsite based on two conditions.

The first determines if it is an All Day Event.

Everytime I run this flow it ends up proving "False" even though, the Calculated Column shows to be All Day. I am thinking that somehow the condition is proving false just based on the value not proving true and not the condition statement as a whole.

The reason I say this is because the second condition looks at the IT area to see if it equals a certain area and then if it does, it proceeds to copy the calendar item. At first when I put "IT Area", it was proving false, but when I found the "IT Area Value" it worked like it was supposed to.

it area value.JPG

Does Flow not work with Calculated Columns? If I can just get that condition reading correctly, my Flow would be completed.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @cbbrown,

Could you please share more details about your SharePoint list?
Could you show a bit more about All Day field and IT Area field? Are they custom fields?
Further, could you please show a bit more about the formula of your Calculated column?

The Calculated column displays information that is based on the results of calculation of the formula box. Besides, the Calculated column doesn’t display in “Create item” box and we could not edit it:
Please check if the result of calculation of the Calculated column equals Yes.

More details about Calculated data type of SharePoint, please check the fololowing document:
List and library column types and options

Best regards,
Kris

Was this reply helpful? Yes No
cbbrown 18 on at

Like (0)

Report
Copy link

Link copied!

The All Day field is a calculated column with the following formula:
=IF(NOT([End Time]=[Start Time]),
IF(MOD(ROUNDUP(([End Time]-[Start Time])*24,0),24)=0,TRUE,FALSE),FALSE)

The IT Area field is a choice column.

When I modify the view to show the "All Day" field, it shows Yes for "All Day Events" and No for single hour/day, just as it should. So I believe that the calculated field is working correctly.

Hope this answers your questions better.

Was this reply helpful? Yes No
cbbrown 18 on at

Like (0)

Report
Copy link

Link copied!

@v-xida-msft

Was this reply helpful? Yes No