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).
Solved! Go to 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.
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.
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.
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.
User | Count |
---|---|
255 | |
114 | |
95 | |
48 | |
38 |