Hello community,
I am new to the power automate and i need to find the difference between two dates and update it in the desired column. Here every thing is working smoothly but i am not able to derive the expression for subtracting two dates can some one can help me out .
Thanks in advance
Solved! Go to Solution.
And just make the flow run every day to check the list.
Do you want something done lets say 14 days from a specific date?
If so what i usually do is make a IF statement, left column is the date i want to check, then i use "Less or equal to" and the right column
Hello @StretchFredrik ,
Thanks for the spontaneous reply what i want is i wanna automate flow like if the start date of event is 11/2/22 i need my flow to trigger before some days as reminder to responder .i hope i am able to explain.
Thanks in advance
Well then you can do what i wrote above,
Make a IF statement, in that if statement put ur event date in the left column, then chose "Less or equal to" and right column
And just make the flow run every day to check the list.
Thanks @StretchFredrik ,
One more question is i have created the Microsoft form for leave request and every thing works perfectly but i am not able to add the cancel option in forms and also in my flow any solution for it.
In simple terms i need to add cancel function for an employee to cancel his/her vacation.
Thanks in advance
I would probably send a button or link in Teams to the user as part of the first flow and have another flow to cancel the vacation request.
Hello @StretchFredrik can you please elaborate the solution little bit like what type of link or button it will help me to understand and implement.
Thanks in Advance
Since i dont know what the whole solution looks like its pretty hard to know what works best here, but the most basic is probably to have the Original flow send a email (as confirmation), and if they wish to cancel it, they can respond to that email. Then you can have another flow Triggering on when a email arrives with that header, get the user that sent it, and edit the place where you store the vacation.
Hopefully you understand what my idea is.
Hello @StretchFredrik ,
Thanks for the early reply your solution is good but is there a way to provide a cancel button or any other function because writing mail is not what my boss want and its not convenient way it will be very helpful.
Thanks In Advance
User | Count |
---|---|
6 | |
6 | |
5 | |
3 | |
2 |