web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Leave request flow wit...
Power Automate
Unanswered

Leave request flow with sharepoint balance calculation in email

(0) ShareShare
ReportReport
Posted on by 72

Hello to all the community!

 

I'm trying to implement a Leave request that also calculate vacation balances left for each person that request (so both the approver and requestors knows their respective days left) and once approve create an event that will be share in a calendar so everybody knows who is on vacation.

 

I've followed these guides: (and many others)

https://powerusers.microsoft.com/t5/Building-Flows/Leave-request-flow-with-sharepoint/td-p/384027

https://powerusers.microsoft.com/t5/Building-Flows/Flow-Vacation-calculations/m-p/482036#M59020

But cant get it to work.

 

I have created Vacation request in SP as this

Start Date, End Date, Days Requested, Comments, Approve: yes/no, Approval Status

zmm14_1-1632605494981.png

Vacation Balance in SP

Title, Employee, Annual Vacation days - set to 22max, Days Requested and Balance (Annual Vacation Days - Days requested)

zmm14_2-1632605604372.png

I have created a request but I don't see anything happening in the Vacation Balance list, there for I guess here is my initial problem?

zmm14_3-1632606398853.pngzmm14_4-1632606428322.png

 

zmm14_5-1632606714295.png

Any help is highly appreciate it. 

Categories:
I have the same question (0)
  • eric-cheng Profile Picture
    5,171 on at

    Hi @zmm14 ,

     

    Is the flow triggered when a Vacation Request is created?

     

    Can you post a screenshot of the parameters for Get Items where the error is occuring?

     

    --------------------------------------------------------------------------
    If I have answered your question, please mark my post as a solution
    If you have found my response helpful, please give it a thumbs up

    Connect on LinkedIn

     

     

  • zmm14 Profile Picture
    72 on at

    Thank you for your reply.

    Yes, supposed to be when a Vacation Request is created.

     

    Is this what you mean?

    zmm14_1-1632766353595.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 253 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 172 Super User 2026 Season 2

#3
trice602 Profile Picture

trice602 134 Super User 2026 Season 2

Last 30 days Overall leaderboard