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.
-
15:10
SB Mowing
1 month agoShe had TEARS OF JOY on her face - An update on Beth
44K33 -
LIVE
Lofi Girl
3 years agolofi hip hop radio 📚 - beats to relax/study to
339 watching -
2:15:26
Nikko Ortiz
3 hours agoLIVE - Farm Animals Attack!
209K7 -
9:30
Sugar Spun Run
6 hours ago $1.49 earnedBlack and White Cookies
113K2 -
2:45
SLS - Street League Skateboarding
4 days agoManny Santiago's 'THIS IS 40' Part
65.7K2 -
6:40
Homesteading Family
5 days agoNever Make Pie Crust From Scratch Again (Do THIS Instead)
54.9K5 -
44:20
Melissa K Norris
3 days ago $1.03 earnedThe Most Overlooked Way to Preserve Food for Months (No Freezer Needed) w/ Sam Knapp
39.7K1 -
23:00
Tony Jeffries
6 days agoThe Best & Worst Boxing Training Methods (Ranked by Olympic Boxer)
28.9K -
44:44
Scammer Payback
17 days agoCrazy Confrontation with Hacked Scammer Group
50.4K21 -
1:15:13
Steven Crowder
5 hours agoIt Isn't Both Sides: They Crossed The Rubicon When They Killed Charlie
497K465