Inability to provide value for folder

Getting Started with UiPath 20 Use Cases Learning Sprint
1

image
image1476×740 55.2 KB

I am just starting my journey with UiPath. I encountered some challenges while trying to run my first automation.
I have attached a screenshot of the error message.
Please i need help in resolving this error.
Thank you.

2

Hi @c.jsampson

From the screenshot, the Create Workbook activity is using a Microsoft OneDrive & SharePoint connection. The warning indicates that you are using a Personal Account, which has API limitations for this activity.

I would suggest the following:

  1. Try using a Microsoft Business/Work account connection instead of a Personal Account.
  2. Reconnect the Microsoft OneDrive & SharePoint connection in UiPath.
  3. After reconnecting, open the Folder field and check whether the OneDrive folders are loading.
  4. If you are only practicing and don’t specifically need OneDrive, you can alternatively use a local folder path with the appropriate Excel activity.

The message “We’re unable to access the remote service. Make sure your connection is valid.” usually indicates that UiPath cannot access the configured Microsoft connection.

Hope this helps!

3

Hi @c.jsampson,

Welcome to UiPath Community!

This is actually a very common first-project hurdle, it’s a connection/authentication issue with the Microsoft OneDrive & SharePoint connector.

Here are the steps which you can follow:

  1. If you signed in with a personal Microsoft account, that’s the root cause. UiPath’s Excel Online / OneDrive & SharePoint activities are built primarily for work/school (Business) Microsoft 365 accounts, not personal ones.
  2. Click the connection settings icon and then try removing and re-adding the connection. When it opens the Microsoft sign-in popup, sign in again and make sure you grant all requested permissions.
  3. Since you’re just starting out, the simplest path forward for practice is to skip cloud storage entirely. Replace “Create Workbook” (OneDrive/SharePoint version) with the plain “Create Workbook” activity from the Excel activity package (not “Excel Online”). This writes to a local file path on your machine instead of OneDrive. Once you’re comfortable with the basics, you can circle back to cloud connectors when you have access to a business/work account.

Cheers!

4

@c.jsampson

Welcome to the community

As per warning its clear that you are using personal account and it cannot access few activities due to license restrictions

Looks like you are on studio web ..if so then eitherswitch to business account to create connection so that you can create workbook in sharepoint

Or shift to studio and you can use normal workbook or excel activities

Cheers

Cheers

5

Hi @c.jsampson,

Welcome to the community.

You cannot use a personal Microsoft account for this automation. You need a Microsoft work/school (business) account with the required permissions.

Since you mentioned that you’re just starting your RPA journey, you can also use a Google account to get started. You can use Google services such as Gmail, Sheets, Drive, etc., for your automation practice.

You can also use your corporate Microsoft account. However, your organization may not allow or support the UiPath Community license with a corporate account.

Thanks!