cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RustyNails Regular Visitor
Regular Visitor

Importing Sharepoint Text column with Append selected - only imports the latest entry

Hello,

 

I'm trying to import a Sharepoint List with a Text column that has "Append Changes to Existing Text" selected. What this does is allow different users to add multiple entries to the column when they go and edit it instead of just editing a one block of text.

 

However when I try to import this column, only the latest entry is being imported. Is there a way to import all the entries by all the users?

 

Thanks

7 REPLIES 7
v-jiascu-msft Super Contributor
Super Contributor

Re: Importing Sharepoint Text column with Append selected - only imports the latest entry

Hi @RustyNails,

 

How does it look in your model? Seems good in my side. Please refer to the snapshot below. We just need to extract the values.

Importing-Sharepoint-Text-column-with-Append-selected-only-imports-the-latest-entry

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RustyNails Regular Visitor
Regular Visitor

Re: Importing Sharepoint Text column with Append selected - only imports the latest entry

I dont see it in my data model, it does not have anything that's coded in that way. The model itself imports the very last entry. "Comment" is my append column from sharepoint.

 

image.png

v-jiascu-msft Super Contributor
Super Contributor

Re: Importing Sharepoint Text column with Append selected - only imports the latest entry

Hi @RustyNails,

 

1. Please check online if the Sharepoint has the data. 

2. You can get that field. The question now is the amount of the records. Did you apply any filter function?

3. Can you share the code in the Advanced Editor? Please delete or mask the private data. 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RustyNails Regular Visitor
Regular Visitor

Re: Importing Sharepoint Text column with Append selected - only imports the latest entry

Sharepoint does have data. It has multiple entries for the items. I dont have any filters in place.

 

The advanced editor is:

 

let
    Source = SharePoint.Tables("https://###.sharepoint.com/teams/###", [ApiVersion = 15]),
    #"0ec180ce-d236-49e5-b1bd-7cf0dd20b2b5" = Source{[Id="0ec180ce-d236-49e5-b1bd-7cf0dd20b2b5"]}[Items],
    #"Renamed Columns" = Table.RenameColumns(#"0ec180ce-d236-49e5-b1bd-7cf0dd20b2b5",{{"ID", "ID.1"}})
in
    #"Renamed Columns"

v-jiascu-msft Super Contributor
Super Contributor

Re: Importing Sharepoint Text column with Append selected - only imports the latest entry

Hi @RustyNails,

 

Do you mean the version history? If so, there is a workaround in Getting-SharePoint-List-items-with-full-history-version/td-p/64743

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mwllms Frequent Visitor
Frequent Visitor

Re: Importing Sharepoint Text column with Append selected - only imports the latest entry

Hi @RustyNails: Were you able to find a workaround or solution for this? I am running into this issue as well.

Highlighted
RustyNails Regular Visitor
Regular Visitor

Re: Importing Sharepoint Text column with Append selected - only imports the latest entry

Hello, I wasn't able to find a solution 😞 

 

I instead created a separate page in Sharepoint with a link to the list.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 212 members 2,148 guests
Please welcome our newest community members: