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 ] )
@ShanesCows
3 жыл бұрын
Thank you for the time stamp work. Do you mind if I put them in the description for everyone?
@ArohShukla
3 жыл бұрын
@@ShanesCows definitely Shane!!
@Worrelpa
3 жыл бұрын
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
@ShanesCows
3 жыл бұрын
Always happy to make Phil's life better.
@jarrettheredia
3 жыл бұрын
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!
@ShanesCows
3 жыл бұрын
Fantastic! That was exactly my hope! Thank you for sharing.
@causaposer
3 жыл бұрын
Thanks for the simple and clear narration
@ShanesCows
3 жыл бұрын
You're welcome!
@mattmauren9287
3 жыл бұрын
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.
@ShanesCows
3 жыл бұрын
Thanks Matt. Hope to see you there.
@kearley8792
2 жыл бұрын
Thank you, @Shane Young This really straightened up some misconceptions I had.
@ShanesCows
2 жыл бұрын
Awesome! That was my goal. :)
@chintandd
3 жыл бұрын
thats great video. I was really wondering when I see red line always working in PowerApps. Its clear now.
@ShanesCows
3 жыл бұрын
Glad you liked it!
@evangelizarEC
3 жыл бұрын
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!
@ShanesCows
3 жыл бұрын
Thanks, will do!
@Blade007Mega
3 жыл бұрын
Beautiful video! Can you please do the same analysis of the Dataverse structure?
@ShanesCows
3 жыл бұрын
Good idea. 😀
@jimfitch
3 жыл бұрын
Great lesson, Shane. My suggestion for explaining database in context of this video: a database stores tables (and other objects).
@ShanesCows
3 жыл бұрын
Thanks Jim!
@powermond
2 жыл бұрын
This was really helpful. Thanks!
@ShanesCows
2 жыл бұрын
You're welcome! I wish everyone would watch this one. Power Apps is so much easier when you know the difference. :)
@jray1429
3 жыл бұрын
Thanks a bunch Shane, this was very helpful.
@kaboodleworld
3 жыл бұрын
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... :(
@patriciazysk6651
2 жыл бұрын
Shane Young is my very best friend!
@ShanesCows
2 жыл бұрын
Thanks Patricia. 🐶
@anthonjhnon1
3 жыл бұрын
I need help with tables inside a record. Do you have a video on that?
@ShanesCows
3 жыл бұрын
Look to the Concat function to turn that table data into text. kzitem.info/news/bejne/oqR7uJp9gndpmqw
@anthonjhnon1
3 жыл бұрын
@@ShanesCows I watched your other video and I'm even more confused. Is that a discord, junk email, or something I can send you what I'm dealing with. I'm learning more as I try to figure this out but getting frustrated at the same time.
@kearley8792
2 жыл бұрын
@@ShanesCows Isn't that kind of a workaround? It just feels like one. If this is the only way to trick PowerApps into giving you what you need, I can be comfortable with that, but workarounds just make me nervous. :) I am wondering about this because I am faced with a similar problem and so far, "tricking" PowerApps is the only way I've found that works. Isn't there a command or function for the specific purpose of turning table data into text?
@ShanesCows
2 жыл бұрын
@@kearley8792 Concat does just that. Turns table data into Text. Am I missing somethign?
@jhhatcher1885
2 жыл бұрын
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???
@ShanesCows
2 жыл бұрын
What about CountRows(Filter(query that you used in Items property of data table)) as a work around. Remember though CountRows is not delegable.
@khalidmullawns
3 жыл бұрын
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
@RTmusicLtd2020
2 жыл бұрын
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.
@Fonzyrr
Жыл бұрын
Share is GOATED
@ShanesCows
Жыл бұрын
Thanks. And look at you at that track day! I used to race many years ago. Loved it so much!
@sundrapillay6668
3 жыл бұрын
Thank you Shane
@ShanesCows
3 жыл бұрын
Happy to help Sundra! 🐶
@shaantoshholaay3310
3 жыл бұрын
Superb Sir
@ShanesCows
3 жыл бұрын
Thank you! 🙏
@brojermo
Жыл бұрын
Hi Shane. Is there a video that deals with storing tables as values in tables?
@ShanesCows
Жыл бұрын
I don't have one of those directly BUT I do have one that shows it. kzitem.info/news/bejne/w2p8yGltjqV7f34 When you save a SharePoint Multi-Choice column it is a table. So that video should help.
@doointhedoo
Жыл бұрын
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!
@ShanesCows
Жыл бұрын
Post the formula you are fighting with and I will try to fix it.
@billkuhn9886
3 жыл бұрын
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?
@ShanesCows
3 жыл бұрын
The column name is different based on how the table got created. Like Distinct puts out a single column table with the column named Result. Split makes a single column table of Value. It is just a name the function spits out, doesn't affect anythign else. :)
@amrabuelkhair9052
10 ай бұрын
Hi , have created a gallery and added lookup function on label , how to filter gallery based on look up function result
@ShanesCows
10 ай бұрын
You cannot directly. You can AddColumns to the table where you do the LookUp. Then filter that table by the new column. This will not be delegable and will have performance challenges but will work.
@gouthamarul3848
4 ай бұрын
Hi , I have json collection.. will it possible if I pass json without selecting field it should populate table structure
@ShanesCows
4 ай бұрын
Check out this video on using JSON function kzitem.info/news/bejne/qGyau2mjnmeZZKQ
@paumason
3 жыл бұрын
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?
@ShanesCows
3 жыл бұрын
A choice field is stored as a record. So a record inside a record. Type choicefield. And it should show you the value to see the text.
@Ikertxu5
3 жыл бұрын
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?
@AssassinUK
3 жыл бұрын
Why 2 lists if they are holding the same type of data? ... Just create one list and add an extra field and use that field to flag whether it is reserved or not. 2 lists are not needed based on your stated requirements.
@Ikertxu5
3 жыл бұрын
@@AssassinUK the first have information about what is every item and how many in stock and the second one where the items are going (clients) and date required
@AssassinUK
3 жыл бұрын
@@Ikertxu5 See, this is an extra requirement not stated in the original statement. If it's one type of item going to many clients, then yes, 2 lists will be required. Just stick a FK (foreign key) in the 2nd list with the clients. No data on the items should be in the 2nd list other than the FK.
@ShanesCows
3 жыл бұрын
Thanks for the assist Simeon 🐶
@anthroparion
3 жыл бұрын
IsBlank and IsEmpty - that got me for a whole of day - the price you pay for not reading what's on the screen properly.
@ShanesCows
3 жыл бұрын
That is the fun of this stuff. As you learn more it gets easier 😎
@npschre
3 жыл бұрын
I swear, you're looking at my search history and making videos based off it.
@ShanesCows
3 жыл бұрын
Maybe 😁
@rivernet62
3 жыл бұрын
Creepy, ain't it?
@npschre
3 жыл бұрын
Very. Lol
@Saadssk94
3 жыл бұрын
how did you manage to add pictures in your face field?
@ShanesCows
3 жыл бұрын
It is a HyperLink column set to picture in SharePoint.
@kyrstincote637
2 ай бұрын
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),"$#,###")
@ShanesCows
2 ай бұрын
If Cost to Replace2 is a Label then it should be .Text Text(Value('Cost to Replace2'.Text),"$#,###") Visible is returning true because it is the property to show the control :)
@kyrstincote637
2 ай бұрын
@@ShanesCows Unfortunately, when I update that, it says it cannot be converted to a number. It also isn't a label. I appreciate the reply, in any case!
@TheToni2123
3 жыл бұрын
Thx
@ShanesCows
3 жыл бұрын
Any time
@lucas86999
3 жыл бұрын
👍
@ShanesCows
3 жыл бұрын
🐶 say 🙏
@CristianLopez-qd3qb
2 жыл бұрын
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
Пікірлер: 79