Forum Discussion
Add Empty Column in Excel power Query
Is there a way to add an empty column within a dataset imported from SharePoint online list for a user input
Can you add the column to the original table, before hit hits Power Query, or create a second table for user input, then import into power query and merge queries...? or create a new blank query in power query, then merge....
Yes, I had created an empty column in the Sharepoint list before importing it to the power query, but any data filled in that column is deleted when the data is refreshed!!!
the second option, creating a table, is not applicable, as according to the data coming from the Sharepoint, the user fill in that columnSo, when the user(s) input their data, is it saving to the original file? Is the sharepoint file in view only mode? Can other people other than you edit the file?
