I am customizing a SharePoint List Form through Power Apps and trying to connect an Excel table as an additional data source, but the Excel Connector can't find the location either by browsing locations or pasting the URL in directly. The crazy thing is that the Excel Workbook is saved in the Documents library on the same SP site that the list/app integration is on. I've tried numerous URLs, of the site itself, the doc library and the workbook, plus substituting the Site ID for Site Name in the URL but no luck. When I do try pasting the URL in I hit the error message "The data did not load correctly. Please try again." Clicking "More" reveals "Invalid hostname for this tenancy" and a session ID.
can you try to perform this in incognito window? Do you have maybe multiple accounts logged in?
Best regards,
Artur Stepniak
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.