Hi there, I currently have a PowerApps created to calculation the leave that the employees have. I'm currently stuck at a part where I can successfully pull the data i need in order for the data to be correct but I need to add a calculation line whereby if the user selects a type like medical it'll deduct their medical leave and update it inside the form as well as the Sharepoint table. I have a slight idea but not so sure on how to execute on it.
Here's the idea and aim that I'm trying to achieve.
- If the user selects anything besides medical and or maternity, it'll deduct from their annual leave
- If the user selects medical, it'll deduct from their medical leave
- I don't mind using power automate as well I just need some guidance as I'm new to it all
