I used the template Leave Request to build an app that my organization can use. However, that template pulls data from a OneDrive Excel spreadsheet. The reality of the situation is that everyone here has a different set amount of days in their time banks. We keep track of everyone's current banks (sick leave, vacation, floating, etc.) through a ERP software called Unit 4 Agresso.
Is it possible to link this PowerApp to Agresso so that it'll reflect the correct hours for indivdual employees? The data in OneDrive Excel are static, we would like to have it dynamic so that everyone can properly rely on this application. Someone did mention that we can export the Unit 4 Agresso timebanks into ASP Runner?