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.

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!

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 

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

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,415)