Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

SharePoint Calculated Field not Functioning Correctly in Condition

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.

Community Support Team
Community Support Team

Re: SharePoint Calculated Field not Functioning Correctly in Condition

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:3.JPG

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,


Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: SharePoint Calculated Field not Functioning Correctly in Condition


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. 

Level: Powered On

Re: SharePoint Calculated Field not Functioning Correctly in Condition

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,724)