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 Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (1,885)