Turn Your Excel Spreadsheets into Power Apps in Minutes with AI
HTML-код
- Опубликовано: 7 июл 2024
- Get off of those Excel spreadsheets and into a fully functioning Power App in minutes using Microsoft's AI tool, Copilot! In this video, you'll see how to take your existing Excel data and utilize new AI features to move your data to Dataverse with a functional Power Apps application that works natively on desktop, tablet and mobile devices in minutes.
LINKS
Learn more about the Excel to App functionality here: aka.ms/aprilYT/ExcelToApp
00:00 - Intro
00:32 - Accessing Excel to App
00:48 - Create an app from Excel table
04:04 - Exploring the Power Apps
04:36 - Testing responsiveness
06:18 - Testing if all the data comes through
07:30 - Testing with unstructured Excel data
11:46 - Things to know 
Наука
Great video as always and extremely useful to know this feature exists. Hope you're feeling much better and in terms of your health. Thanks for sharing.
Thanks so much! I'm feeling much better :)
It was amazing video and extremely useful information to learn the features of power app...
Thank you for providing so useful content..
It's my pleasure
This is basically just doing what MS Access used to do, but in a more user friendly way. I wouldn't call this a "responsive app" as it is just a database with information that can either be accessed, input, or modified.
Are there options to make buttons that call information to be compared? Or filter options? What if I had numerical data that needed formulas to be applied? Now THAT would be a "responsive app".
This is just a better UX for database management.
Can you add an excel file into data verse and then create a power bi report using data verse instead of excel?
Excellent tutorial!! If there are multiple tabs in one excel sheet can Power Apps be used to work with it? If its possible, please create a similar tutorial for it. Thanks in advance.
Thanks! At the moment it can only handle a single Excel sheet at a time but there are work-arounds to get all sheets added in. I can add that to my list of videos to make :)
Can u help me to create an app from my spreadsheet?
Hi! Many compliments for all your content! Thanks to you I'm solving a lot of work problems! ❤ could you tell me how to print and export directly from Power Apps?
Sure, this video should help: ruclips.net/video/3HJMF6Q4tiA/видео.html
@@AprilDunnam Thank you very much, it’s a pleasure to watch your videos!
Is it possible for the Excel Spreadsheet to remain dynamic so that it can be continuously updated with data and still have the App work with the new data included?
Great question. Not with this functionality. The intention with this Excel to App is to get you off of Excel and into Dataverse. However, there's something called Virtual Tables that will do what you're wanting. I have a video that does an overview of how it works here: ruclips.net/video/vMEKnAtpPL4/видео.html
Essentially you connect to your data (Excel, SharePoint, etc) and it creates a virtual instance of it in Dataverse that you can then build Apps on top of that is automatically synced both ways. So if you update your Excel it will update in Dataverse and if you make changes in Dataverse it's updated in Excel
Excel is a useful tool for small-scale data manipulation and analysis, a real database like PostgreSQL provides better data integrity, scalability, concurrency, security, analysis capabilities, collaboration, and integration options. It is a more suitable choice when dealing with larger datasets, multiple users, complex data relationships, and business-critical applications.
Nor Excel, nor SharePoint are not databases. Microsoft Dataverse, is a cloud-based data storage and management service provided by Microsoft as part of the Power Platform. It is primarily designed to serve as a data platform for building business applications within the Microsoft ecosystem. So basically Microsoft goal is to suck you in and be dependent on Microsoft.
Being depending on Microsoft service is a bit painful when there are issues with Microsoft API, for example some connectors can have service downgrade and you can't do anything about it just wait for third party to fix it.
However, if you want to have great opportunity to structure your data you can host yourself Linux VM and host yourself PostgreSQL (free) via portainer+dockers and re-create excel logic to database and...start moving to web development. What that will help, you will move out from old solutions such as excel and move to real database where real power comes in. You will be able to pick any front-end solution and this type of experience will be much much better since canvas app and model-driven app have it's own limitations. You can also use power apps as front-end with these type of back-end solutions, but having strong core (database) is a big step forward than using excel. Power Apps are OK for simple tasks, but as usually solutions are tend to grow and scale which I prefer moving to selecting tech stack and deploying solutions. It's only sounds hard, but it's not :)
I think yes there is a option for Google sheets is App Sheets
@@AprilDunnamGreat video April. Thanks for sharing. I saw your video on Virtual Tables but apparently connectors are available for SQL or SharePoint only. Am I wrong?
@@LukasSoftwareDeveloper thanks for the explanation, it makes sense. Using excel to manipulate data would defeat the purpose of converting it to an app
Guide to use Excel in power apps using sreen reader
Expecting a video
What are some of the benefits of turning the Excel worksheet into an app?
Transforming an Excel worksheet into a Power App brings improvements in user experience, mobile access, data validation, integration, automation, collaboration, scalability, and customization. By transforming Excel into a database and utilizing that database with a Power App, you can achieve improved data integrity, scalability, concurrency, security, querying capabilities, integration options, consistency, and simplified app development. This combination offers a more efficient and robust solution for managing and interacting with your data.
So if you want to use your excel as data-source it will be OK for some time, but think about transferring data to real database (SQL, portgeSQL, etc.). There are good reasons why databases were invented and why researchers spent a lot of time developing them. As per my opinion - I'm more against having excel as data-source/database, if you need scalability, performance, smell of new technology and solutions, move to database rather than using old fashion excel.
There’s a lot of benefits. Excel isn’t a database so by using this feature you can move your data over to a proper database and take advantage of the many features that alone offers like a robust security model, integrations, etc. You get the added benefit of having an app on top of that data to easily add new items and search and filter the data.
Nice
Thanks!
Azure and all the microsoft products are wayyyy to confusing and cumbersome.
Thanks for sharing your thoughts! It's important to provide feedback so that companies like Microsoft can improve their products and make them more user-friendly.