Premium Only Content

Leverage SQL Server Views in PowerApps
Leveraging the greater power of the SQL Server database engine
In Part 4 you learn how to use the greater data logic and data manipulation power of the SQL Server engine to shape data for display in an interface. Although this example is relatively simple, it illustrates the principle that you should try to use the SQL Server (or other database engine) to perform data logic tasks whenever possible. Save the interface resources for tasks related to displaying the information.
I explain the design of the view which is used to populate a collection in the PowerApps application and explain why it's a better solution than doing the data lookup and concatenation directly in the interface.
If you can't connect to the internet, how do you create an online, searchable database for a research library?
The LTF Searchable Catalog is a full-featured app which can be supplemented with an Access desktop interface. Because of the unique environment and restrictions in the LTF museum, the interface must run on a cellular-enabled device, i.e. a tablet or smart phone.
-
LIVE
Matt Kohrs
11 hours agoLive Trading Futures & Options || Stock Market Open
611 watching -
LIVE
Wendy Bell Radio
4 hours agoWhat A Long, Strange Trip It's Been
7,667 watching -
LIVE
LFA TV
12 hours agoLIVE & BREAKING NEWS! | THURSDAY 10/16/25
4,466 watching -
2:02:00
Game On!
18 hours ago $1.08 earnedTwo 40 Year Old QBs BATTLE It Out On Thursday Night Football!
11.7K2 -
1:22:45
Tucker Carlson
12 hours agoTucker & Steve Bannon on Jay Jones’ Desire to Genocide Republican Kids and the Future of the Right
113K175 -
12:21
Ken LaCorte: Elephants in Rooms
18 hours ago $1.88 earnedWill Trump Take Greenland?
14.7K14 -
36:57
RiftTV
11 hours agoPREMIERE: DC Dive with Jordan Conradson | Guest: Ben Bergquam | Pilot Episode #1
29.8K5 -
8:35
Faith Frontline
13 hours agoAndrew Huberman Just SHOCKED The World With His Belief in God
15.9K8 -
1:59:43
BEK TV
1 day agoTrent Loos in the Morning - 10/16/2025
24K3 -
1:58:09
Dialogue works
2 days ago $4.58 earnedLarry C Johnson & Paul Craig Roberts: Can peace be imposed on Israel? - Russia and China Step In
43.4K17