Problem->Automating OneDrive Excel File Sync for UiPath Process Execution

Help Studio
, , , , ,
1

Issue: Syncing Excel Files from OneDrive for Automation Process

Hello UiPath Community,

I am currently implementing a process in UiPath Studio Web where:

  1. A Microsoft Form is filled by users, and the responses are stored in an Excel file located on OneDrive.
  2. When the automation runs, it extracts unique records from this input Excel file and appends them to a Master Data Excel file.

The Problem:
The input Excel file stored in OneDrive does not sync automatically every time the process is executed. To ensure the latest records are available, I have to manually open the file from OneDrive to sync it before running the automation.

To resolve this issue, I tried the following approach:

  • Used the Use Browser activity with a Go to URL activity to access the OneDrive file directly in the browser.
  • However, when running the process from Orchestrator, I receive the following error:

“Use Browser: Job Requisition Form.xlsx: Save user data folder is supported only on Serverless.”

Request for Help:
Could anyone suggest an alternative way to automatically sync the Excel file stored on OneDrive without requiring manual intervention? I’m looking for a reliable method to ensure the file is always up-to-date before the automation runs.

Thank you in advance for your assistance!

2

@Akanksha_Kate

You should be using O365 integration services for this.

3

Thank You! Could you please elaborate this in detail?

5

@Akanksha_Kate,

Follow this documentation.

6

Thank You so much!! I will check this.

1 Like