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
Benny Johnson
1 hour agoChristianity Under Attack: Trump Declares 'Epidemic of Violence' on Christians As Church Shot,Burned
5,693 watching -
LIVE
Nikko Ortiz
57 minutes agoChurch Shooting And Arson Attack In Michigan - Rumble LIVE
174 watching -
LIVE
LadyDesireeMusic
37 minutes agoLive Piano & Convo | Support a Culture Change | Make Ladies Great Again
96 watching -
35:58
Mike Rowe
3 days agoWhat About Jimmy Kimmel? | Hot Takes
9.37K35 -
LIVE
LumpyPotatoX2
1 hour agoDestiny Rising: Gameplay + Industry Talks - #RumbleGaming
49 watching -
LIVE
Badlands Media
8 hours agoBadlands Daily: September 29, 2025
4,170 watching -
1:40:46
Dear America
2 hours agoThe War Is On!!! ICE Invades Chicago And Portland! DEPORT THEM ALL!!
107K101 -
1:57:38
Matt Kohrs
10 hours agoStock Market Open: NEW HIGHS INCOMING?! || Live Trading Futures & Options
17K -
LIVE
Wendy Bell Radio
6 hours agoCan't Stop The Bleeding
7,615 watching -
LIVE
GrimmHollywood
3 hours ago🔴LIVE • GRIMM HOLLYWOOD • SILENT HILL F PART 2 • HARD HARD DIFFICULTY •
74 watching