Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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"