Power Apps LookUp Function

PowerApps LookUp is used in almost every app. And it has a few tricks up its sleeve. So, in this video I try to cover the basics, the thing I didn't know, how it interacts with SharePoint and Dataverse choices, and more. Nothing profound but good skills to have.

[daniellemartineau]

Thank you so much, this is very helpful as I am just learning power apps! Spent a morning trying to figure out why my drop down lookup wasn't working needed .value. Much appreciated!

[hiram]

always good to listen to you shane! thank you so much.

[rivernet]

As an aside, I do appreciate having CC on your videos as I generally watch with sound off. Thanks!

[juansepowerplatform]

Thank you Sensei, always great to look back at the basics. Learned something new, did not know that Lookup can return multiple values on the same Lookup. Usually was doing two lookup functions to do that. 😣

[simonb]

A clear easy to understand tutorial. Thanks Shane.

[gustavobaeza]

Great video!! Nice background!! I will try to use this to bring the records that are due within 30 days from today...

[latrobe]

Another great one Shane. Point of clarification. You say the First is not delegable which is true, but I thought that as Filter is and as long as the the Filters operators are delegable, then First() will return the result required

[salahsaleh]

Hi, Thank you for the video. Learnt a lot. Honestly all the powerapps I learnt its from all your videos. Thank you

For this lookup video in reduction parameter (third parameter), can you use more complex columns like Users/people, choice, Yes/No, look up columns. Thanks

[markconnor]

Hi Shane, how does it work with barcode values. Let's say find a value in column C when the barcode value is between column A and B

[arasbane]

Another great video Mr. Shane. Have you ever made a video to show how to see versions of a SP list column in PowerApps when one has versioning turned on? I find written tutorials online but I can’t get them to work and no one from what I can tell has made a video.

[jameslupton]

Hi Shane, I have several fields on the screen I want to populate from the one lookup. Do I "Set" varRecord and use it or just do lookups on all 4 individual fields? can you show me the syntax of the set and how to use it on the second field?

[rogumbo]

Thank you so much for this. What about if instead of asking the formula to lookup for "Young" I want it to lookup for a value that is inside a Text label? It does not seem to recognize the data/text that is "inside" the text Label. What is inside of the text label is a numeric value

[fredbarnes]

What is the syntax when you are looking up a value in a dataverse table and the column is a lookup column:
Lookup(Audits, Project = "P1234").ID
Where Project is a lookup column into the Projects table.
This gives you the can't compare records, text error

[sdubbya]

Hey Greg, new subscriber here... You videos are great! I followed your combobox video to use a choice box to auto fill in a form. My problem is the dropdowns wont come in with the .selected etc... how should I go about formatting the dropdowns to pull from the combobox...btw I am using Dataverse tables and canvas app

[Jonathan-oblx]

Hi Shane, what if i want to get the value of a choice which is being used in a drop down list? how can i use lookup function for that?

[Drew]

Shane, hi! Is there a way to make a hash with texts? Concatenate two texts, for example and create a hash? In the documentation I can't find anything that can help me. Do you have any tips?

[tomasgazsi]

Another amazing video! Please Shane, can you give me advice how to solve problem in form. I have SP list with vehicles which have serial number and owner of vehicle (columns). In another SP list i have information about deliveries. In deliveries I've saved information about serial number of vehicle (lookup column into vehicles). But in new form I want show in dropdown controler only cars of some owner. I think it is conditional dropdown controller. Can you give me some advice or your webinar or documentation. Thanks

[mustang]

Shane, Because there are weird things to deal with when using a choice type field within Salesforce what I have been doing is where a choice would be using a plain text field and creating a separate list to house my choices. So the values of a dropdown would be a separate list and the value selected would be entered into a text field in a different list. Now I am wondering if this is the best approach. The other reason I do this is so that I can add values to the Choice list and have a column for active which means I don't have to edit the App to add or remove choices as they need to be changed, to me this makes maintenance a bit easier. Wondering of you have any thoughts on this?

[harshadamagar]

Hi Shane, Thank you for the wonderful videos as always. Can you please make one video on difference between search, filter and lookup function in Powerapps. Thanks again! Love from India 😊

[tonya]

Is there any way to join two lists or tables based on a common id? For example, have a gallery present all the records from table B that match table A like a list of students for this semester and all the current classes for this semester where the student list has the class ID and a gallery would Sort by Columns by Class and show students, next class, show the students, etc.