Share via

Cloud form for Dataverse?

Anonymous
2024-02-24T01:22:34+00:00

I have developed several applications on Microsoft Access using Dataverse as the source tables. This works very well but the main drawback is that I have to create Front end files and install them on multiple desktops. This can be a challenge to manage updates. I would be very handy if I could replace the Access front end with a cloud solution so, users can easily use the app on their browser. I am looking at Microsoft Forms for Dataverse tables, but I don't see a way to connect Forms to Dataverse. Any ideas?

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2024-02-24T02:16:51+00:00

    Apps usually abandon CRUD pretty quickly, and logic becomes more important. So one option is a quick cheap Access FE to that data with VBA logic, or a .NET web app with all its overhead and costs. Is there anything in the middle?

    1 person found this answer helpful.
    0 comments No comments

9 additional answers

Sort by: Most helpful
  1. Anonymous
    2024-02-26T02:42:04+00:00

    re:need tools requiring minimal coding and learning time.

    with the AI like Copilot help,many codings can be finished without difficulties.

    0 comments No comments
  2. Anonymous
    2024-02-25T19:32:05+00:00

    Hi Grover,

    I am familiar Power Apps. Unfortunately, I don't have the time to invest in the steep learning curve required to use it. As opposed to Access, I also find the Power Platform environment incredibly unwieldly and complicated. Developing and deploying apps using Access is much faster than Powers Apps. Access allows for the creation of queries and reports in one environment. And easily customizing a Power App? Good luck with that. Furthermore, the hybrid Power Apps environment, what I call pretzel logic, with confusing GUI's, makes it nearly impossible to create anything useful without deep programming experience. To be clear, I am not a software developer. I am an Access Database developer. And that is the huge difference here.

    Access is a tool that citizen developers like me can use with a reasonable learning experience in a reasonable amount of time, something Microsoft is woefully out of touch with. Whoever developed Power Platform doesn't understand the exigencies of medium to small businesses or, in my case, a nonprofit. Busy, overloaded staff, i.e., citizen developers, need tools requiring minimal coding and learning time. Microsoft, touts Power Apps as a low code/ no code platform. Sure, you can create an app from a spreadsheet or an SP List and create something like an employee directory via drag and drop but the low code side is anything but! And this is why upwards to 75% of staff at organizations that have Power Platform licenses don't use the application. It is just too difficult to use. In this regard, Power Apps is not a very useful tool.

    In any case, I found the solution I am looking for and, ironically but not surprisingly it, is not a Microsoft solution.

    0 comments No comments
  3. George Hepworth 22,765 Reputation points Volunteer Moderator
    2024-02-24T12:17:51+00:00

    Although I agree with Tom's comments, I would also like to point out that the "browser" based solution you might want to implement could be in PowerApps, not MS Forms.

    https://youtu.be/2SSDAxpXngE

    Licensing costs are a significant factor, though. It might bear investigation nonetheless, as would be the case with other solutions.

    0 comments No comments
  4. Tom van Stiphout 40,201 Reputation points MVP Volunteer Moderator
    2024-02-24T02:27:09+00:00

    > This can be a challenge to manage updates.

    It doesn't have to be.

    In its simplest incarnation the BE has a table with CurrentFEVersionNumber and if that does not match, you bitterly complain and direct the user to update their FE,

    0 comments No comments