Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JimJim
Helper V
Helper V

Connecting to a sharepoint list with multi line text column

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],

 

 

 

 

1 ACCEPTED SOLUTION
JimJim
Helper V
Helper V

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

View solution in original post

4 REPLIES 4
JimJim
Helper V
Helper V

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

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
Helper V
Helper V

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.