Unanswered

Vacation Days Left Calculation using Flow

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have build a flow for a Sharepoint Vacation Tracking site. Every this is working fine, but the Compose function using Sub does not work, I keep getting error. I have read several blogs and post on this forum but could not find an answer. Please see the Flow screenshot belwo. I am using the follwing expression for compose 3.

sub(item()?['Vacation Days Left'],float(outputs('Compose2')))

I am also having issue with the time zone as when i create a calander entry its putting it a day ahead of the event. Like if the event date was requested for 1/28 it creates it on 1/27.

I have the same question (0)

All responses (3)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Vacation Days Left Calculation using Flow

I was able to solve the issue with the date calculation. But now i run into a different issue, When i convert the numberofdays value into an integer i am getting a value of 512 doesn't matter what is the value in the column.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Re: Vacation Days Left Calculation using Flow

Hi @Anonymous,

First you could check if the value of this field is displayed in SharePoint list and is consistent with the output in Flow.

Without using any function, just output the value of this field and check if the value is 512, regardless of the function used.

Perhaps it is because the formula of Calculation has an error, which leads to the occurrence of erroneous calculation results.

Please try checking and correcting them and see if the issue still exists.

Best Regards,

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

Like (0)

Report

Re: Vacation Days Left Calculation using Flow

The values displayed in sharepoint table is right. Attached is the formula for the sharepoint column and the table
value. By no means i am an expert sharepont and flow user, so if there is a better formula to calulate number of vacation days taken, please let me know.

Was this reply helpful? Yes No