Forum Discussion
Thomas_Jack
Nov 23, 2018Copper Contributor
Excel cell to populate from live sharepoint list
I have a sharepoint list for colleague assessments. Each time they are assessed we rate our colleagues from 1-4 on each of their different tasks. this is done on sharepoint. what i would like to do ...
SergeiBaklan
Nov 23, 2018Diamond Contributor
You may connect to sharepoint list with Power Query and update the results with each opening of the Excel file and/or refresh by clicking on button.
Thomas_Jack
Nov 23, 2018Copper Contributor
thanks for that. are you able to point me in the right direction to doing that?