Power Apps Tables vs Records vs Fields 

you are are so awesome Shane 1. 3:10 Table, Record, Column, Value 2. 6:13 Office 365 User Connection Item’s Property - TABLE 3. 9:00 Button’s OnSelect {} - TABLE 4. 10:13 Creating TABLE with square brackets [] 5. 13:00 Gallery and how RECORDS are used 6. 14:06 Gallery’s OnSelect, ThisItem is a RECORD 7. 15:40 Records can exists within RECORDS 8. 16:57 Retrieve FIELD value from Gallery 9. 18:00 FIELDS have different types 10. 22:45 FIRST function accepts Table, First( Table ), FirstN( Table [, NumberOfRecords ] ) LastN( Table [, NumberOfRecords ] )

I struggle with this from time to time as I'm not in Powerapps all day long. So for me getting back in there I sometimes lose the linkage. I have worked with databases for years, but getting that syntax right is what I usually struggle with. Thanks Shane

Thank you Shane! This video did exactly what you wanted...I knew all these terms individually but you drew the map to bring them all together and use that to change how I approach building PowerApps. Awesome!

coming in HOT with another great video, sir. You're getting better and better at distilling things down as you keep cranking these out. Keep up the great work. Heading to your site to see about this upcoming LIVE CLASS.

Great resource Shane. If I go back a year in time, this would have been so helpful :-) . Keep up the great work, it will be a great resource for newcomers to the PowerApps world!

Great lesson, Shane. My suggestion for explaining database in context of this video: a database stores tables (and other objects).

Hey Shane. Excellent channel. I have a question / challenge for you. Say you have a table containing musical competency. Columns headings are musical instruments e.g. guitar, trumpet, piano. The records are the name of students. The values are their competency at those instruments e.g. 1 = expert to 5 = beginner. I need a power app where someone can choose firstly the instrument in a drop down e.g. guitar, then a skill level in another drop down e.g. 3 then we get a list of all the students who can play guitar at skill level 3 or better i.e. 1,2 or 3. I can do this in excel vba, or with excel pivot table. However am struggling to do this in power apps. The musical competency table would be in SharePoint.

Beautiful video! Can you please do the same analysis of the Dataverse structure?

Thanks for the simple and clear narration

Great video Shane. Have you seen the .Result property or column (whatever it is 😀). I get the .Value is a single column Table where the column name is “Value”... is it the same with .Result?

thats great video. I was really wondering when I see red line always working in PowerApps. Its clear now.

Hi Shane - don't know if you will ever see this, but I am having issues counting the number of items in a filtered data table - I see how to do it in a gallery, but now a table???

Great video and appreciate covering so many scenarios. Just one thing that i have come across and struggled with. Using the last method of 'in' with cascading combo-boxes. When I load the edit form, for some reason the dependent combobox does not automatically pick items based on parent combobox selection... :(

Hi Shane! First of all Congratulate you on Keep creating Value Content for POWERAPPS Second of all I'm trying to create something like a warehouse management where I have to lists One with Items in Stock and the other one With Items already reserved, but I'm not able to do the math between the TWO lists.... any guide?

Hi Shane With referring to most of your videos, i was able to create nice power apps and flows.Thank you for the same. I am now stuck on how to filter data table linked to SharePoint to show unique values in powerapps. Everytime a user submits in power apps the SharePoint list gets added with duplicate values. I want SharePoint to show duplicate but in power apps for usee it should unique values in data table which he can select. Sorry for long information. but hope i was able to specify what i am stuck at

Shane, the biggest issue I ALWAYS have it table to text type mismatch errors. If I want to do a filter based on a result from a drop down it's ALWAYS a table to text error. What can be done for this intermediary conversion? it's driving me insane!

Hi Shane. Is there a video that deals with storing tables as values in tables?

This was really helpful. Thanks!

Hi , I have json collection.. will it possible if I pass json without selecting field it should populate table structure

Thank you, @Shane Young This really straightened up some misconceptions I had.

Thank you for this video! excelent! but I stil have a problem with choice field. specifically when it is from a field of type person. My canvas thorw error always. any idea?

Shane Young is my very best friend!

I need help with tables inside a record. Do you have a video on that?

Hi , have created a gallery and added lookup function on label , how to filter gallery based on look up function result

Hey there Shane, Wondering if you may have any thoughts on a table control that comes in as a text type. When I try to make the FieldType to look like currency, it doesn't give an error, but also doesn't make the data into currency format. This is what my formula is in the FieldType...(again, it is in a Table in the Power App, and it is a control/column "Cost to Replace2". The source data is currency.)... Text(Value('Cost to Replace2'.Visible),"$#,###")

Thanks a bunch Shane, this was very helpful.

how did you manage to add pictures in your face field?

Share is GOATED

Superb Sir

Thank you Shane

IsBlank and IsEmpty - that got me for a whole of day - the price you pay for not reading what's on the screen properly.

I swear, you're looking at my search history and making videos based off it.

Thx

👍

Bro you are crack!! but I am stuck in a problem, I am using choices in a combo box since I have a look up field, the thing is that I want this combo box to be prepopulated with the last record in the sharepont list, I wrote this formula "Filter(Choices(SampleLog8kDef.Batch_ID);Id=Max(Id)" but then it returns in the combo box the first record not the last, I hope you can maybe help me thanks