cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cbbrown
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.

 

all-day-condition.JPG

 

 

 

 

 

 

 

 

 

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.

3 REPLIES 3
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,

Kris

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.
cbbrown
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.

all-day.JPG

 

 

 

 

 

 

 

 

 

 

Hope this answers your questions better. 

cbbrown
Level: Powered On

Re: SharePoint Calculated Field not Functioning Correctly in Condition

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

fourthImage

Australia Summit

Travel to Melbourne and network with thousands of peers!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 63 members 4,530 guests
Please welcome our newest community members: