Update Different sharepoint lists based on creteria

Stanley007 

You can create Power Automate to update remaining absences. You should create Power Automate on Leave Request list with trigger Item is created or modified with condition "Status" is approved and there you can update remaining days in your list for that particular employee.

I am describing high level steps of the power automate here which might be helpful to you.

1. Use Get Items action to get relevant list  item by current employee, leave type and no. of leave applied from list where you maintain employee, absence type and type of absence  - 
2. Use Update Item action to update remaining absence days -> here you need to calculate remaining absence with formula while you are setting remaining absence list.

Below are some useful documentation link

• All Activities related to SharePoint - https://docs.microsoft.com/en-us/connectors/sharepointonline/ 
• Conditional Trigger (which you will need according to your requirement) - https://www.youtube.com/watch?v=HLxZ_lGhEg8 
• Update List Item - https://www.enjoysharepoint.com/power-automate-update-sharepoint-list-item/

Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community