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...
Solved! Go to Solution.
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
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!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
12 | |
8 | |
8 | |
8 | |
4 |
User | Count |
---|---|
29 | |
24 | |
22 | |
10 | |
9 |