Hi UiPath Team,
We are trying to run the Jobs in orchestrator from excel button which is available in sharepoint.
We tried alot methods and found out it was having some reroutes. But we expecting it to be done only within UiPath ecosystem.
Please let us know your thought process which could help us in resolving this.
Regards,
David
Hi, @David96
If you want to stay inside the UiPath stack, one option is to use Integration Service with the Microsoft 365 / OneDrive & SharePoint connection. You can configure a trigger that starts your Orchestrator process when a specific cell (or similar event) in the SharePoint Excel file changes, and then use your button to update that cell and save the file.
This works well if the button’s action can be reduced to “set this known cell to X and save”, because the trigger can watch that cell and then run your job. If your button only runs macro logic without a clear cell change, or if your tenant has limitations on Integration Service, then the more robust alternative is to call the Orchestrator API directly from VBA and start the job from there.
If you can share what exactly the Excel button does (writes to a cell, runs a macro, etc.), people here can suggest a concrete pattern.
hii @David96
To trigger a UiPath Job from an Excel button hosted on SharePoint the best approach is to use an orchestrator queue.
When the user clicks the button a dedicated monitoring process the starter bot should detect this signal and add an item to the orchestrator Queue.
Your main job is set up to automatically start running once an item appears in that queue ensuring a reliable trigger within the UiPath system.
Hi @David96
Triggering Orchestrator directly from an Excel button in SharePoint will always have redirect issues.
Use UiPath Apps, Assistant, or an intermediate UiPath workflow to trigger the job—fully inside UiPath ecosystem and 100% reliable.
Cheers
Hi @arjun.shiroya , I tried this event based trigger from community orchestrator. I was not able to set it up as it was not allowing me to click Add or Next button to have this scheduler in place. Attaching the screen shot below for the same,
VBA is not getting supported or not able to make it run from excel file available in SharePoint. As excel file in SharePoint is supporting office scripts that can be written inside button. From this its has good integration with power automate cloud flow not with UiPath ecosystem.
Button functionality expected: When this button is clicked, the orchestrator job must be triggered which does couple of operation with this excel file and another desktop application.
Hi @Jp_Khetan , This seems to be a good approach but can you explain bit a more on how the button activity or button click event can be monitored by UiPath process to add a queue item for queue in orchestrator.
Hi @nishiijain2000 , UiPath apps is a good approach but my client is very new to RPA. So at first we didn’t thought to have UiPath apps exposed for this first project as we may be thinking, this comes with additional license cost.
Triggering from assistant will become an attended automation or requires the licensing configured for the business user system.
Can you explain me more about the intermediate workflow.
You can trigger a UiPath job from Power Automate primarily using the UiPath Connector for Power Automate(the modern, recommended way) or by calling the UiPath Orchestrator API with an HTTP request (the classic, API-focused method).
The connector simplifies things by handling authentication and provides actions to select processes, while the API approach involves manually setting up HTTP POST requests with Personal Access Tokens (PATs) to the Orchestrator URL.
Both methods allow you to pass data and manage job execution flow, creating powerful cross-platform automation.
Orchestrator Excel triggers are limited and may not be fully available in all tenants.
SharePoint Excel on the web does not support VBA..it uses Office Scripts and integrates naturally with Power Automate.
Power Automate calling the Orchestrator StartJobs API is an officially documented and standard way to start jobs from external systems
@ashokkarale , Thank you for this approach. I have done it like office scripts triggering power cloud flow and where as power automate cloud flow triggering UiPath trigger api which had the process scheduled. Only extra what I saw was this power automate cloud flow required premium license to have this action ‘when an https request received’ to be triggered. I pitched in this solution but my VP is not happy about it as it would bring controversy of multiple RPA technology is being used.
Hence suggested to download this excel file locally to have excel macros in place to trigger jobs via orchestrator apis.
@arjun.shiroya yeah mate you were right. I have succeeded by this approach of office script triggering cloud flow of power automate which triggers orchestrator api trigger as I replied to @ashokkarale suggestion.
Now we falling back to old school model of not buying any premium license of power automate cloud instead triggering orchestrator apis from vba macros.
using orchestrator change event trigger would be the best way and the right way for your case..I see add being highlighted were you not able to clic to add trigger or is it clicked but are you getting some error?
if errors out just to make sure check networks tab for any error there..
cheers
