Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Powerapps and Access

(0) ShareShare
ReportReport
Posted on by 725

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?

  • R Bakker Profile Picture
    R Bakker 725 on at
    Re: Powerapps and Access

    Thanks for your reply.

  • Verified answer
    PaulD1 Profile Picture
    PaulD1 2,914 on at
    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.

  • R Bakker Profile Picture
    R Bakker 725 on at
    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. 

  • rubin_boer Profile Picture
    rubin_boer 4,806 on at
    Re: Powerapps and Access

    hi there

     

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

  • eka24 Profile Picture
    eka24 20,921 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard