Try this @joao.g
It seems you’re facing an issue while trying to add an automation package to UiPath Orchestrator, where the process keeps loading indefinitely. If you suspect that the cause is an activity that pulls data from an Office 365 spreadsheet, here are some suggestions to troubleshoot the problem:
Check the Connection to Office 365:
Make sure that the credentials for accessing Excel in your automation are correctly configured in the Orchestrator. You can test the connection to Excel in a local environment to ensure there are no authentication issues.
Validate Package Dependencies:
Ensure that all necessary dependencies and packages (such as Office 365 connectors) are correctly installed and compatible. Sometimes missing packages can cause conflicts.
Activity Configuration:
Review the settings of the activity that reads data from Excel. Make sure the file path is correct and that the file is accessible by the Orchestrator. If using variables to define the file path, ensure they are being correctly initialized.
Logs and Monitoring:
Check the Orchestrator logs for any error messages that may indicate what is causing the problem. This can help identify whether the issue lies in the execution of the activity itself or in some part of the configuration.
Test in a Controlled Environment:
Try running the automation in a development or testing environment where you can debug the workflow. Test with a smaller set of data or a simplified version of the automation.
UiPath Update:
Make sure you are using the latest version of UiPath Studio and Orchestrator. Updates may fix known bugs that could be causing the issue.
Alternative Storage Approach:
If reading the Excel file from OneDrive or SharePoint continues to fail, consider an alternative approach, such as temporarily downloading the file to a local server or using some other form of temporary storage for testing.
If, after following these recommendations, the problem persists, you might consider opening a support ticket with UiPath, providing specific details about the error and your configuration. This can help obtain a more targeted solution.