Using MS Access with PowerApps - PowerApps Tutorial for Beginners

powerappsforne...
It has been said that PowerApps is similar to MS Access.
In reality there is not much to compare the two.
There are many MS Access applications around the globe,
some of which are probably good candidates for converting
to PowerApps. Have you thought about using MS Access with PowerApps?
Is it time for you to convert an Access database to PowerApps?
Organisations always look to the future and at ways to bring their
technology up to date, especially with the possibilities
available in Office 365.
At the moment it is not possible to port MS Access forms over to PowerApps, but there are a few workarounds. For example, you can create an app that connects to MS Access tables. From there, you can then run your usual queries, reports etc within MS Access. This is a good way of using MS Access with PowerApps.
If you want to migrate access database to PowerApps in full then you need to plan out what is possible and what is not. Mail merge of data to say Microsoft Word is not possible.
You may be asking, can PowerApps replace Access?
In this video I will show you a way of using MS Access with PowerApps and how to do this with a SharePoint list.
Do you want to learn more about PowerApps?
Download my FREE PowerApps Book here
powerappsforne...

[@juliamandeville7503]

A couple of questions -
1) How does this work for tables that have lookup fields linked to a table that is strictly a lookup table (for example, a table pre-loaded with specific data of federal benefits [Food Stamps, WIC, TANF] and can have multiple values saved in the same record column
2) How does this work for tables using the attachment data type?
An observation in your sample data - your Paul was hired (1999) the year before he was born (2000)

[@saksaridchangtham1240]

Before I try to looking for how to survival my access database with Power Apps. Thank you very much for your VDO to guide how to do it.

[@paulharding2030]

Are there instructions on how to create the Human resource personnel information management system shown in your video? That is quite well done!!

[@powerappsfornewbies8159]

Hi Paul - sorry for the delay in replying - I don't have instructions, but perhaps I can convert it to Power Apps and post it here

[@gkioto]

I have a question for you: if I want to add another field to the linked table, how would I go about doing that since the linked table won't open in Design View?

[@fredeyrago]

THANK YOU. Does it works if the acces file is not on one drive (drop box) ? Does it works if you have in the table OLE objects that are saved n different folders of you PC?

[@malgorzatawarcholsiczek269]

Hi, I try to recreate it and get an error message at the very beginning:
"An error occurred while creating a SharePoint list. Cannot find property"

[@jeromecantonnet3047]

I have the same problem, I tried many time. Any idear ?

[@maximilianomartinez925]

Hello, when a new entry is created in power apps is the table in access updated as well? (not only the new table-link that you created) .... thanks!!

[@DIGITAL_COOKING]

Helpful!