Edit Form and link to Excel Table Data

[Tomkay]

Hi all, and thanks for your time on my issue.

I have been working on an app which in some part of it should be able to show record taken from an excel table stored on OneDrive for Business. I've used this table with Galleries in the app with no issues. 

But when I try to add an Edit Form, I'm able to link my table but then can't add my fields. The "+ add fields" link is "greyed" and I cannot access it to add my fields to add to the form. But it works perfectly if I want to use the Data Table tool.

Any Ideas on what I need to do to create this form? What am I missing?

Thanks!

Tom

[Drrickryp]

Hi @Tomkay 

If you used the Excel static data connector you would see this behavior.  The highlighted one can be edited, the top option cannot.

[Tomkay]

Hi @Drrickryp,

Thanks for the lead! Indeed I was using Excel static connector. 

So I picked up this new connector, but I can't seem to find a way to link my table with it. Would you have any advice to do so?

Thanks again!

[Drrickryp · Accepted solution]

@Tomkay 

Go to make.powerapps.com select create and then create from data. Click on the Excel icon and let PowerApps build the app from your data. 

[Tomkay]

Thank you very much for your help. 

I did as advised, and look in to what the system had created. And used the same OneDrive for Business connector! Works perfectly!

Thanks

[Drrickryp · Accepted solution]

Please accept as a solution.