Hi All,
Here's my requirement - I get excel sheets from 4 vendors each month. (4 different car leasing companies giving me details about my company's fleet resources)
I was thinking of creating a powerapp that allows users to directly upload these excel sheets to a sql table. I understand there is no direct way to do this. So, can I use sharepoint to upload each of these excel files and then run a job that takes the content of the sharepoint files and pushes them to a sql database? I'll have 4 tables for each of the vendors' data. And a 5th table that will hold the consolidated data. (Can run a stored proceudre for this). The goal is to create power bi reports for the fleet data, which is why I wanted to store all of our data onto a sql database. Right now, we have lots of distributed excel sheets.
Thanks a lot
Solved! Go to Solution.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
205 | |
187 | |
77 | |
49 | |
37 |
User | Count |
---|---|
318 | |
262 | |
122 | |
73 | |
60 |