Assistance with power Query nd Sharepoint online list

[nikhil0511]

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 (Calculated)
1	0.5	1.5	2

Sharepoint online list

Date	column 1	column 2	X+Y (Calculated) from above table	column 3
02-Feb-2022	95	3.5	2	1.3

will it be possible to get that X+Y(Calculted) value to my sharepoint list automatically, instead of me updating all the time.

Pleae note that, the calculated value keeps changing dynamically on daily basis as X and Y values are dynamic values updating from a online service.

Thanks in advance.

[KNP]

Agree with @AlexisOlson's comments.

An alternative, if the calculation is simple, why not add a calculated column directly in the SharePoint list?

[AlexisOlson · Accepted solution]

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).