Project Details

1. Enate Analysis: The project begins with an analysis of the Enate platform, which is used for ticket creation indicating when the process should be executed. Upon ticket creation, an initiator for the process is automatically generated. 2. Power Apps: A Power App was created using Model-driven apps, where a form is generated for data entry, including email, company, and date. 3. Execution of Flow in Power Automate Desktop: Using Power Automate Cloud, a trigger is initiated upon adding a new record, activating a Power Automate Desktop flow that executes the process. 4. Power Automate Desktop API for Protheus: A connection is established with Protheus through an API to perform four database report queries. Access token is requested to use the API, later utilized in querying the four reports for the selected company in Power Apps. Query results are saved in Excel files. 5. Interaction with Alterix: Access the Alterix website. Upload the files obtained from Protheus. Use a date provided in Power Apps as a parameter for processing in Alterix. Once processed, download the final file generated by Alterix. 6. Confirmation and Closure: The final file is placed in the designated company folder. A confirmation email is sent to the user. If everything is confirmed to be correct, the process concludes. Otherwise, the process is restarted from the beginning.