Turn Your Excel Spreadsheets into Power Apps in Minutes with AI

Поділитися
Вставка
  • Опубліковано 6 вер 2024

КОМЕНТАРІ • 27

  • @Praxinoa
    @Praxinoa 10 місяців тому +2

    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.

  • @samirberisha5846
    @samirberisha5846 16 днів тому

    all good but I can't figure it out how to use vba. i imported my xlsb file.
    Thanks

  • @dougydoe
    @dougydoe Рік тому +1

    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.

    • @AprilDunnam
      @AprilDunnam  Рік тому

      Thanks so much! I'm feeling much better :)

  • @akshaykore8584
    @akshaykore8584 Рік тому +2

    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.

    • @AprilDunnam
      @AprilDunnam  Рік тому +2

      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 :)

  • @patesker5780
    @patesker5780 Рік тому +3

    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?

    • @AprilDunnam
      @AprilDunnam  Рік тому +2

      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

    • @LukasSoftwareDeveloper
      @LukasSoftwareDeveloper Рік тому +1

      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 :)

    • @adsonnet
      @adsonnet Рік тому

      I think yes there is a option for Google sheets is App Sheets

    • @techdelasabana
      @techdelasabana Рік тому

      ​@@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?

    • @abdul.rehman.ikram1458
      @abdul.rehman.ikram1458 4 місяці тому

      @@LukasSoftwareDeveloper thanks for the explanation, it makes sense. Using excel to manipulate data would defeat the purpose of converting it to an app

  • @jonsteen
    @jonsteen Рік тому +2

    What are some of the benefits of turning the Excel worksheet into an app?

    • @LukasSoftwareDeveloper
      @LukasSoftwareDeveloper Рік тому +1

      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.

    • @AprilDunnam
      @AprilDunnam  Рік тому +1

      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.

  • @massimilianosabato
    @massimilianosabato 4 місяці тому

    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?

    • @AprilDunnam
      @AprilDunnam  4 місяці тому +1

      Sure, this video should help: ua-cam.com/video/3HJMF6Q4tiA/v-deo.html

    • @massimilianosabato
      @massimilianosabato 4 місяці тому

      @@AprilDunnam Thank you very much, it’s a pleasure to watch your videos!

  • @gaurav99ize
    @gaurav99ize 11 місяців тому

    It was amazing video and extremely useful information to learn the features of power app...
    Thank you for providing so useful content..

  • @nagasakin1126
    @nagasakin1126 Рік тому

    Can you add an excel file into data verse and then create a power bi report using data verse instead of excel?

  • @anismc200
    @anismc200 2 місяці тому

    Can u help me to create an app from my spreadsheet?

  • @senthilkumaranadityan9187
    @senthilkumaranadityan9187 10 місяців тому

    Guide to use Excel in power apps using sreen reader
    Expecting a video

  • @farestahamohamed835
    @farestahamohamed835 7 місяців тому

    Nice

  • @tigreytigrey8537
    @tigreytigrey8537 8 місяців тому +2

    Azure and all the microsoft products are wayyyy to confusing and cumbersome.

    • @AprilDunnam
      @AprilDunnam  8 місяців тому

      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.