Forum Discussion
Advocate IAssistance with power Query nd Sharepoint online list
Power Query isn't really intended to write data back to a source, so I don't think there's a good way to update SharePoint via Power Query. You could look at creating a flow in Power Automate but is there a reason the column needs to be in the SharePoint list itself? You could add such a column in the query editor after loading in the SharePoint list (before loading the table to the data model).
Super UserPower Query isn't really intended to write data back to a source, so I don't think there's a good way to update SharePoint via Power Query. You could look at creating a flow in Power Automate but is there a reason the column needs to be in the SharePoint list itself? You could add such a column in the query editor after loading in the SharePoint list (before loading the table to the data model).