cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Edit Form and link to Excel Table Data

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

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User II
Super User II

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

View solution in original post

Super User II
Super User II

Smilegif.gif

 

Please accept as a solution.

View solution in original post

5 REPLIES 5
Super User II
Super User II

_1.pngHi @Tomkay 

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

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!

 

Super User II
Super User II

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

View solution in original post

New Member

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

Super User II
Super User II

Smilegif.gif

 

Please accept as a solution.

View solution in original post

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (20,169)