Automated Vacations Flow (Sub) Available Days

[Jovalles]

Hello all,

Thanks for take your time and reading.

I have almost complete my flow but i need automated the real number of availables days. I explain bit better, all my useres have 15 days avalables to take, when they request for example 5 days i need in the flow that chek on the list where available days are 15 and substrack that 15-5 new available days = 10 so i dont know how to do for use sub() between 2 differents SP List. all this on sharepoint online and microsoft flow.

[Jcook]

Hello @Jovalles ,

Try using a 'Data Operations  - Compose' Action for each list to grab the value needed. (in your case this would be 'days')

Than use a Third Compose to do the calculation with an expression to get the value you are looking for.

--Josh

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Jovalles]

Hi,

Ty for your HElp, can you give me a bit more of details i'm not an expert on microsoft flow, i was thinking that was easiest this flow 

[Jcook]

@Jovalles ,

Yes for sure, can you please share a screenshot of your flow, so i have something to work with, and better understand how your workflow is working.

Thanks

--Josh

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Jovalles · Accepted solution]

Sure:

1- List 1  (where the user request the vacation) (user: person type) (totaldays, Calculated field , substrack datein-dateout)

2 - List 2 Same site ( register alwais  exist )

Flow:

 

Formula : 

sub(body('Get_item')?['availabledays'],inttriggerBody()?['totaldays'])

[Jcook]

Awesome, sorry about the late response. I will try to replicate best I can and have a solution for you very soon

Thanks

-Josh

[Jcook]

@Jovalles 

Please take a look at my POC. I have 2 SP lists. One for Remaining Days, the other for Total Days. I am using the compose action like i said in my first reply. Here is dome screenshots.

Please read all the highlighted text.

I hope this helps!

--Josh

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others