Forum Discussion
ID Issue Appending Multiple Sharepoint Queries
Hello, I'm running into issues bringing in data from multiple Sharepoint lists into an appended table. It seems to choke a bit on the ID columns (which I obviously have no control over in Sharepo...
Greg_Deckler
Community Champion
Community ChampionI take it that you need the ID column for some reason? Can you just not import it and add an ID column in the query? What if you create a calculated column in SharePoint that has a formula of, essentially =[ID] and import that column instead of ID?