cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
danielst
Frequent Visitor

Update Data in CDS from csv

Hello!
My question is about updating data that is stored in the Common Data Service.

I have built a PowerApp that is based on this data. In simple terms, this data consists of two columns: Name of an item and stock level.


The stock level is updated in the external ERP system and this table is exported daily from a csv file, as a direct connection to the ERP system is not possible.

 

Now to my question: After my research, I have unfortunately not found an answer to this. What is the best way to perform such a data import from csv files into the Common Data Service environment on a regular basis? The stock should be updated, the names of the articles usually remain the same. Or is it necessary to delete all data every day and import it again? Is there a type of Data Import System job that can be done daily by Dynamics?

Please advise me on this.


Thank you in advance and best regards,
Daniel

1 ACCEPTED SOLUTION

Accepted Solutions
muralidharan
Resolver II
Resolver II

Hi @danielst ,

Can you please refer the below approach and it should be helpful to you.

You can do a scheduler to read the file from particular location on OneDrive or SharePoint, read the data and insert into Dataverse table. 

 

muralidharan_0-1622197011537.png

 

Thanks,

Murali.

 

View solution in original post

1 REPLY 1
muralidharan
Resolver II
Resolver II

Hi @danielst ,

Can you please refer the below approach and it should be helpful to you.

You can do a scheduler to read the file from particular location on OneDrive or SharePoint, read the data and insert into Dataverse table. 

 

muralidharan_0-1622197011537.png

 

Thanks,

Murali.

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Kudoed Authors
Users online (1,031)