Premium Only Content

My Hybrid Shopping List -- "Interim" Collections and Persisted Tables- Revised
During final prepping of the previous version, I botched part of the video. Corrected in this version.
====
This video is Part Four of a four-part series:
Part Four explores two functions needed to make the Shopping List work:
-- Persisted tables in the SQL Azure database to retain the current shopping cart between sessions
and
-- The Patch() command for both data insertion and data update.
We wrap up with a look at the final step: moving purchased items from the shopping cart to the permanent database tables in Access.
Part One introduces the concept of Hybrid Access/PowerApps applications and explains why Access developers need to learn more about this approach.
Part Two lets you experience the PowerApps interface, running in a browser. It explains the concept of PowerApps collections -- which can be compared to temporary, in-memory tables.
In Part Two, the emphasis is on using a collection to retrieve a mirror image of a table in the SQL Azure database to improve performance with large recordsets and minimize calls to the server for data.
Part Three explores Filtering and Searching a Collection to return the minimum number of records from that collection to the Items in a Gallery. The final step is Sorting the remaining, filtered set of records for the Gallery. Two approaches to filtering are shown and compared for verbosity and performance.
-
LIVE
Lofi Girl
2 years agoSynthwave Radio 🌌 - beats to chill/game to
189 watching -
2:17:05
FreshandFit
4 hours agoFrom SMALLVILLE to AB'SVILLE w/ Sam Jones III
118K4 -
3:05:45
Price of Reason
10 hours agoTrump's UN Takedown! BACKLASH Over Disney's Jimmy Kimmel Return! Tulsa King Season 3 Premiere Review
119K16 -
3:03:12
Badlands Media
12 hours agoDEFCON ZERQ Ep. 010: Government Overreach and the Battle for Freedom
162K56 -
9:46
Levi
1 day agoWhy XRP's Bull Run Will Be 10x Bigger Than The Last One - Raoul Pal
4.46K1 -
20:13
Paul Barron Network
26 days ago $0.85 earnedXRP Vault Yields Coming in September!?🔥Flare CEO INTERVIEW
4.96K -
3:00:12
TimcastIRL
7 hours agoJimmy Kimmel Show IN CHAOS Before Return, Affiliates REFUSE, Staff Says THEYLL QUIT
354K106 -
2:49:26
Laura Loomer
7 hours agoEP145: Trump Makes BOMBSHELL Autism Announcement
51.9K19 -
6:14:04
SpartakusLIVE
8 hours agoEXPLOSIVE $400+ 2v2 Tuesday has viewers GLUED to the screen
63.3K2 -
3:19:06
GrimmHollywood
8 hours ago🔴LIVE • GRIMM'S TUESDAY FRIGHT NIGHT • STARRING GRIMM HOLLYWOOD • NO, I'M NOT HUMAN PART 1 •
45.8K2