Thank you Shane, so many great ideas to reuse here. Just for the record, cats are great at their jobs (their job is to sleep all day and annoy the dog, they excel at that)
Shane, great video. *** IsEmpty & IsBlank explanations are very helpful. *** Suggestion for Sort icon & combination with column header label: group icon & label; set icon’s & label’s X, Y, width, & height properties = Parent.property, (e.g., = Parent.X); set icon.PaddingLeft to (say) 10; set label.PaddingLeft to (say) 70 (or whatever looks good) and label.PaddingRight to a formula = Self.Width - Self.PaddingLeft - whatever constant that positions the actual icon image so that it looks good. This allows app maker flexibility during development to resize without needing to manually update properties, but still enables your (Matthew’s) tip to stretch the icon over the column header label to provide a bigger target for OnSelect functionality like changing sort order.
Thank you Sensei. I love all the little details, there is so much 'love' (work) in them. These little details make a lot of difference improving the final user experience. Thanks for such a clean and polished example.
Nice Video. I have a few suggestions. Instead of having the color reference the header color, you could define a color onstart. Set var, maybe call it powerpurple. Then just refer to that wherever you use the color. For sorting, another thing you could do is change the icon based on the current sort order. In the icon field of the icon object: If(varDescending,Icon.ArrowDown,Icon.ArrowUp) Also, I had to setup a lot of galleries for sorting, so I found a more efficient way to set it up. Highlight the icon and associated header at the same time, and set the Tooltip to whatever the actual column name is. Once you've done that for each of the columns, highlight all of the column headers and icons, and set Onselect to use self.tooltip. One identical formula for all icons and column headers. Two things that came up after go-live, make sure you're not resetting the sort order OnVisible, people like their sorting to persist. And I was also asked to add second level sorting (ex First by department then by wage). It wasn't too hard to setup, just use another set of variables and when primary sort changes, push it to secondary sort.
Thanks for another great video Shane! I was able to get the search box expand to work without the additional OnStart variable with a nested If statement on the Width property: If( varExpandSearch, 160 * Timer2.Value / Timer2.Duration, If( And( varExpandSearch = false, Timer2.Value = 0 ), 0, 160 - 160 * Timer2.Value/Timer2.Duration ) ) Like so many "problems" there are multiple solutions. Still need to go back in and rename my timer control:)
Great videos!! Is there a way to highlight when I new item has been added since the user last viewed the gallery? Such as bolding a title or adding an icon?
Great Video again Shane! Thank you! Just a question, I followed your tip on sorting and stored my sort columns as a variable. All are text data types. When I use it in a SortByColumn formula with a FIlter in a gallery, the variable that represents my columns always gets a delegation warning. I have even filtered for just the past 5 days of new items in my gallery and it works fine... only when I add the SortByColumns using a variable am i hit with a delegation warning. If I hard code all of my columns for sorting, I don't get the delegation warning. I based my formula on your sample above: SortByColumns(Filter(myDataSource, Created>=varDateFilter),varSortby,If(varSortOrder, Ascending, Descending))
Hi Shane, love the sort column idea! Quick one, do you know off the top of your head how to sort on a complex column like a SharePoint user displayname?
Not sure. This works SortByColumns(AddColumns(Employees, "Real Name", 'Created By'.DisplayName), "Real Name", Ascending) BUT it is not Delegable. So if your list is large it doesn't help.
Great video. THANK YOU!!!! I am trying to do the following. I have a SharePoint list that has emp names, depts they work for, and some other fields. I want to build a gallery that has Depts as subtitles and then lists emp's names and other fields under the appropriate subtitle. How would you do it? Can you point me in the right direction? Thank you!!!
You are going to get into nested galleries most likely. YOu could use GroupBy function to group on departments. I might make this my Thursday video. Sounds like a good question.
Hello Shane, thank you for these videos. hope you can help me with this doubt: When you use a "date format" in a Excel table for a rear reason Power Apps take it as "Date and time" format instead of just "Date format". Do you know how this can be modified in Power apps or which format choose in excel ?? (I`ve tried almost all the options) hope you can help me
Hello Shane, I am trying to avoid users press a button to run a flow that makes some labels to display data. Is there a way to delay OnChange for a Text Input control?, so once a person finishes typing the text then the flow is run (instead of running the flow every time after every character input). I saw it in one of your videos but can't recall which 😅
Hi Shane, Your videos helped me to achieve lot of complex situations in my work place. The power Apps data model you developed earlier gave me idea to develop user maintainable app but my share Point list has more than 1600 question and I am trying filter these based on the department. please advise me is it possible to achieve and I want create pdf at the end to keep the record. Thanks
@@ShanesCows Truth! In 2020, you have to go with the little things. I've been using Microsoft products since the MS DOS days; how did I not know this? (Not that they've had emojis all that time.) It is certainly something they didn't highly advertise. 🤷♀️
Shane you are amazing and thanks for giving valuable tutorial. I am having a small project to design where there is a sharepoint list with the data of more then 2000 rows of user profiles. I need to check if user details exist in the list or not, If data is there then display on Screen1 and if not need to give him a form to enter basic details like, Birthday, Gender, WorkPhone, HomePhone. Can you share me link if you have made any such video, or can you make small video.
I really like the way you allow user to sort by the selected column. However when I use a variable as the column to sort by, I get a delegation warning. Is that the same for everyone else? Is there a way around this?
Shane Young it’s a weird one because the first time i tried it, I got the delegation warning. But when I’ve used it since it is able to delegate. So ignore what I said; I think it’s probably an issue with the SharePoint column I’m trying to search. Maybe the unique column can’t be delegated but all other columns can
So I played more and I think if you use With for the filtering part you can get rid of delegation problem. Something like this With({X: Filter(Employees,HourlyWage > 1) }, SortByColumns(X, varSortBy, If(varSortOrder, Ascending, Descending))) more playing needs done but at least might give you some ideas. In the video I show Search function that also doesn't delegate but nothing you can do about that.
Hey Shane, amazing video! One question, I have been making some apps, and there is one thing I can't figured out, it's possible to create a table with the same columns as in a list without writing manually?
Hey Shane, I've got some pretty SLICK PowerApps I've designed for myself and some clients that I would absolutely love to share with you. Let me know the best way I can possibly share them with you! Great content and always fun to watch you work! :P
So I played more and I think if you use With for the filtering part you can get rid of delegation problem. Something like this With({X: Filter(Employees,HourlyWage > 1) }, SortByColumns(X, varSortBy, If(varSortOrder, Ascending, Descending))) more playing needs done but at least might give you some ideas. In the video I show Search function that also doesn't delegate but nothing you can do about that.
Top video, as always. I am trying to create a chat style incident logging app, where one incident can have many lines of comment, each saved with a time stamp. I would like my users to see any updated comments and add their own if necessary in near real time, as you would in a chat app, is that possible for multiple users? Many thanks.
Shane, love your videos!. Would you please do one on trapping for errors, like those nasty red ones that appear when you forget to give your users access to all your SharePoints List, DOH! :-) Also, there are these ifError and IsError functions that are "experimental". Should these be used? I think error handling in PowerApps is a topic that has very little content and is well deserving of a video. I hope you agree and can put something out soon to end my suffering through reading (hate to do that :-)). Really want to be able to trap for any errors that I didn't account for in my code that are thrown by the app when things data becomes unavailable, etc. (i.e. things outside my control). Thank you so much!
@@ShanesCows I started doing it for a lot of commonly referred to components X y z etc then youc an change the one variable rather then finding the original reference. It can also be easily changed dependent on client rather then creating a whole new header component.
Hey Yvonne you can download the video and the supporting app by being a subscriber here training.powerapps911.com/courses/video-library lots of fun content.
Hi Shane , Can power apps does the upload file , I have a Upload button in my app ,where on click , it should pick the excel file from my one drive and then the changes should apply on my form. P.S:- Basically we do some internal surveys in our company we have designed a canvas app ,each time for a new survey we will manually keying/editing the question in the form directly ,Instead we decided to have a upload functionality where we upload a excel file which has all our questions and those questions will appear in my app. Can you please reply to this :)
Thank you Shane, so many great ideas to reuse here. Just for the record, cats are great at their jobs (their job is to sleep all day and annoy the dog, they excel at that)
😂🐶😂😍
Shaneeeeeee!!! “Select” function is exactly I am looking forrrrr!!!!!!!! Thanks so much!!!!
Shane, great video. *** IsEmpty & IsBlank explanations are very helpful. *** Suggestion for Sort icon & combination with column header label: group icon & label; set icon’s & label’s X, Y, width, & height properties = Parent.property, (e.g., = Parent.X); set icon.PaddingLeft to (say) 10; set label.PaddingLeft to (say) 70 (or whatever looks good) and label.PaddingRight to a formula = Self.Width - Self.PaddingLeft - whatever constant that positions the actual icon image so that it looks good. This allows app maker flexibility during development to resize without needing to manually update properties, but still enables your (Matthew’s) tip to stretch the icon over the column header label to provide a bigger target for OnSelect functionality like changing sort order.
Thanks for sharing. 😀
Thank you Sensei.
I love all the little details, there is so much 'love' (work) in them. These little details make a lot of difference improving the final user experience. Thanks for such a clean and polished example.
My pleasure!
Nice Video. I have a few suggestions.
Instead of having the color reference the header color, you could define a color onstart. Set var, maybe call it powerpurple. Then just refer to that wherever you use the color.
For sorting, another thing you could do is change the icon based on the current sort order. In the icon field of the icon object: If(varDescending,Icon.ArrowDown,Icon.ArrowUp)
Also, I had to setup a lot of galleries for sorting, so I found a more efficient way to set it up. Highlight the icon and associated header at the same time, and set the Tooltip to whatever the actual column name is. Once you've done that for each of the columns, highlight all of the column headers and icons, and set Onselect to use self.tooltip. One identical formula for all icons and column headers.
Two things that came up after go-live, make sure you're not resetting the sort order OnVisible, people like their sorting to persist. And I was also asked to add second level sorting (ex First by department then by wage). It wasn't too hard to setup, just use another set of variables and when primary sort changes, push it to secondary sort.
Yup. I have that in a lot of my apps. 😎
This sorting interface was a great idea!!! Thanks for sharing!
Glad to help. 😀
Thanks Shane! Love watching your Videos!
Thanks for watching!
That's amazing 😳, I love that animation X - coordinate trick 😍. Thanks Shane.
I had sooooo much fun playing with that. If I get time I want to try the same thing for Height. 😍 Pretty sure it will work.
I just did it for fun. Here is the tweet showing it. twitter.com/ShanesCows/status/1305508346947084289
Hello I'm from Brazil and I'm here watching your videos.
Very cool, congratulations on the content.
Thanks. I hope they help
Thanks Shane for all your videos, they are really helpful :)
You are welcome 🤗
Super Shane ! Fun and animation...👍👍✌✌
Another fun twist to this coming out tomorrow 🤩
Cannot wait to try this out. Thanks Shane love your videos :)
Awesome! Thank you!
Always Amazing! Thanks Shane!
Thanks 😀
HI Shane, never saw you make a good looking app! Great job! Will help a lot making my own apps look goodl! Thanks again!
Thanks Frans. I was surprised also. 😻
Thanks for another great video Shane! I was able to get the search box expand to work without the additional OnStart variable with a nested If statement on the Width property:
If(
varExpandSearch,
160 * Timer2.Value / Timer2.Duration,
If(
And(
varExpandSearch = false,
Timer2.Value = 0
),
0,
160 - 160 * Timer2.Value/Timer2.Duration
)
)
Like so many "problems" there are multiple solutions. Still need to go back in and rename my timer control:)
Awesome! Thanks for sharing 😀
Thanks for your videos, Shane!
Glad to help.😁
Love these videos, want to get into the world of Power Platform now!
Awesome Robin. My free class at training.powerapps911.com is a great getting started step.
cool tricks with the icon
Thanks 🐶
SHANE.... You're a GOD!
Thanks 😊
Brain melt, thanks Shane, lots of good stuff.
Glad you enjoyed it. Always fun to be had.
Hey Shane ..love your videos ...one question
How did you make the "good at their job field " Boolean ??
Yes/no in SharePoint
This is great 👍
Thank you 🐶
Thanks Shane!
Happy to help
Great video. Nice to see some attention to design and not 'just' the technical stuff - even though design in PowerApps easily gets technical ;)
Thanks 😍 Design isn’t my best skill but I am learning
The emojis are my favorite 🐕. Thanks for showing!
🐶 I thought they were a fun thing to sneak in.
Great videos!! Is there a way to highlight when I new item has been added since the user last viewed the gallery? Such as bolding a title or adding an icon?
This. Is. Awesome.
Thanks 😊
Great Video again Shane! Thank you! Just a question, I followed your tip on sorting and stored my sort columns as a variable. All are text data types. When I use it in a SortByColumn formula with a FIlter in a gallery, the variable that represents my columns always gets a delegation warning. I have even filtered for just the past 5 days of new items in my gallery and it works fine... only when I add the SortByColumns using a variable am i hit with a delegation warning. If I hard code all of my columns for sorting, I don't get the delegation warning. I based my formula on your sample above: SortByColumns(Filter(myDataSource, Created>=varDateFilter),varSortby,If(varSortOrder, Ascending, Descending))
Ugh. Sorry. I think that part doesn't work the way I had hoped. Boo me. :(
Excellent
Thank you! Cheers!
Great work
Thanks 😊
Hi Shane, love the sort column idea! Quick one, do you know off the top of your head how to sort on a complex column like a SharePoint user displayname?
Not sure. This works SortByColumns(AddColumns(Employees, "Real Name", 'Created By'.DisplayName), "Real Name", Ascending) BUT it is not Delegable. So if your list is large it doesn't help.
Great video. THANK YOU!!!! I am trying to do the following. I have a SharePoint list that has emp names, depts they work for, and some other fields. I want to build a gallery that has Depts as subtitles and then lists emp's names and other fields under the appropriate subtitle. How would you do it? Can you point me in the right direction? Thank you!!!
You are going to get into nested galleries most likely. YOu could use GroupBy function to group on departments. I might make this my Thursday video. Sounds like a good question.
@@ShanesCows Thank you!!! I look forward to watching your Thursday video.
Hello Shane, thank you for these videos. hope you can help me with this doubt: When you use a "date format" in a Excel table for a rear reason Power Apps take it as "Date and time" format instead of just "Date format". Do you know how this can be modified in Power apps or which format choose in excel ?? (I`ve tried almost all the options)
hope you can help me
Try the DateValue function to change to Date only.
Thanks Shane. When I use a variable varSortBy in SortByColumns I get a delegation warning.
Hmmm maybe I missed something. I will have to check again when I get a chance. Sorry if that is the case. Boo
Great video like always, thanks!
Glad you enjoyed it!
This is awesome Shane! Is there a way to use the Enter key in the keyboard to "setfocus" or do a certain functionality?
Not really. You could play with OnChange of an input and have it SetFocus maybe.
This is awesome video series, thank you for this training video. I have one request, could you please make a training video on Outlook VBA... Thanks
Sorry I don't know VBA :(
What about VBscript?
Hello Shane, I am trying to avoid users press a button to run a flow that makes some labels to display data. Is there a way to delay OnChange for a Text Input control?, so once a person finishes typing the text then the flow is run (instead of running the flow every time after every character input). I saw it in one of your videos but can't recall which 😅
DelayOutput property set to true
@@ShanesCows Thks Shane!
Hi Shane, Your videos helped me to achieve lot of complex situations in my work place. The power Apps data model you developed earlier gave me idea to develop user maintainable app but my share Point list has more than 1600 question and I am trying filter these based on the department. please advise me is it possible to achieve and I want create pdf at the end to keep the record.
Thanks
That is a lot of questions. It is possible just keep trying to solve small problems
While I love all the information in the video, the emoji tip is life-changing! 🙌💖🎆🎇💜💟
Always the little things. 🐶
@@ShanesCows Truth! In 2020, you have to go with the little things.
I've been using Microsoft products since the MS DOS days; how did I not know this? (Not that they've had emojis all that time.) It is certainly something they didn't highly advertise. 🤷♀️
Shane you are amazing and thanks for giving valuable tutorial.
I am having a small project to design where there is a sharepoint list with the data of more then 2000 rows of user profiles. I need to check if user details exist in the list or not, If data is there then display on Screen1 and if not need to give him a form to enter basic details like, Birthday, Gender, WorkPhone, HomePhone.
Can you share me link if you have made any such video, or can you make small video.
Use the Lookup function to check for data. If it IsBlank then show your form.
I really like the way you allow user to sort by the selected column. However when I use a variable as the column to sort by, I get a delegation warning. Is that the same for everyone else? Is there a way around this?
Shane Young it’s a weird one because the first time i tried it, I got the delegation warning. But when I’ve used it since it is able to delegate. So ignore what I said; I think it’s probably an issue with the SharePoint column I’m trying to search. Maybe the unique column can’t be delegated but all other columns can
So I played more and I think if you use With for the filtering part you can get rid of delegation problem. Something like this With({X: Filter(Employees,HourlyWage > 1) }, SortByColumns(X, varSortBy, If(varSortOrder, Ascending, Descending))) more playing needs done but at least might give you some ideas. In the video I show Search function that also doesn't delegate but nothing you can do about that.
That's amazing 👍
Thank you! Cheers!
Hey Shane, amazing video! One question, I have been making some apps, and there is one thing I can't figured out, it's possible to create a table with the same columns as in a list without writing manually?
Yes you can. You Collect(collectionName, DataSourceName) and that should do it.
Sooooo entertaining and learning at the same time :)
Glad you enjoyed it
Hey Shane, I've got some pretty SLICK PowerApps I've designed for myself and some clients that I would absolutely love to share with you. Let me know the best way I can possibly share them with you! Great content and always fun to watch you work! :P
Sound awesome Neal. Shane at PowerApps911.com would be perfect. Thanks
how we can take data from one table and add that record into another table using power automate
Shane, I can't seem to get that variable in SortByColumns to work with SharePoint. Is that a delegatable function?
Argh! This is a table! That's why (I think!).
So I played more and I think if you use With for the filtering part you can get rid of delegation problem. Something like this With({X: Filter(Employees,HourlyWage > 1) }, SortByColumns(X, varSortBy, If(varSortOrder, Ascending, Descending))) more playing needs done but at least might give you some ideas. In the video I show Search function that also doesn't delegate but nothing you can do about that.
Hey Shane..Please upload video for storing User Ratings to sharepoint list and display avg ratings in other screen.. plz plz plz help..
That was almost the video I did last weekend. Soon, I will cover this.
Shaun I Live for these videos thanks man! :D
Glad you like them!
" Windows + . " changed my life forever, thanks !💖
I love it so much. 😎🤩🥰
How do i set a default value for powerapps gallery, i tried Lookup(mycollection, columnname = "value") this didnt work
Is there an email to ask questions to get help with other issues?
You can contact helpnow at PowerApps911.com
How can I create more column from Gallery? From Example you're only use only 3 column.
You could have more columns? Shouldn't be an issue?
Hi ,
Is it possible to edit the dynamic excel file in powerapps.
Thanks
I don't think so.
@@ShanesCows Thanks Shane
Top video, as always. I am trying to create a chat style incident logging app, where one incident can have many lines of comment, each saved with a time stamp. I would like my users to see any updated comments and add their own if necessary in near real time, as you would in a chat app, is that possible for multiple users? Many thanks.
near real time isn't ideal but possible. Consider the Refresh function and set it on a timer to Refresh every few seconds.
Shane, love your videos!. Would you please do one on trapping for errors, like those nasty red ones that appear when you forget to give your users access to all your SharePoints List, DOH! :-)
Also, there are these ifError and IsError functions that are "experimental". Should these be used?
I think error handling in PowerApps is a topic that has very little content and is well deserving of a video. I hope you agree and can put something out soon to end my suffering through reading (hate to do that :-)). Really want to be able to trap for any errors that I didn't account for in my code that are thrown by the app when things data becomes unavailable, etc. (i.e. things outside my control).
Thank you so much!
Errors are on my list. :| So many videos but that one is closer to the top.
Why don't you create a colour header variable on start
I do sometimes. It is a solid idea.
@@ShanesCows I started doing it for a lot of commonly referred to components X y z etc then youc an change the one variable rather then finding the original reference. It can also be easily changed dependent on client rather then creating a whole new header component.
@@ShanesCows also just to say thanks for all your help Shane you took my apps from simple forms to things of beauty
Hi Shane where can I access the zip file to download please?
Hey Yvonne you can download the video and the supporting app by being a subscriber here training.powerapps911.com/courses/video-library lots of fun content.
Hi Shane, whats the difference between !IsEmpty and IsEmpty?, i wrote a formula using ! and that one works but the one without it doesn't.
IsEmpty returns a boolean (true or false) so !IsEmpty returns the opposite. So true becomes false. Hope that helps
@@ShanesCows Yes it does, thanks!
Hi Shane ,
Can power apps does the upload file , I have a Upload button in my app ,where on click , it should pick the excel file from my one drive and then the changes should apply on my form.
P.S:- Basically we do some internal surveys in our company we have designed a canvas app ,each time for a new survey we will manually keying/editing the question in the form directly ,Instead we decided to have a upload functionality where we upload a excel file which has all our questions and those questions will appear in my app.
Can you please reply to this :)
any one in comments ?
I respond as often as I can. A bit behind on comments Pavan.
Try combing this concept th-cam.com/video/QcWjAt7QVn4/w-d-xo.html with this concept th-cam.com/video/7XXo9wjnJvc/w-d-xo.html
That was a ballzy move. (Nicola good at their job = false) Not wise my friend.
Playing with fire. 🔥
Bang bang🌶🌶🌶
😎