Need advice on form connection

[Beatrix1]

Hello Everyone,

I am new to power apps. I am testing out to create a form using Canvas. The source is "import from excel." After the importing, the source data column shows "table 1," but the form screen shows that "without connect o any data, click connect to data" See prints screen below. After I click to connect to data, nothing happens, so I import from excel again, see the second attachment, but still the same.
My excel columns are in table format.
I need some advice on how to make data connections to the form screen. Thanks and much appreciated.

Sincerely

Beatrix 1 

[RandyHayes · Accepted solution]

@Beatrix1 

When you use the Import from Excel connector, it doesn't really create a connector.  Instead it creates a static snapshot of the data in your Excel file.  You are not connected to the file after that, so it will not appear as a datasource in order to use as a form source.

If you want to interact with the Excel file, you need to put the Excel file in a cloud location and then use the Excel Online (Business) connector to specify that Excel file.  

After that, it will then be a valid datasource for a form.

I hope this is helpful for you.

[Beatrix1]

Thanks so much, Randy. I save my file to Microsoft Team, it works. I appreciate it.