Power apps

[Parvathy_23]

Hi

I want to calculate the balance leave by subtracting applied leaves from Total leaves, eg:Total:6, applied:2, balance:4. So next time total should be 4.How to do it in Power Apps using SharePoint ID? 

@RezaDorrani

[Syndicate_Admin]

You can calculate the balance leave in Power Apps using SharePoint by subtracting the applied leaves from the total leaves.

For example, if the total leaves are 6 and the applied leaves are 2, then the balance would be 4. The next time, the total should be 4.

One way to achieve this is by creating a SharePoint list to store the leave information for each user. You can then use Power Apps to connect to this SharePoint list and retrieve the leave information for the logged-in user. You can then use formulas in Power Apps to calculate the balance leave by subtracting the applied leaves from the total leaves.

There is a discussion on the Power Platform Community forum where a user had a similar requirement and received a solution¹. You can also check out this tutorial video on YouTube that shows how to build a leave request application in Power Apps using SharePoint as a data source⁴.

I hope this helps! Let me know if you have any further questions. 😊

(1) Solved: Leave balance for each user - Power Platform Community. https://powerusers.microsoft.com/t5/Building-Power-Apps/Leave-balance-for-each-user/td-p/1249306.
(2) Leave Request Power Apps Template - SharePoint - YouTube. https://www.youtube.com/watch?v=0U5jax-zMIc.
(3) Solved: Creating a List of All Employees Leaves and Calcul... - Power .... https://powerusers.microsoft.com/t5/Building-Power-Apps/Creating-a-List-of-All-Employees-Leaves-and-....
(4) Solved: Using Sharepoint List for Leave Request Template - Power .... https://powerusers.microsoft.com/t5/Building-Power-Apps/Using-Sharepoint-List-for-Leave-Request-Temp....
(5) undefined. https://make.powerapps.com.