PowerApps Design Ideas, IsEmpty, and making pretty galleries 

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!!!!

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.

This sorting interface was a great idea!!! Thanks for sharing!

SHANE.... You're a GOD!

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.

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 Shane for all your videos, they are really helpful :)

Thanks Shane! Love watching your Videos!

Hello I'm from Brazil and I'm here watching your videos. Very cool, congratulations on the content.

That's amazing 😳, I love that animation X - coordinate trick 😍. Thanks Shane.

Great video. Nice to see some attention to design and not 'just' the technical stuff - even though design in PowerApps easily gets technical ;)

cool tricks with the icon

Cannot wait to try this out. Thanks Shane love your videos :)

Always Amazing! Thanks Shane!

Love these videos, want to get into the world of Power Platform now!

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:)

HI Shane, never saw you make a good looking app! Great job! Will help a lot making my own apps look goodl! Thanks again!

Brain melt, thanks Shane, lots of good stuff.

Super Shane ! Fun and animation...👍👍✌✌

Thanks for your videos, Shane!

This. Is. Awesome.

Excellent

The emojis are my favorite 🐕. Thanks for showing!

This is great 👍

" Windows + . " changed my life forever, thanks !💖

Sooooo entertaining and learning at the same time :)

Hey Shane ..love your videos ...one question How did you make the "good at their job field " Boolean ??

Thanks Shane!

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

Great video like always, thanks!

Shaun I Live for these videos thanks man! :D

While I love all the information in the video, the emoji tip is life-changing! 🙌💖🎆🎇💜💟

Great work

Thanks Shane. When I use a variable varSortBy in SortByColumns I get a delegation warning.

Hey Shane..Please upload video for storing User Ratings to sharepoint list and display avg ratings in other screen.. plz plz plz help..

That's amazing 👍

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 Shane! Is there a way to use the Enter key in the keyboard to "setfocus" or do a certain functionality?

how we can take data from one table and add that record into another table using power automate

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!

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.

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?

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

How can I create more column from Gallery? From Example you're only use only 3 column.

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

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?

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

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!!!

How do i set a default value for powerapps gallery, i tried Lookup(mycollection, columnname = "value") this didnt work

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?

Why don't you create a colour header variable on start

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.

Hi , Is it possible to edit the dynamic excel file in powerapps. Thanks

Is there an email to ask questions to get help with other issues?

Shane, I can't seem to get that variable in SortByColumns to work with SharePoint. Is that a delegatable function?

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.

Hi Shane where can I access the zip file to download please?

That was a ballzy move. (Nicola good at their job = false) Not wise my friend.

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 :)

Bang bang🌶🌶🌶