Forum Discussion
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 (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.
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).
2 Replies
- AlexisOlson
Super User
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
Agree with AlexisOlson's comments.
An alternative, if the calculation is simple, why not add a calculated column directly in the SharePoint list?
