Comments on: Power Automate Leave Request Approval Example

By: 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

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

By: 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

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

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

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

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

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

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

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

]]>