cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Can you add columns to excel data source after ?

So I'm starting to build my first PowerApp, and I realize I've missed a few columns of necessary data in my original data source (an excel file on OneDrive). I've added the columns, however when I do a refresh on the data source, the new columns arnt referenced, and so I cannot write formula's against their value.

 

Is this normal? Or is the a correct method to update the origin source data to add new columns as needed (not programatically, just updating the actual excel file one time).

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Impactful Individual
Impactful Individual

Re: Can you add columns to excel data source after ?

Better yet, CDS!

 

But for your Excel connections, using OneDrive or OneDrive for Business connectors, you will be able to pickup the metadata/column changes.

  • Add new column(s) to the OneDrive Excel file's table(s)
  • Save the file, ensure it has synced
  • If you had Canvas app studio open, then save, close, and open again
  • If you did not have Canvas app studio open, then load it
  • You should see the new column(s) available in any control using it as a data source

View solution in original post

6 REPLIES 6
Highlighted
Super User
Super User

Re: Can you add columns to excel data source after ?

Since this is an excel on OneDrive, you can remove the connection in your app and add it back again. It should then fetch those new columns.

I strongly suggest using SharePoint as an alternative as you will not run into issues like these.

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com
Highlighted
Impactful Individual
Impactful Individual

Re: Can you add columns to excel data source after ?

Better yet, CDS!

 

But for your Excel connections, using OneDrive or OneDrive for Business connectors, you will be able to pickup the metadata/column changes.

  • Add new column(s) to the OneDrive Excel file's table(s)
  • Save the file, ensure it has synced
  • If you had Canvas app studio open, then save, close, and open again
  • If you did not have Canvas app studio open, then load it
  • You should see the new column(s) available in any control using it as a data source

View solution in original post

Highlighted
Frequent Visitor

Re: Can you add columns to excel data source after ?

So i dont know how to use sharepoint as a data source. Im looking at building my own internal IT ticketing system (to help me learn powerapps), so im all ears on how to do this, or if you know of some good free resources.

Highlighted
Frequent Visitor

Re: Can you add columns to excel data source after ?

I dont understand CDS, and how to use it for what i need (custom ticketing form, for internal IT issues).
Highlighted
Impactful Individual
Impactful Individual

Re: Can you add columns to excel data source after ?

No worries! No CDS required.

 

You can use your Excel file from OneDrive/OneDrive for Business. To refresh the metadata, ensure the file has been updated (new column(s) added to the table(s) used in your app), and then re-open the Studio. The new column(s) should be available.

Highlighted
Super User
Super User

Re: Can you add columns to excel data source after ?

If you are interested in learning about SharePoint, here are some documents:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/app-from-sharepoint
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-onlin...
https://powerapps.microsoft.com/en-us/blog/powerapps-and-sharepoint/

There are also some Shane Young videos on the same topic.

Let me know if you need any more help in getting started with it.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,447)