Home

I can sense a signal of life in Access Web Apps

%3CLINGO-SUB%20id%3D%22lingo-sub-57546%22%20slang%3D%22en-US%22%3EI%20can%20sense%20a%20signal%20of%20life%20in%20Access%20Web%20Apps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-57546%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20an%20AWB%20App%2C%20online%2C%20if%20you%20click%20the%20gear%20botton%20(top%20right)%20%2C%20there%20is%20a%20new%20command%20%22Export%20to%20SharePoint%20Lists%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20836px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F12489iB726DB6ED274E771%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22AWA%201.png%22%20title%3D%22AWA%201.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20creates%20a%20subside%20with%20the%20name%20as%20in%20App%20name%2C%20creates%20tables%20with%20relashionships%20as%20in%20AWA%20App%2C%20and%20copies%20(i%20think%20copies)%20the%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20has%20been%20the%20first%20signal%20of%20life%20of%20AWA%20development%20team%20since%20years.%20i%20wish%20this%20is%20serious%20and%20wish%20see%20linking%20not%20copying%20to%20sharepoint%20lists%2C%20plus%20tens%20of%20other%20new%20fearures%20in%20AWA.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-57546%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%20Web%20App%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%20Web%20Database%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-80440%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can%20sense%20a%20signal%20of%20life%20in%20Access%20Web%20Apps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-80440%22%20slang%3D%22en-US%22%3E%3CP%3EI%20already%20tried%20what%20happens%20when%20you%20choose%20to%20run%20that%20function%3A%3C%2FP%3E%3CP%3EIt%20created%20a%20subsite%20and%20exported%20all%20the%20data%20into%20lists.%3C%2FP%3E%3CP%3EThats%20it.%3C%2FP%3E%3CP%3EIf%20you%20had%20a%20rich%20AWA%20where%20you%20put%20a%20lot%20of%20time%20into%20development%2C%20the%3CBR%20%2F%3Eresult%20is%20very%20disapointing.%3C%2FP%3E%3CP%3EFrom%20my%20point%20of%20view%20also%20data%20macros%20running%20in%20the%20AWA%20are%20not%20considered.%3C%2FP%3E%3CP%3EWhen%20exporting%20the%20data%20also%20a%20list%20is%20created%20showing%20the%20single%20seps%20of%20the%20export%20process.%20In%20my%20case%20it%20ended%20with%20an%20entry%20stating%20that%20there%20was%20an%20error%20when%20exporting%20without%20any%20detail%20on%20that%20error.%3C%2FP%3E%3CP%3EWhen%20trying%20to%20enter%20data%20into%20the%20created%20lists%20the%20lookup%20fields%20doesn%C2%B4t%20work.%3C%2FP%3E%3CP%3EI%20assumed%20the%20export%20would%20also%20create%20some%20powerapp%20to%20have%20a%20better%20UI%20and%20adding%20Flows%20to%20replace%20the%20macros.%20Well%2C%20it%20didn%C2%B4t.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20still%20some%20time%20left%20until%20AWAs%20will%20be%20deleted%20by%20Microsoft.%20It%20would%20be%20good%20if%20the%20export%20process%20could%20be%20improved%20until%20that%20day%20to%20create%20something%20that%20comes%20a%20bit%20closer%20to%20the%20UX%20that%20AWAs%20offered.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-73642%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can%20sense%20a%20signal%20of%20life%20in%20Access%20Web%20Apps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-73642%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20it%20looks%20like%20Access%20Web%20Apps%20support%20is%20not%20enough%20for%20many%20use%20cases%3A%20You%20can%20keep%20your%20Access%20Web%20App%20tables%20or%20views%26nbsp%3B(based%20on%20SQL%20Azure)%20connected%20and%20in%20sync%20(one-way%20or%20even%20two-way)%20with%20any%20SharePoint%20list%20(and%20100%2B%20other%20data%20sources%20including%20any%20local%20SQL%20database)%20using%203rd%20party%20sync%20tools.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENo%20changes%20required%20in%20the%20data%20source%20or%20destination.%20The%20tool%20runs%20as%20a%20Windows%20Service%20locally%20or%20in%20Azure.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%20Frank%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-72175%22%20slang%3D%22en-US%22%3ERE%3A%20I%20can%20sense%20a%20signal%20of%20life%20in%20Access%20Web%20Apps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-72175%22%20slang%3D%22en-US%22%3EI%20did%20this%20now%20my%20access%20web%20app%20database%20is%20stuck%20in%20read%20only%20mode.%20Has%20anyone%20else%20had%20this%20problem%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-59414%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can%20sense%20a%20signal%20of%20life%20in%20Access%20Web%20Apps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-59414%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20noticed.%20I%20didnt%20want%20to%20delete%20thsi%20%22stupid%20post%22%20as%20to%20show%20some%20of%20the%20shock%20many%20users%20are%20feeling.%20The%20time%20we%20were%20waiting%2Fpromissed%20of%20a%20nice%20surprise%2C%20they%20are%20shutting%20down%20AWA..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-59339%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can%20sense%20a%20signal%20of%20life%20in%20Access%20Web%20Apps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-59339%22%20slang%3D%22en-US%22%3E%3CP%3Eunfortunately...%20this%20sign%20of%20life%20is%20only%20for%20killing%20Access%20Web%20Apps!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FOffice-Retirement-Blog%2FUpdating-the-Access-Services-in-SharePoint-Roadmap%2Fba-p%2F57148%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FOffice-Retirement-Blog%2FUpdating-the-Access-Services-in-SharePoint-Roadmap%2Fba-p%2F57148%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

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.

 

 

5 Replies

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

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

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

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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies