I have an Excel Spreadsheet with Macros that has a Table. The table contains all my sales data.
When I go to Powerapps Get Data to try and import the data into the Powerapps Data Entitites area, I select import from Excel, then OneDrive, point to my spreadsheet and get this:
An exception occurred: DataFormat.Error: The input URL is invalid. Please provide a URL to the file path on SharePoint up to the file name only (with no query or fragment part). (Session ID: 009a6bf8-d616-4cd4-96d0-35a97cc97d9e)
This is SOOOO frustrating. I feel like I can't even begin. HELP?

Report
All responses (
Answers (