Share via

Migrating Access to Power Platform. The description is possible?

Anonymous
2023-10-17T15:55:21+00:00

For my system, I need to get requests from my teams.

So I want to use Power Platform for this purpose:

  1. Submit a form as a normal user
  2. Admin will be able to approve or reject that
  3. Based on approval the normal user will be notified.
  4. After the approval the data will be stored in Dataverse / Azure Data Studio
  5. With that data I will be able to do queries, forms, modules, etc. as I can do with Access Database
  6. I will be able to do CRUD(Create, Read, Update & Delete) using power apps.
  7. I will be able to generate an Excel file with the database data and will be able to download it.

Is all this possible using Power Platform?

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. George Hepworth 22,855 Reputation points Volunteer Moderator
    2023-10-17T17:36:02+00:00

    Yes, with a number of caveats.

    PowerApps excels in the mobile space, i.e. on smart devices such as tablets and phones. If you need to collect requests from teams in the field, for example, where they are not able to connect to your network, PowerApps can do that. If you want to use PowerAutomate, or Flows, to handle those requests, you can implement that function.

    I'm not sure what "Azure Data Studio" means here. It is a development tool for interfaces that can connect to cloud data sources, so you wouldn't store anything in it. You'd use it to develop interfaces to the real cloud data source. Dataverse is available, but IMO, SQL Azure is a much stronger option.

    Your ability to manage the data using queries, etc. is going to be inferior to what you can do with Access, but it is possible to do a great deal nonetheless.

    So, the short answer is yes, you can do these things, as long as you are willing to adapt and adopt the appropriate approaches and methods.

    You might get some ideas here. The recent videos on building the Lander Trail Foundations Online Searchable Database might be especially useful.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-10-18T10:26:03+00:00

    Thank you, George.

    Was this answer helpful?

    0 comments