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.
Solved! Go to 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 :
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
Proud to be a Flownaut!
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
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
Proud to be a Flownaut!
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 :
Proud to be a Flownaut!
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
Proud to be a Flownaut!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
26 | |
25 | |
23 | |
23 | |
21 |
User | Count |
---|---|
62 | |
44 | |
41 | |
29 | |
27 |