I want to use Microsoft Access database with the Microsoft Flow and PowerApps.
Is it possible to do? If yes then how?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
PowerApps and Flow are cloud services and has to be able to connect to the data source. There is no Microsoft Access database as-a-service and gateway does not support this kind of on-premise data source.
In actual fact yes, you can! But it's not a direct link. As Lukas mentioned, Flow and all 365 services are Cloud based. However, there is a magical connector called SQL Server!
You will need to turn your PC into a Windows Server. Or buy a server. That's a given and cannot be avoided.
Next go to your Office 365 account and go to the Connectors. link yourself to the Flow SQL Connectors. Download, install on your server and test it.
Of course you'll need SQL Server on your server. However, there is another magical product, that's free called SQl Server Express 2017. Download the advanced features version, install and again test from within your server.
Download MS SQL Server Management Studio 18.1 or greater, and use it to import your tables from Access into SQL Server. I doubt your database is bigger than 10GB, which is the limit of SQL Server Express. Most businesses are using databases less than 5GB in size, so you should be ok!
You cannot and should not continue to try and connect or use Access really. You're going to have to invest the time exporting all the tables, queries, reports, and macros into SQL Server using tools, SQL queries, Reporting Services, and Stored Procedures respectively, so there is a learning curve.
ps: If your buy the full SQL Server version, you get a feature called Linked Server, which allows you to connect Access databases, and other databases to your SQL Server database. That would be "possibly" the only way to link your Access database with SQL Server. Costly option.
Here is a similar question and similar answer.
I often use Access and link it to my SharePoint list that are also used in PowerApps and Flow. I started in Access so I can build queries and reports much faster there than I an anywhere else.
It will be read-only in access unless you do an append query but even then it will not write back to the SharePoint list (unless I just haven't figured out how).
But I use Access to monitor a lot of my apps. Stuff like I know an item should not be on list 2 without also being on list 1 so I run queries to check that type of stuff. I also have one app that they enter the data into a phone app (which saves on SharePoint) and they need to be able to print a final report and they do it in Access.
So I guess Yes, but not how you are used to using it.