After replace the list value with varible in it (in your video Mytask to the IF sentence), Sort by Ascending won't make blank values at top, how can I do to make it still at top?
Hi sen hatsuki, Sort Ascending should have blanks at the top, correct? There are a couple ways to do it, but the main thing you need to do is, you can make a collection of your datasource, and collect a blank before it. Similar to the example here: powerusers.microsoft.com/t5/Building-Power-Apps/Need-Dropdown-with-blank-null-default/m-p/58863#M24315 Here is another link where they use in the sort, for trying to force sorting by descending: powerusers.microsoft.com/t5/Building-Power-Apps/How-to-sort-gallery-Descending-with-Nulls-at-top/td-p/417940
@@pawanmishra6549 Thanks for watching pawan, was just about to hand it off to you :) This link and many of the videos after this one: ua-cam.com/video/yhJNydhLEhQ/v-deo.html&t
Hi Mark, you can create a variable for the Ascending or Descending. Sort of like this screenshot here on this site, they are using a variable SortDescending1, to say if true, then descending else ascending. softchief.com/2021/11/24/how-to-implement-sorting-and-searching-in-gallery-in-canvas-apps-power-apps-in/
Hi Sbrutcher, by using a Switch statement without a variable in the Sort statement, we can get by without delegation errors. When we had the variable in the Sortbycolumns statement it gave us delegation issues. Which delegation issue are you facing? Do you have your formula? What is your backend? SharePoint?
@@andrewhess123 Thanks for the reply, Andrew! Based on your info, I was able to re-code my formula and now it's working. I'm used to ignoring delegation errors because most of my datasets aren't very large. That's always bugged me, though. And I do have a SharePoint list that's pushing 2000 items with no sign of getting smaller, so I figure the app will break at some point unless I fix it. I appreciate your lessons and advice.
Hi Andrew, I am fairly new to powerapps and have followed various videos to try and do this, but each one keeps getting thwarted by my sharepoint columns not appearing the the formula bar. For example, in the OnSelect of my sort icon, when I type "UpdateContext({SortColumn: " None of my sharepoint columns become available in the formula bar (telescence is it called??). Do you know why this would be at all? Many thanks, Mark
Hi You Are Me, sometimes SharePoint columns internal names are different than the column names you see. Also make sure you are connected to your datasource? Also UpdateContext is for context variables. I don't think your datasource columns will appear there. Put it in a label first then try to set the variable as the label.text first, then go from there.
Really common use case! Very good.
Thanks Andrew, good job!
Im pretty sure this is something that I’ll end up using
Thanks for all the feedback J Ray. You rock appreciate it!!!
Thank You sooooo much!
Thanks for watching Piotr!
Excellent video!
Thank you Paul!
Hi, I am using Dataverse, how to handle delegation issue with sorting'.
Hi Swathi, Sort, and SortByColumn are both delegable for dataverse. The issue may be due to a lookup column?
Thank you @@andrewhess123
After replace the list value with varible in it (in your video Mytask to the IF sentence), Sort by Ascending won't make blank values at top, how can I do to make it still at top?
Hi sen hatsuki,
Sort Ascending should have blanks at the top, correct? There are a couple ways to do it, but the main thing you need to do is, you can make a collection of your datasource, and collect a blank before it. Similar to the example here: powerusers.microsoft.com/t5/Building-Power-Apps/Need-Dropdown-with-blank-null-default/m-p/58863#M24315
Here is another link where they use in the sort, for trying to force sorting by descending: powerusers.microsoft.com/t5/Building-Power-Apps/How-to-sort-gallery-Descending-with-Nulls-at-top/td-p/417940
Hi Andrew! May I ask how to make my gallery look just like yours? I mean how to set the color of each column?
Very handy and useful, thanks for the video Andrew! Can you please share the link of the video for the gallery that you are showing in this video ?
Don't worry, I got it from one your video playlist , thanks again👍
@@pawanmishra6549 Thanks for watching pawan, was just about to hand it off to you :) This link and many of the videos after this one: ua-cam.com/video/yhJNydhLEhQ/v-deo.html&t
I made a playlist with all the videos that are related: ua-cam.com/play/PLmA98H4-M_cM6YOnhwvt-tgBf02X1gz72.html
Great video, When I click on the sort icon it sorts in Ascending order but how do I get it to sort on Descending order if I click the same icon again?
Hi Mark, you can create a variable for the Ascending or Descending. Sort of like this screenshot here on this site, they are using a variable SortDescending1, to say if true, then descending else ascending. softchief.com/2021/11/24/how-to-implement-sorting-and-searching-in-gallery-in-canvas-apps-power-apps-in/
Sorry, I'm not clear on where your delegation error went. I tried your solution & still getting it. Any suggestions?
Hi Sbrutcher, by using a Switch statement without a variable in the Sort statement, we can get by without delegation errors. When we had the variable in the Sortbycolumns statement it gave us delegation issues. Which delegation issue are you facing? Do you have your formula? What is your backend? SharePoint?
@@andrewhess123 Thanks for the reply, Andrew! Based on your info, I was able to re-code my formula and now it's working. I'm used to ignoring delegation errors because most of my datasets aren't very large. That's always bugged me, though. And I do have a SharePoint list that's pushing 2000 items with no sign of getting smaller, so I figure the app will break at some point unless I fix it. I appreciate your lessons and advice.
@@sbrutcher Think of Dataverse for Teams. Free until about 1 million rows.
Hi Andrew, I am fairly new to powerapps and have followed various videos to try and do this, but each one keeps getting thwarted by my sharepoint columns not appearing the the formula bar.
For example, in the OnSelect of my sort icon, when I type
"UpdateContext({SortColumn: " None of my sharepoint columns become available in the formula bar (telescence is it called??). Do you know why this would be at all?
Many thanks, Mark
Hi You Are Me, sometimes SharePoint columns internal names are different than the column names you see. Also make sure you are connected to your datasource? Also UpdateContext is for context variables. I don't think your datasource columns will appear there. Put it in a label first then try to set the variable as the label.text first, then go from there.
@@andrewhess123 Ok will give it a go. Many thanks!