cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Powerapps and Access

Hi all

I have been enjoying Powerapps greatly and committed a lot of time and effort into learning the platform, still a noob by a long shot. My reason for taking on the challenge is the company where I work has a 20 year old Linux database for our inventory tracking. It's really showing its age and some of it's limitations are really getting in the way. Management is still slightly on the fence regarding Powerapps and are considering Microsoft Access for their new database system (which I currently have no experience with). However, from what I gan gather, Access and Powerapps don't seem to natively intergrate.

We are a mussel processing plant with roughly 120 staff. Data entry for production happens in about seven different locations in the plant and my thinking was with PA I could make very user friendly interfaces for each department for data entry with a very small learning curve. I have been at this plant for ten years, so I'm not a new upstart wanting to turn the place on it's head, I consider the place well managed. However there currently is a lot of manual transposing of data which consumes a lot of time for the admin staff.

So I guess my question is, what do companies normally marry with Powerapps? & any opinions about Access?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Powerapps and Access

Azure SQL is inexpensive (about $25 / month for an S0 DBaaS offering) and far preferable to an Access fileshare database (for resilience, backup, capabilities).

Connecting Power Apps to Azure SQL requires purchasing additional licensing (10$ per user per App per month). If you are only entering data from Windows desktops in your organization, then an Access Front End to an Azure SQL Db would be a very low cost, very easy to implement solution.

View solution in original post

5 REPLIES 5
Highlighted
Super User III
Super User III

Re: Powerapps and Access

Currently you cannot connect to Access with Powerapps. You can look at this article on various Datasource and their strength to make your decision

https://baizini-it.com/blog/index.php/2017/08/29/powerapps-101-data-storage/

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Resolver II
Resolver II

Re: Powerapps and Access

hi there

 

Is there any specific reason you leaning towards Access and not SQL or mySQL.  

Highlighted
Helper IV
Helper IV

Re: Powerapps and Access

I'm leaning very much towards SQL,  I could be wrong here, but I guess they see Access as something familiar to what they know IE Excel. 

Highlighted
Super User
Super User

Re: Powerapps and Access

Azure SQL is inexpensive (about $25 / month for an S0 DBaaS offering) and far preferable to an Access fileshare database (for resilience, backup, capabilities).

Connecting Power Apps to Azure SQL requires purchasing additional licensing (10$ per user per App per month). If you are only entering data from Windows desktops in your organization, then an Access Front End to an Azure SQL Db would be a very low cost, very easy to implement solution.

View solution in original post

Highlighted
Helper IV
Helper IV

Re: Powerapps and Access

Thanks for your reply.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,399)