I can`t import Data from a List

Jose Vilar 0 Reputation points
2024-06-21T15:40:15.6266667+00:00

How to fix: An exception occurred: DataFormat.Error: The input URL is invalid. Please provide a URL to the root of a SharePoint site, or to the service document or entity of its OData feed (with no query or fragment part). (Session ID: 35e9ed08-e7c5-4cd0-b047-c3b3e4e94754, Region: europe)

This question is related to the following Learning Module

Microsoft Dataverse Training
Microsoft Dataverse Training
Microsoft Dataverse: A Microsoft service that enables secure storage and management of data used by business apps. Previously known as Common Data Service.Training: Instruction to develop new skills.
17 questions
{count} votes

1 answer

Sort by: Most helpful
  1. RDash 1,340 Reputation points Microsoft Vendor
    2024-06-25T06:59:28.3566667+00:00

    Hi Jose Vilar ,

    To fix the error "An exception occurred: DataFormat.Error: The input URL is invalid. Please provide a URL to the root of a SharePoint site, or its OData feed," follow these steps:

    1. Ensure the URL points to the root of your SharePoint site and does not include additional paths, queries, or fragments. The URL should resemble this format:
    https://yourOrganization.sharepoint.com/sites/yourSharePointsite
    
    1. Ensure you have the required permissions to access the SharePoint site and list. You need at least read access for the import. Verify you are signed in with the correct credentials, and if necessary, log out and back in to confirm proper authentication.
    2. Double-check the SharePoint list URL for any errors such as typos or extra characters. Ensure the URL is clean and direct, without unnecessary slashes or spaces leading to the SharePoint site. Also, confirm there are no network connectivity issues by accessing the site and list directly through a web browser.
    3. Check your regional settings to ensure they are accurate. Sometimes errors can occur due to differences in regional settings. Make sure that the region mentioned in the error message matches the region settings on your device.
    4. Clear your browser's cache and cookies. Outdated cache can sometimes lead to problems with authentication and connectivity. 

    Following these steps should help resolve the issue and enable successful import of data from your SharePoint list into your Dataverse table.

    If the issue persists, 

    please refer to additional information. You can also go through this link for further solutions that may help you resolve the issue:https://powerusers.microsoft.com/t5/Building-Power-Apps/Unable-to-import-excel-sheet-from-on-premise-sharepoint/m-p/534445#M164007

    If the issue persists, please contact us. We're here to assist you, please include a screenshot of the error for further assistance.

    Please don't hesitate to reach out to us if you have any further queries. I hope the information provided has been helpful to you! If so, please accept the answer by clicking the Accept Answer / Upvote on the post. We value your feedback, and it will help to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Q&A!