Can you add columns to excel data source after ?

[OC-ITServices]

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

[PowerAddict]

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 · Accepted solution]

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

[OC-ITServices]

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]

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

[GarethPrisk]

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.

[PowerAddict]

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