Scenario:
I have powerapp application with few forms and multiple screens connected to dataverse table.
Everyday I receive XLSx file with customer records.
(Customer Records: Existing customer with updated data and new customer records.)
Currently I manually update dataverse table using "EDIT WITH EXCEL option available under Edit menu is PowewApp solution.
However now I wish to explore automation solution as I receive XLS file with customer data every day multiple time and it include 20-30 new customer data rows and 10-15 existing customer rows with updated information.
Request:
What options are available to automatically ingest XLS file data import into Dataverse table.
Requirements:
a) Update function: If single or multiple customer with the same customer ID existing in XLS file and dataverse table then update dataverse table with XLS file information for each respective customer rows.
b) Add function: If new customer details is received from XLS then add those customer record rows into dataverse table.
c) Columns between XLS file and dataverse table remains constant. however column names between XLS file and Dataverse table are not 100% same so it may require one time column mapping.
d) New XLS file with data will be received everyday at 8am and 8pm into department group mailbox and xls file data needs to be imported into data dataverse table.
e) After XLS data is ingested into Dataverse, I should get email or Team message for successful/unsuccessful data import.
I am new to automating data import solution in PowerApps or Powe Automate so I am happy to try suitable solution with your expert guidance. Any ideas or link to similar problem/solution or suggestion are welcome.
