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.
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.
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 :)
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: ua-cam.com/video/vMEKnAtpPL4/v-deo.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 :)
@@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
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.
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?
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.
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.
all good but I can't figure it out how to use vba. i imported my xlsb file.
Thanks
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 :)
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 :)
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: ua-cam.com/video/vMEKnAtpPL4/v-deo.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
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.
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: ua-cam.com/video/3HJMF6Q4tiA/v-deo.html
@@AprilDunnam Thank you very much, it’s a pleasure to watch your videos!
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
Can you add an excel file into data verse and then create a power bi report using data verse instead of excel?
Can u help me to create an app from my spreadsheet?
Guide to use Excel in power apps using sreen reader
Expecting a video
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.