cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

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
Highlighted
Resolver I
Resolver I

Re: SharePoint List / Columns replicated in CDS

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

Highlighted
Super User
Super User

Re: SharePoint List / Columns replicated in CDS

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 (+1.000 students): https://www.udemy.com/pva-beginners

View solution in original post

14 REPLIES 14
Highlighted
Super User II
Super User II

Re: SharePoint List / Columns replicated in CDS

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
Highlighted
Super User II
Super User II

Re: SharePoint List / Columns replicated in CDS

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.
Highlighted
Super User
Super User

Re: SharePoint List / Columns replicated in CDS

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 (+1.000 students): https://www.udemy.com/pva-beginners
Highlighted
Resolver I
Resolver I

Re: SharePoint List / Columns replicated in CDS

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

 

 
 
Highlighted
Resolver I
Resolver I

Re: SharePoint List / Columns replicated in CDS

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??

Highlighted
Super User
Super User

Re: SharePoint List / Columns replicated in 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 (+1.000 students): https://www.udemy.com/pva-beginners
Highlighted
Resolver I
Resolver I

Re: SharePoint List / Columns replicated in CDS

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?? 

Highlighted
Super User
Super User

Re: SharePoint List / Columns replicated in CDS

@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 (+1.000 students): https://www.udemy.com/pva-beginners
Highlighted
Resolver I
Resolver I

Re: SharePoint List / Columns replicated in CDS

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (5,035)