I am on such a learning curve...
I want to develop a workorder inventory system using the power platform. Reading and updating data from tables located in an excel workbook.
I have a sharepoint group teamsite (private). I have 6 channels set up to represent regions (northwest, northeast, midwest, mideast, and so forth). Currently, I am developing for only the mideast and will eventually replicate the development for the others. In the mideast library is an excel workbook with normalized tables and data content (Workbook 1). There is another workbook located in \mideast\managers\workbook2… This workbook queries the first workbook mostly through "connection only" with a developed data model.
Not sure where to begin:
1). Do I want to get my data into power platform from the first workbook or second (no data model set up in workbook one)?
2). What type of power platform environment should I set up and where do I “import” the excel data – workflow, or lists… or other???
3). Can I maintain the data in the CDS instead by permanently migrating the data there? Or do I simply use the CDS while processing and then store the data back to the workbook?
