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?