Connecting to a sharepoint list with multi line text column

[JimJim]

Hi Guys,

I am connecting to a sharepoint list which includes a column of type 'multi line text' which also appends any new data. It only returns the most recent entry for this column. Is it possible to include all data?

Here is part of my advanced editor code:

let
    Source = SharePoint.Tables("https://my.sharepoint.com/my_site", [Implementation=null, ApiVersion="Auto"]),
    #"36a2e38a-4901-480a-a829-240abdf5a198" = Source{[Id="36a2e38a-4901-480a-a829-240abdf5a198"]}[Items],

[JimJim · Accepted solution]

Guys, it looks like this has been asked a few times.

If anyone comes up against the same issue, please see this post https://community.powerbi.com/t5/Desktop/SharePoint-List-with-multiple-line-column-and-quot-Append/t... which also includes a link to a good video

[v-easonf-msft]

Hi,  @JimJim 

Thanks for your sharing.It seems that you have find the solution in the video.

Please accept you reply as soluion so  that other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason

[JimJim]

Thanks for the link, but having read it twice, I'm still as confused. I have no idea how to make this work in Power BI. Thinking my best option is to change the sharepoint solution by removing the append changes option and building up the history using the concat function in power automate

[lbendlin]

SharePoint Online – Retrieve values of a multi-line text field with append changes in a single REST ...