Forum Discussion
nikhil0511
Advocate I
Advocate IAssistance with power Query nd Sharepoint online list
Hello Forum, I have a doubt or what I want to do basically. I have a table added to my data model via power query : for example as follows Table with 4 columns Id X Y X+Y (Calcula...
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).
KNP
Super User
Super UserAgree with AlexisOlson's comments.
An alternative, if the calculation is simple, why not add a calculated column directly in the SharePoint list?