Correctly connect to an Excel file in a Canvas PowerApp

Now, just putting an Excel with some crude data in it won’t really be identified in the Canvas App you are making. Perhaps you’re missing something.

Let’s say, I want to read an Excel file from OneDrive For Business into my Canvas App, I select the Excel file from the OneDrive for Business connection like below –

But, I’m treated with the below error while making a connection –

Correcting your Excel

Well, if your Excel looks like this –

Then, that’s the reason Canvas App is not able to connect to the data in the Excel. Here’s what you need to do – click on the top left corner of where your Table should start from and then click on Table from the Insert tab as shown below

Confirm that diagonal end of the Table you want to consider and click OK once confirmed

Once you confirm, you’re Excel data will look like this which is correctly formatted into a Table –

Reading the Table

Now that you’re set, you should be able to read the Excel file’s Table which you can connect to.

Hope this quick tip helps!!