PowerApps SQL LookUps and Relationships

In this video, you will learn about setting and using PowerApps SQL Lookups and Relationships. If you have a proper key structure in SQL and you need to learn how to make it work in PowerApps then this is the video for you.

[joseluisbeltramone]

Thank you very much, Shane. In a short video, you summarized all important issues about using joined tables. Great work!!

[narmiazar]

Loved your video, was struggling with exactly this. Was impressed that you had this up 3 years back. Thank you.

[ammarhaider]

Awesome man! these little things are sooo important and not found anywhere else! Thanks for having a video on this!

[ajingar]

Hi Shane, excellent video - got an example working myself, so really chuffed with that - thanks.

[AssassinUK]

Shane #MayHisNameBeBlessed Young, thanks a lot! I had got something working but it was a Filter, within a Distinct, within a Filter again, Within a distinct again, withing a Concat for a label, it worked but looked messy and I was sure there was a cleaner way and after watching the video I used a Lookup function, within a lookup function and got my result in one

I suggest doing a small video of doing a lookup within a lookup (and maybe within a lookup again) to show how deep you can go in a DB to get a name for an ID as depending on how normalised a DB is. If you have to go 2, 3 or 4 tables deep to get that name for an ID, you will have to go 2, 3 or 4 nested lookups deep to do that. A video showing this in detail would help many I think. Thanks again!

[waynedalton]

Shane, this caused me many weeks of headaches. Thanks for this video!

[PeterAJHowell]

Very clear description of adding SQL to PowerApp, good for newbies.

[KI_Burgberg_DE]

Thanks for this video. Very helpful. I am just struggling with your new "blank" record. I do not know if this is useful in a DB environment. Sometimes you have in your master table no key maintained for a record in the detail table. Then you need to show a blank entry in the combobox. No idea how to do.

[tobypage]

Great video. Any advice on doing this with many to many relationships using a SQL link table please?

[mavoldnl]

Thnxs Shane, this works great. Now I tried to use a singleline combobox instead of the dropdown. The update is working but the default value stays empty. (Testing the default formule in a text label does work, so the formule is good) Any tips about replacing a dropdown to a combobox?

[torgeirkind]

Hi Shane. You are a legend. Been looking at videos for the past couple of days. I know this video is old and I had a comment/question that I just figured I would fire off and also give you some kudos.
In the drop down. Do you need to have a record ID 3 in the sql table that has a blank value. Cant you just set it to ""? The blank option now shows up the dropdown which is not a valid option i presume as a user should not be able to enter a blank customer as it screws up your realtion between tables. Also maybe adding a check on save to checks that all values such as customer name, project and status can not be blank. I had a sql where similar values did not allow null by my design and i press save in app I made and figured it would be saved, but it did not as my table did not allow null. I of course knew that but making sure that a user cant enter invalid data seemed like something i could and should handle on a save button. There is probably many ways to have a good pattern for this mechanics whise and most likely something that you cover in the next 60 or so videos that you have posted since this video.
I think i would have added an option called "not selected" or "not sure" or something that sort of lets my user add say I dont know the customer, allthough i most likely would have prevented not selecting it in the first place.

[sokgat]

Thank you for the video. Looking forword for series of videos with SQL+PowerApps!!!

[sconsalter]

That's what I'm looking for! Thanks Shane!

[ewanstevenson]

Shane, first of all thanks for your videos. I'm just starting out and they are invaluable. However I cannot get the equivalent relationship Lookup working for two SharePoint lists Players and Teams with TeamID as primary/foreign key. Everything I tried redlines with an error as I use your syntax on your Lookup statement. Do you have a SharePoint list relationship video, with proper ID's not just names? Or the equivalent syntax? I will move to CDS, SQL for my personal stuff but my colleagues at work still use SP lists so would be really useful to do it here as well. Thanks. Ewan, London, UK

[petersmith]

Super helpful video. Thank you very much. In fact, this is my 3rd video learning from you. All very helpful. Now knowing the basic concept of it, I am going to see if same can be applied to Excel . We are even poorer, can only use Excel as data source. Again, thank you very much.

[Carpaltunnelgadgets]

Hi Shane, can you make a video on editing powerapp templates? For example using the Budget Tracker, I want to add a date picker for each expense, and an option to input a negative value because I'd like to design an app that can buy and sell.

[naoiiche]

Hi Shane,
I agree that SQL is probably the best datasource for real robust productions apps. One of the main advantage is how it deals with delegation, which is one of the most important concern when building apps.
In this video you are using the ShowColumns function which is not delegable. How would you deal with that ?

[weeklyclose]

thank you so much ... that was exactly what I was looking for ...

[crsolutions]

Hi Shane, thanks for the video.. I have app that uses the barcode scanner to read a barcode which in essence is a "ItemID" from a SQL Table, the value is then being passed to a global variable. I then want to lookup the actual Description from the same sql table based on the ItemID and populate this into a text box.. Barcode scanner is reading the data and passing it to the variable from what i can see, however the lookup function i am not having much luck. My formula for the lookup is

LookUp(StockItem, ItemID=Value(ScannedValue), Name)

Stockitem -being the sql table which is a datasource

ScannedValue = Global Variable

Name = Being the Description that i want to pull.

Any help would be appreciated. 🙂

[dusansavkovic]

Awesome video Shane! Valuable information but I still missing something. I have 2 SharePoint lists so I’m using 2 different forms. On the parent form I created a button that navigates to child form and what I would like is to edit information from a child form that correlate to parent form. Can you help? Thank you