Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
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. 

  • zmm14 Profile Picture
    72 on at
    Re: Leave request flow with sharepoint balance calculation in email

    Thank you for your reply.

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

     

    Is this what you mean?

    zmm14_1-1632766353595.png

     

  • eric-cheng Profile Picture
    5,171 on at
    Re: Leave request flow with sharepoint balance calculation in email

    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

     

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,635 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow