How to caculator and check balance for Leave request

[CongDuong]

Dear experts!

I have two List  like that :

List 1: Leave Request

List 2 : Balance Leave

I also has been created a flow like as below:

With this flow and 2 list, i need check balance of leave just only type : Annual leave (12 days) and the rest is no needed.

I try search and follow setup by all tags about balance of leave or caculator of leave in forum , but i can not solves my case.

In my case, please help me, Big thank!!!!!!

[CongDuong]

I try to add config for flow :

But flow is not run like image :

[v-zhoqian-msft]

Hi @CongDuong ,

Do you want to check balance of leave just only type: Annual leave and calculate the new balance?

Based on your description, I have made a simple test for your reference.

SharePoint lists for test:

Test:

Result:

Best Regards,

Community Support Team _ habsburg Qian

If this post helps, then please consider Accept it as the solution to help the other members find it.

[CongDuong]

Hi @v-zhoqian-msft ,

i will apply your solution rn, Thanks for your help.

[CongDuong]

Hi,

i try config like you advise as below:

But not working, error like as below:

[CongDuong]

Hi @v-zhoqian-msft 

Like image attack, i already have one condition about : outcome  does not contain Reject

cause of this addition make your solution not working?

Thanks!

[v-zhoqian-msft]

Hi @CongDuong ,

The error is related to the Balance of leave field. I found that the field Balance of leave may not be number type? If you use the choice type, it will make the formula more complicated. I suggest you use the number type like this, it will simplify the calculation.

Best Regards,

Community Support Team _ habsburg Qian

If this post helps, then please consider Accept it as the solution to help the other members find it.

[CongDuong]

Dear @v-zhoqian-msft ,

type of balance of leave i already choice Number and set default : 12.

Thanks!

[v-zhoqian-msft]

Hi @CongDuong ,

I didn't notice that the output of the filter array action is empty just now. 

In this case, you could check whether the value of EmployeeName in list2 is the same as the DisplayName of requestor. If not, we should change the settings in the filter array action.

Best regards,

Community Support Team _ habsburg Qian

If this post helps, then please consider Accept it as the solution to help the other members find it.

[v-zhoqian-msft]

Hi @CongDuong ,

What type of field is EmployeeName in your second list? In theory, we should not use name to filter, but should have something like EmployeeID to filter.

Best regards,

Community Support Team _ habsburg Qian

If this post helps, then please consider Accept it as the solution to help the other members find it.

[CongDuong]

Dear @v-zhoqian-msft ,

In lits 1:

Requestor : i using person

In list 2, i create as below:

- EmployeeName : type Person

- Type of leave: type Choice

- Balance of leave : type Number

I have trying check both type text and person for EmployeeName, but still not working. 

I think we need change a filter array or something like that. 
As i show you the previous reply, this flow still run successfully, but it result of addition still equal : Fasle. 
Thank so much for your help!!!

[CongDuong]

Dear @v-zhoqian-msft ,

I think the value of field EmployeeName is not same value as the Display name of Requestor.

So, please help me how we should change Filter array?

Thank so much!

[v-zhoqian-msft]

Hi @CongDuong ,

I now know "EmployeeName" in list2 is a Person field. This is different from what I guessed before.

You could change the setting of "Filter array" as follows:

Best Regards,

Community Support Team _ habsburg Qian

If this post helps, then please consider Accept it as the solution to help the other members find it.

[CongDuong]

Dear @v-zhoqian-msft ,

 i has been changed like this:

Flow running successfully, but still not apply the filter array and addittion.

[v-zhoqian-msft]

Hi @CongDuong ,

Please check the two points in the picture:

Best Regards,

Community Support Team _ habsburg Qian

If this post helps, then please consider Accept it as the solution to help the other members find it.

[CongDuong · Accepted solution]

Dear @v-zhoqian-msft ,

 It okey right now

Anh more question need you help It like this:

When Created item to list 2, time zone is shown-up wrong. it not same startdate and enddate in the list 1

List 1:

List 2:

Thanks you!

[CongDuong]

Dear @v-zhoqian-msft ,

This is my flow, if you have solution to fix,

Would you mind show me what i need to to step by step. I appreciate your support!

[v-zhoqian-msft]

Hi @CongDuong ,

The default time in SharePoint is your local time zone, while the time zone in power automate flow is UTC. When you create an item, the title field gets the string of UTC time. This causes the time to look different. So you need to convert Date Started and Ended to your time zone before create item,  using convertFromUtc function:

Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

[CongDuong]

Dear @v-zhoqian-msft ,

Which my flow, i trying add convertimezone but it not working.

If you don't mind, please help me by detail. Thanks you!

[v-zhoqian-msft · Accepted solution]

Hi @CongDuong ,

Change to the converted time in "Title" field:

And it shouldn't be UtcNow, input of this action should be the Data Started or Ended.