Hello,
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.
Thanks in advance!