cancel
Showing results for 
Search instead for 
Did you mean: 
0 Kudos

Add new column to SharePoint Online list from Canvas App to retain customization

Use case: In order to create an app which retains all the customization after the SharePoint Online list is periodically replaced by another list created by importing data from say an excel spreadsheet, which overwrites the columns needed for customization. By checking the non-existence and creating the columns required for customization during runtime will allow the app to run without manually re-creating the columns each time the list is re-created.

Though it is possible to retain single list with customization, replacing the data using grid view is time consuming and error prone.

Current process:

  1. Import excel spreadsheet to create SharePoint Online list
  2. Create columns required for customization from SharePoint list settings
  3. Create Canvas app
  4. Import new excel spreadsheet to new SharePoint Online list
  5. Re-create columns required for customization from SharePoint list settings
  6. Update data source to new list
  7. Re-publish Canvas app
  8. Repeat steps 4 to 7

With ability to create column from canvas app:

  1. Import excel spreadsheet to create SharePoint Online list
  2. Create Canvas app
  3. Check non-existence and create columns required for customization from Canvas App
  4. Import new excel spreadsheet to new SharePoint Online list
  5. Update data source to new list
  6. Re-publish Canvas app
  7. Repeat steps 4 to 6
Status: New