Need advice on form connection

Like (0) Share

Report

Posted on 12 Oct 2021 00:52:09 by 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

Missing form in f...

after click conne...

All responses (2)

Answers (1)

Beatrix1 44 on 13 Oct 2021 at 00:33:37

Like (1)

Report

Re: Need advice on form connection

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

RandyHayes 76,287 Super User 2024 Season 1 on 12 Oct 2021 at 12:57:57

Like (0)

Report

Re: Need advice on form connection

@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.