cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Corissandageri
Post Patron
Post Patron

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
PaulD1
Super User
Super User

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
eka24
Super User
Super User

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.

rubin_boer
Super User
Super User

hi there

 

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

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. 

PaulD1
Super User
Super User

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

Thanks for your reply.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,000)