cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OC-ITServices
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
GarethPrisk 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
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
GarethPrisk 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

OC-ITServices
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.

OC-ITServices
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).
GarethPrisk 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.

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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (4,021)