Error "Invalid Hostname for This Tenancy" While Connecting to SharePoint List in UiPath

I am trying to connect a SharePoint list to UiPath. I’ve already set up the necessary configurations in Azure. However, when I attempt to retrieve list information in UiPath, I encounter the following error:

Error:

Get List Info: Code: invalidRequest
Message: Invalid hostname for this tenancy
Inner error:
   AdditionalData:
   date: 2024-10-07T05:07:25
   request-id: c3724f09-aab1-4610-b967-d465bef89774
   client-request-id: c3724f09-aab1-4610-b967-d465bef89774
ClientRequestId: c3724f09-aab1-4610-b967-d465bef89774

The SharePoint list I am trying to access is:
https://clientname.sharepoint.com/sites/uipathbot/Lists/test%20test1%20closing/AllItems.aspx?env=WebViewList

Whenever I manually access this list via the browser, I am prompted to enter a code sent to my email for authentication (MFA). Could this be the reason I am encountering this error in UiPath? Is there any workaround for accessing this list programmatically despite the MFA?

Looking forward to your suggestions and guidance!

@Vinit_Mhatre

What scope have you setup in azure?

Ideally you need to give a application scope

Cheers

I have resolved the issue, but now I need help with reading an entire SharePoint list and storing it into a DataTable. I’m currently using the “Get List Item” activity, but it requires selecting each column manually. Additionally, many columns are not appearing in the dropdown menu within the activity.

@Vinit_Mhatre

Can you show the activity…I believe if you dont select it would get all columns

If it is mandate then you can open advanced editor and you can write all columns as list

Cheers

Hi, bro

Can you explain how you fix this issue, I met a same problem. Same warning, same error


I just change the type to interactive token, no warning ,no error, also can download file to local.