PowerApps to import data from excel file.
Budget: $100 – $150 AUD
Not sure if this is possible. Just posting it here if anyone has done it and would like to take up the project.
I want an PowerApp which imports data from excel file and uploads it into SQL server table.
Trick is, Admin can create any Excel format. Meaning dynamic column names. Admin creates an importType i.e excel template which other users prepopulate and upload via the app.
Happy to discuss in chat to explain bit better.
I want an PowerApp which imports data from excel file and uploads it into SQL server table.
Trick is, Admin can create any Excel format. Meaning dynamic column names. Admin creates an importType i.e excel template which other users prepopulate and upload via the app.
Happy to discuss in chat to explain bit better.