Access

[Deleted]

Hi.

From an AWB App, online, if you click the gear botton (top right) , there is a new command "Export to SharePoint Lists"

 

this creates a subside with the name as in App name, creates tables with relashionships as in AWA App, and copies (i think copies) the data.

this has been the first signal of life of AWA development team since years. i wish this is serious and wish see linking not copying to sharepoint lists, plus tens of other new fearures in AWA.

[#2]

unfortunately... this sign of life is only for killing Access Web Apps!

https://techcommunity.microsoft.com/t5/Office-Retirement-Blog/Updating-the-Access-Services-in-ShareP...

[#3]

Have noticed. I didnt want to delete thsi "stupid post" as to show some of the shock many users are feeling. The time we were waiting/promissed of a nice surprise, they are shutting down AWA..

[#4]

I did this now my access web app database is stuck in read only mode. Has anyone else had this problem?

[#5]

As it looks like Access Web Apps support is not enough for many use cases: You can keep your Access Web App tables or views (based on SQL Azure) connected and in sync (one-way or even two-way) with any SharePoint list (and 100+ other data sources including any local SQL database) using 3rd party sync tools.

No changes required in the data source or destination. The tool runs as a Windows Service locally or in Azure.

Thanks, Frank

[#6]

I already tried what happens when you choose to run that function:

It created a subsite and exported all the data into lists.

Thats it.

If you had a rich AWA where you put a lot of time into development, the
result is very disapointing.

From my point of view also data macros running in the AWA are not considered.

When exporting the data also a list is created showing the single seps of the export process. In my case it ended with an entry stating that there was an error when exporting without any detail on that error.

When trying to enter data into the created lists the lookup fields doesn´t work.

I assumed the export would also create some powerapp to have a better UI and adding Flows to replace the macros. Well, it didn´t.

There is still some time left until AWAs will be deleted by Microsoft. It would be good if the export process could be improved until that day to create something that comes a bit closer to the UX that AWAs offered.