Unanswered

leave request template, how to update balance table?

(0) Share

Report

Posted on by adminmca

Hello There, I am trying to customize leave request template. So far I've succeeded in using SharePoint as external data source and created a flow for approvals that update the leave table my question is how can i update the balance table if leave is approved?

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

Rahber 1,935 on at

Like
a
(0)

Report
Copy link

Link copied!

So in your approval flow. If the approval is completed you can then go back to your share point item and update the Balance List
adminmca 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Rahber, do you mean that i should update the balance table manually from SharePoint?
besides my flow only update the leave table. what i want is whenever this table is updated the balance table should as well get updated automatically
Rahber 1,935 on at

Like
a
(0)

Report
Copy link

Link copied!

So in your picture 11.png

if the response is Yes. You should add another action "Update Item: that will go to update the balance table.
adminmca 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the suggestion, I've did that but the balance table did not update. i was thinking if we need to insert a logical statement like if this is updated than update this....!!!
Rahber 1,935 on at

Like
a
(0)

Report
Copy link

Link copied!

You might need to check your flow because two different share point lists doesn't work on a logical statement.

you need a flow to update them. If you can share the flow part maybe we can take a look.
adminmca 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your consideration here's the complete flow
Rahber 1,935 on at

Like
a
(0)

Report
Copy link

Link copied!

In your C3.png.

Under update item

add another action of Update item

And choose the list of balance and then update the row you want to modify.
Dniinoi 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello adminmca,
My problem is similar to yours and I am stuck.

I have two SharePoint Lists: BalanceLeave and LeavesAppliedByUser. The BalanceLeave holds all the types of leaves ( Annual Leave, Sick Leave, Casual Leave etc.. and the number of days). The LeavesAppliedByuser has all leaves application made by users. So basically I want to display the balance of leave in a power app screen.

Below is my formula.
Sum(Filter(BalanceLeave,LeaveId=ThisItem.LeaveId),Total_Leave) - Sum(Filter(LeavesAppliedByUsers,LeaveId.Value=ThisItem.LeaveId && RequestedBy.Email=User().Email),TotalDays) & " Days".
At the moment, this formula doesn't deduct from the total leave days... It brings the total leave as in Balance Leave.

Kindly assist.