Comments on: Power Automate Leave Request Approval Example

By: Ladhhh

Ladhhh — Wed, 27 Mar 2024 08:16:59 +0000

Hi if there are a lot of employees means how… I mean like I’m developing this factory or hotel site means for internal use there are a lot of users will be here so in that case… For the total leave list in sharepoint i could not include all the employees name so how is there any suggestion like if the user first time using this create a new row with the user name and set default remaining leave balances… If already have name means no need to create a list just continue deduct the total remaining leave only after approved by 2 users.. Is it possible to do something like this

By: Jess

Jess — Sun, 17 Dec 2023 18:43:03 +0000

I am getting the below error at do until
Unable to process template language expressions for action ‘Condition’ at line ‘0’ and column ‘0’: ‘In function ‘dayOfWeek’, the value provided for date time string ” was not valid. The datetime string must match ISO 8601 format.’.
input as below
“StartDate”: “2023-12-21”,
“EndDate”: “2023-12-22”,
“HalfDayLeave”: true,
“NumberofDays”: 1,
“Modified”: “2023-12-16T19:14:13Z”,
“Created”: “2023-12-16T19:14:13Z”,

By: Mukesh Chandra Pandey

Mukesh Chandra Pandey — Fri, 13 Oct 2023 06:33:16 +0000

Hi, This is really good. Can you help with the flow which can additionally help with the different types of leaves. Leave approval will depend on the leave balance against different types of leaves for an employee. Sick Leave, Casual Leave and Earned Leave.

By: Mitul Pansuriya

Mitul Pansuriya — Wed, 30 Aug 2023 06:33:27 +0000

Hi Bijay
Thanks for the article.
Please can you share the article link for how to design and integrate above in PowerApps?

By: Nathalie Saint-Marc

Nathalie Saint-Marc — Fri, 18 Aug 2023 14:21:40 +0000

Hi, Thank you for this, it’s very useful. When running the test, I am having issues with the filter query at the beginning. It’s coming back as being invalid. Not sure what I am doing wrong. Can you please help?

Column name is called Employee Name (names in the column are showing as Last name, First Name)
The Filter Query I typed:
Employee Name/EMail eq ‘varLoggedinUserEmail’

Error message:
The expression “Employee Name/EMail eq ‘there is an email address here'” is not valid. Creating query failed.
clientRequestId: fa3d8621-524a-4170-a2ed-c0d774bd2d6b
serviceRequestId: fa3d8621-524a-4170-a2ed-c0d774bd2d6b

By: drew

drew — Wed, 21 Jun 2023 09:55:01 +0000

Hi, we currently have an existing leave flow. do you know how to create a flow that will calculate the monthly leave entitlement per year? eg. employee have 15 days leave annually, then calculate that 15 days to monthly and add it to the list.

By: Teej

Teej — Mon, 12 Jun 2023 19:18:08 +0000

In reply to andri.

Hello Andri,

I was running into the same issue as well and found this resource below very very helpful to avoid the dreaded “apply to each” container that gets put around the Total Leaves data compose connector.

source: https://pnp.github.io/blog/post/avoid-unnecessary-looping-apply-to-each-in-power-automate/

Create an expression: first(body(‘Get_items_Total_Leaves’)[‘value’])[‘TotalLeaves’]

This will allow you to compose the data without the apply to each. This expression can be used for just about all arrays that forcibly get added to the “apply to each” container

Hope this helps! I know I was struggling with this for many days and needed desperate help.

By: andri

andri — Mon, 17 Apr 2023 06:29:35 +0000

Hi there, do u know why when i try to get the data from total leaves it keeps on prompting apply to each instead of just compose?

Kind regards,

By: Manas

Manas — Thu, 16 Mar 2023 14:33:16 +0000

Flow is running but nothing is changing in the leave list. after get items in apply to each , I think the flow is running but not getting any output from that

By: Venkatesh C

Venkatesh C — Fri, 18 Nov 2022 08:32:37 +0000

Hello I also want to create a flow where The leaves are automatically updated.
what I have a done is created a leave request form(Microsoft forms) and once the form is submitted it goes for approval with the manager and the approve or rejestion status is sent to employee via email.also I have created a list which conatins 3 columns employee name ,alloted leaves and balance leave.

Now what I want is if the manager approves the leave the balance leave columns should get updated .Also I have added a question in column where employee specify the exact count of leave apart from start and end date of leave