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.
-
1:03:06
BonginoReport
4 hours agoLyin’ Jimmy Kimmel Faces The Music - Nightly Scroll w/ Hayley Caronia (Ep.137)
99.8K47 -
55:40
Donald Trump Jr.
8 hours agoThe Warrior Ethos & America's Mission, Interview with Harpoon Ventures Founder Larsen Jensen | Triggered Ep275
49.7K51 -
1:12:08
TheCrucible
4 hours agoThe Extravaganza! EP: 39 (9/18/25)
99.1K14 -
1:21:41
Kim Iversen
6 hours agoNick Fuentes Denies Israel Killed Charlie Kirk | Right-Wing CANCELS Jimmy Kimmel
44.3K201 -
1:01:59
Candace Show Podcast
4 hours agoEXCLUSIVE! Another Photo Of Tyler Robinson | Candace Ep 238
100K311 -
2:21:09
Redacted News
5 hours agoWhat are they hiding? New video evidence in Charlie Kirk's Shooting SHAKES FBI'S case | Redacted
160K317 -
41:53
Kimberly Guilfoyle
7 hours agoCharlie's Legacy and Our Mission
57.6K10 -
1:07:55
vivafrei
6 hours agoJimmy Kimmel Out Indefinitely! Trump "Srubs" Study on Right Wing Violence? Clinton Tweet & MORE
222K88 -
1:35:02
The Quartering
7 hours agoNuclear Fallout From Jimmy Kimmel Firing, New Head Of TP USA, Obama Whines
243K75 -
23:35
Jasmin Laine
5 hours ago“We Were Betrayed”—Carney HUMILIATED As His Base REVOLTS Against Him
48K27