cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
danielst
Helper I
Helper I

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 III
Resolver III

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 III
Resolver III

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.

 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (2,125)