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:00:14
BonginoReport
3 hours agoSpeech Police Bondi Under Fire - Nightly Scroll w/ Hayley Caronia (Ep.135)
128K73 -
LIVE
Heart & Mind with Dr. Dina McMillan
7 hours ago"Heart & Mind with Dr. Dina McMillan: Episode 57 - Honoring Charlie Kirk - Where to from Here?"
39 watching -
1:01:26
The Nick DiPaolo Show Channel
5 hours agoTrans Network Being Investigated | The Nick Di Paolo Show #1794
25.6K30 -
22:53
The Rubin Report
3 hours agoMegyn Kelly Visibly Shocks Dave Rubin with Her Dark Prediction for What Happens Next
31K59 -
LIVE
Edge of Wonder
2 hours agoAlien Creature With Tentacles Growing on Meteorite Claims Panama Man
202 watching -
1:04:35
TheCrucible
3 hours agoThe Extravaganza! EP: 37 (9/16/25)
135K30 -
1:08:14
Kim Iversen
4 hours agoKash Patel: 'There's NO EVIDENCE Epstein Trafficked Anyone' | Did Bill Ackman Threaten Charlie Kirk?
43K82 -
2:15:14
Redacted News
4 hours ago"They knew about Charlie Kirk's shooting BEFOREHAND" FBI in total "Kash" Out and Damage Control
135K311 -
1:18:57
Candace Show Podcast
4 hours agoCharlie Kirk Shooting Suspect Charged. Something Isn’t Right… | Candace Ep 236
80.6K288 -
1:20:45
Dr. Drew
8 hours agoZachary Levi: The Truth About Charlie Kirk, Secret Conservatives Of Hollywood & Why He's Building A $100m Film Studio In Bastrop, TX w/ Batya Ungar-Sargon of NewsNation – Ask Dr. Drew
43.7K7