Home

I can sense a signal of life in Access Web Apps

Highlighted
Yahya Manasrah
Occasional Contributor

I can sense a signal of life in Access Web Apps

Hi.

 

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

 AWA 1.png

 

 

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.

 

 

  • Access
  • Access Web App
  • Access Web Database
  • Office 365
  • SharePoint
5 Replies

Re: I can sense a signal of life in Access Web App...

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...

 

Re: I can sense a signal of life in Access Web App...

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..

RE: I can sense a signal of life in Access Web App...

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

Re: I can sense a signal of life in Access Web App...

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: http://www.layer2solutions.com/en/community/FAQs/cloud-connector/Pages/Access-App-SharePoint-Online-...

 

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

 

Thanks, Frank

Re: I can sense a signal of life in Access Web App...

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.

Related Conversations
Snapshot of Access Web Database for Legal purposes
Gregory Frick  in  Access  on
5 Replies
AAD PowerShell Commands not working (get-msol ...)
Ivan Unger  in  Azure Active Directory  on
14 Replies
Conditional policies in Azure AD vs. Intune
Robert Woods  in  Microsoft Intune  on
8 Replies
Word online Templates
James Simmonds  in  Office 365  on
4 Replies