Hello to all,
I'm working on a vacation-flow, where you can submit you prefered vacationtime in a Microsoft Forms and it automatically start an approval to the supervisor. In the Forms you enter the vacation start and the end date and the flow calculate the days between. Here is a picture how my Flow is working actually:
I want to update the column in the following Excel-File after successful approval with the confirmed days in the "Taken Days"-Row. The Flow recognize the worker who request the vacation and find his row in the Excel-File.Then it updates the column "Taken Days" with the above calculated days. (That works already!)
But if the worker get two times holidays approved (for example first time 6 days and second time 10 days) the second holidays overwrite the first 6 days. In the end the Excel-Column contains just 10 days and not 16.
Is there any possibilty to add up the same column after each request?
Solved! Go to Solution.
Hi @breater ,
Please see below steps.
Here I am triggering the flow manually and intialised couple of variables. In your case these steps might be different.
Next step we need to filter by name (assuming name is unique otherwise you need to use a unique id or something to filter) to find the existing taken days. See below.
Next we need to update the row and add the approved days with existing taken days.
Below is the expression I am using to add the current row value with new value.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @breater
Did you tried using Get Rows and find the match? Once you find the match store the value in a variable. Then when you do the update you can do the add expression to calculate the days.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @abm
I'm not sure which match you mean? And how does an add expression looks like. I'm trying this for days but nothing works. Maybe you have an example for me 🙂
Thanks!
Hi @breater ,
Please see below steps.
Here I am triggering the flow manually and intialised couple of variables. In your case these steps might be different.
Next step we need to filter by name (assuming name is unique otherwise you need to use a unique id or something to filter) to find the existing taken days. See below.
Next we need to update the row and add the approved days with existing taken days.
Below is the expression I am using to add the current row value with new value.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogLearn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.
User | Count |
---|---|
26 | |
25 | |
22 | |
22 | |
12 |
User | Count |
---|---|
45 | |
33 | |
31 | |
31 | |
30 |