Hello,
I want your suggestions and the most appropriate approach to the technology that we should use to implement the following requirements:
We have around 2500 employees and we plan to build a payroll calculation process on PowerApps model-driven.
Per employee, it will take approximately 12 records to generate his full salary.
So in total 30-40K records will be created when the calculation is over. Not to forget the other GET API operations to check the setup tables etc.. (Huge number of API calls)
I would like to know which product we should extend to handle this process and I thought about the following:
Using Azure Functions or the Console App with Dataverse.
We want to choose wisely as the product should be very stable and we want to avoid any timeout or delay issues during the calculation process.
Your advice and explanation of why we should use it and the pros and cons would be greatly appreciated.
Thank you,
EBMRay