You’re offline. This is a read only version of the page.
Announcements
Hi everyone, this is my first post and i'm fairly new to PowerApps. I'm looking for a functionality that allow the user to upload a file (an excel file in this case) browsing on it's file system. After that save the content of the excel file within a collection and patch it to a SQL Server table. I was reading on the web but i didn't find a solid solution to achieve such a task. So i was wondering if someone more expert can introduct me to the most efficient solution/approach to deal with this case. It's not mandatory that the file needs to be saved in a collection, i just need that the Excel file content is insert in a sql server table.
Hope you understand my question, thanks in advance for anyone who'd like to help me.
Hello, @Anonymous, You will have to use the Attachment Control and Power Automate to Achieve this. Here is a full video tutorial that can help by Shane Young . Note, the tutorial is inserting the excel file data into a SharePoint list and your have just to insert your data into your SQL table. https://youtu.be/MhFNwjaR10A
| If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more. I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends. Visit my Blog: www.powerplatformplace.com Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos |
Share
Report
All responses (
Answers (
6,678
