cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ClarkyPA365
Post Patron
Post Patron

SharePoint List / Columns replicated in CDS

Hi,

 

I'm looking to convert a SharePoint List to CDS.  

 

Firstly how easy it if this is for a Canvas Application?

Secondly, how would i replicate this process?

 

I have a SP list with two columns which contain the Area and a Hint of what the user needs to do (See attached SP_Area_Hint)

This is used in a gallery in my canvas app.  (See attached Requirement_Hints)

 

Any assistance would be muscly appreciated 

2 ACCEPTED SOLUTIONS

Accepted Solutions

Hi @renatoromao 

Thank-you.  Managed to create an Entity in CDS😀.

Will probably need to do some refining / fine tuning but at least I have the basic to get the data into CDS.

 

I suppose the URL you provided is the template for this and just needs me changing the last few parameters??? 

 

View solution in original post

Nice @ClarkyPA365 !

 

Yes, just change the last parameter. 🙂

 

Please, if my answer resolves your problem, please, make as a solution to help more users.

 

Thanks! 🙂


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

View solution in original post

14 REPLIES 14
HSheild
Super User
Super User

Hi @ClarkyPA365 

 

If you want to convert a SharePoint list to CDS you can use the following high level process:

  1. Create a new entity in CDS that represents your SharePoint list i.e. has the same fields
  2. Use Power Automate to read the data from your SharePoint list and populate it into the new entity you created in CDS
  3. Update your Canvas Power App to use the new entity in CDS as the datasource rather than the SharePoint list

Additionally, depending on the volume of records in SharePoint and your licensing model, you could do a Data Flow.

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/create-and-use-dataflows

As noted in the last post, you'll want to correlate the columns/fields by similar/compatible data types. Then you can map the fields from one to another.

I also recommend setting up an Alternate Key in CDS, to populate as an foreign key from SharePoint (like the ID column), so you can find/match/update and test between systems after migrating data.
renatoromao
Super User
Super User

Hi @ClarkyPA365 ,

 

Convert your SharePoint list to CDS entity using the easy way:

1- Open the make.powerapps.com

2- Data >> Entities

3- Click on the "Get data" button

4- Click on the OData

5- Fill the fields with your URL site, connection, and other data
URL site: https://yourtenant.sharepoint.com/sites/yoursitecollection/_api/web/Lists/getbytitle('thenameofyourl...

6- After loads the data, click on the next button and selects if you want to load using the existing entity or using a new entity

7- Fill the other information and finish your importation 

 

If my answer help your, please, make as a solution to help more users.

 

Thanks! 🙂


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

Hi @renatoromao 
Thanks for your reply which by the sounds of things seems the easier one to try first.

I followed the process but have come across 'Invalid credentials'

 

See attached

 

 
 

Hi @HSheild 

 

Thanks for your reply.  I'm still feeling my way round the Power Platform and haven't really had much experience of working with the Power Automate.  So I can learn can you provide a starting point as how to get the data from SharePoint and tips of how to get it into CDS??

Hi  @ClarkyPA365 ,

 

Yes, it is easier.

 

Which URL did you try to use?

https://yourtenant.sharepoint.com/sites/Journey/_api/web/Lists/getbytitle('Perimeter%20issues')/Item...

 

Please, create a new connection with Microsoft Account (Organization account) and entry with your user/password used on your SharePoint environment.


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

Hi @renatoromao 

 

The URL used 

https://tenent.sharepoint.com/sites/Journey/Lists/Perimeter%20Issues/AllItems.aspx

 

Chnaged the Autherntication from Anonymous to Organisational Account.

I signed in with my Microsoft account, used for work, and still have the invalid credentials?  Do I need to have global admin to perform this function?? 

@ClarkyPA365 ,

 

When you are getting the data using OData you need to use my way to do it.

Please, change the URL to: https://yourtenant.sharepoint.com/sites/Journey/_api/web/Lists/getbytitle('Perimeter%20issues')/Item...


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

Hi @renatoromao 

Thank-you.  Managed to create an Entity in CDS😀.

Will probably need to do some refining / fine tuning but at least I have the basic to get the data into CDS.

 

I suppose the URL you provided is the template for this and just needs me changing the last few parameters??? 

 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,360)