cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JRuss
Helper II
Helper II

Import multiple columns in SP list to same column in CDS

Is there any way to collate multiple SharePoint columns into only two columns in CDS?  So rather than a direct 1 to 1 import, create sort of a stacked table configuration.  Please see screenshots... Note that the second screenshot is Excel, but representative of an SP list...

 

PowerAppsCommunity_Import-SP-to-CDS_01_2020-07-24_12-36-50.pngPowerAppsCommunity_Import-SP-to-CDS_2020-07-24_13-13-03.png

3 ACCEPTED SOLUTIONS

Accepted Solutions

So here is what I have done:

add a column in excel and concatenation the multiple columns into a new column

do your integration from that field

 

also depending on your dat migration tool, you can build a formula to concatenate multiple fields.

View solution in original post

That makes sense.  I was hoping for something a little more OOB since I have about 20 lists I need to bring into these same two columns, but this is a clever workaround (Export to Excel, stack them all).  I don't have a data migration tool, so I think your recommendation is going to be my best bet.  Thanks for taking the time to respond on a Friday!

View solution in original post

There are over a dozen ways to import data from excel into cds. Power Automate is one option that is out of the box, and it can easily concatenate multiple column values into a single cds column 

View solution in original post

4 REPLIES 4

So here is what I have done:

add a column in excel and concatenation the multiple columns into a new column

do your integration from that field

 

also depending on your dat migration tool, you can build a formula to concatenate multiple fields.

View solution in original post

That makes sense.  I was hoping for something a little more OOB since I have about 20 lists I need to bring into these same two columns, but this is a clever workaround (Export to Excel, stack them all).  I don't have a data migration tool, so I think your recommendation is going to be my best bet.  Thanks for taking the time to respond on a Friday!

View solution in original post

There are over a dozen ways to import data from excel into cds. Power Automate is one option that is out of the box, and it can easily concatenate multiple column values into a single cds column 

View solution in original post

Ooh, I like that method even better.  Thanks again!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,478)