Hi Reza! This video has been pretty useful to me. Just one observation. Please go to minute 21:16. There is a bug on the formula that checks sort direction. You wrote: "If ( varSortColumn = Ascending, Ascending, Descending)". It should have been: "If ( varSortDirection = Ascending, Ascending, Descending)". That´s why the sort icons seem to work unproperly as you might see between minutes 21:23 to 21:30.
Thanks very much for the video. I'm from the Brazil, and my english is very basic, but you bothered to speak clearly and slowly, so that everyone understands. Thanks!
Thanks Michel. Glad to hear this feedback. I have worked on my speech to ensure I speak slower and clear. Very happy to hear that folks are seeing improvements.
Hello Reza, I am regularly watching your video. All of your videos are very useful and easy to understand. I want to filter the gallery with predefined thee Customer name in the exclusion list. I want to filter the gallery with all the customer name except predefined three name. which i do not want to see in the gallery. Is this possible ?
Thanks for following my channel. Exclusion list is possible but will run into delegation warnings. I did show some workarounds on delegation and filters. Check ua-cam.com/video/yXvDj60-3YQ/v-deo.html
Reza ... Really appreciate.. Is it possible to loop a column values seperated with comma? Ex City Village C1. V1 C1 V2 C1 V3 C2. V1 C2 V2 So we want to display C1 V1, V2, V3 C2 C1, V2 Means column(village )values into single row seperate with comma as row string Please reply
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
This is indeed a great video. But why i'm getting an error "specified Column Does not exist or invalid Sort Column Type" when i click the icon sort? what did I missed out?
few tips for more views. on videos add ur other video links which are connected to this video. Like you could've added link for how to connect sharepoint list and how to make background of powerapps. I found it useful but what if i was a beginner and didn't know this.
Its been a long while since I did this video. I believe the variable used for defining sorting, you can try setting that to Blank() Please note I am only guessing as I do not remember this video step by step
Brilliant content. I've seen other videos on these topics but none that combine all of the features together in one clear and working example. I am learning PowerApps for use at work and I have now subscribed to your channel based on this video alone. Great work!
Great Video - really helped me with clean my app. Having an issue though - when I go to choose which column I want to sort, not all of the columns in my SharePoint list appear, but a number of unnamed columns (just names "field_**" appear. I've refreshed the data and data source, but don't understand why all of my column names aren't appearing to be used in the sort.
Thanks. I will have to look at your App in action to know the reason for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Excellent content Reza! Very clear explanatiion step-by-step. Once minor comment: I understand that Task column is bound to Title field in the gallery. I was scratching my head for a few mins when you say Title, but you were actually referring to Task field. It wasn't obvious in your video I guess. I finally got it after pausing and going through your screen and code.
Thanks so much! Apologies for the naming confusion. SharePoint has concept of internal name and display name. Internal name was Title and Display Name was Task
Hi Reza, Nice Video. But one thing I notice in the last part that the Descending in Sort Icon didn't work. I also follow your command and also repeating to watch the last minute which you are clicking the sort Icon. It didn't sort to Descending. Do you know what causes it? It was similar to what I'm facing right now.
Hello Reza, I love your channel, I have a problem with my app, I cannot sort by more than one column, both with sort and sortbycolumns, it gives me delegation problems when I try to manage the second column. My sharepoint list has 4000 elements, the columns I use are the created column and a text column. I even splits my list into two filtered tables to narrow down the items, but whenever I append the second column of text, it gives me delegation problems. help! thanks. I tried the video example.
Very nice and informative video. I have one query regarding my one of the issue, I wanted to show data from sharepoint list Title field in PowerApps ComboBox and my Sharepoint list is having items more than 5000. Could you please suggest the best approach to achieve this.
I do not believe a combo box supports more than 2k items (or may be limit is 500). Not sure why would you want the user to have a list of titles. What not just give a search box as shown in video?
Hi Reza, Thank you again and again for the great video's you make. I followed the switch formula you provided, i am sorting on ID column and 3 other Date fields, everything works great except 3 date fields, when sorting on date fields , any empty fields are not included and some rows go missing, any idea why? your help is appreciated. Thanks in advance!
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Great video! I used this in a few apps already. Quick question for a different use case I'm working on. Is there any way to integrate this with the Search( function? I'm working on a FAQ app and for that, the startswith function isn't convenient for searching, but it is still beneficial to be able to do some basic filters on the content.
Hi I want to filter date and Status in gallery ---Below code getting error please help me ....Filter(M1_TRACKER_UPDATE, Textsearch.Selected.Result=Node Name,DateCol=FilterDate.Selected.Result) .........................One more ---Filter(M1_TRACKER_UPDATE,Textsearch.Selected.Result='Node Name',M1_TRACKER_UPDATE=FilterDate.Selected.Result=Date)
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
These are all brilliant insights. Could you make a video using a people picker as part of the filter for the gallery. This seems to be a gap in UA-cam university. Thanks.
This is a great stuff with a combination of SharePoint Online and Powerapps. That would be great if you can post a session how can we create a SharePoint list Grid view in the gallery.
Thanks once again for your comprehensive tutorial!! @ quesrtions: 1)What about those filter and reset icons. I figure the filtering would set one of two filter icons (filled, empty) visible and one hidden and the reset would reset filtering. HOWEVER, how do we know when the "filtering" is engaged? 2)Is that fancy header a component and how did you construct it? I cant get the quarter circle icon to rotate. Thanks
1 - To check if filtering is engaged, I check to see if the filter controls have values in them. 2 - Fancy header is a string of label controls tied together :) Check ua-cam.com/video/bnC8u3gdWss/v-deo.html
@@RezaDorrani Thanks Reza. It didn't work that way for me. I had to put a hidden label above the search boxes which pulled the value then the code checked if those labels had values. I had to put a circle on top of the filter icons as I found it was only working if you clicked the edge of the icon/text. The transparent circle on top seems to work. Thanks. LOVE YOUR VIDEOS!!
Looks good. However would be great if you could provide more context to the gallery that you are using at the very start. I have no idea how to get started and create the gallery that you are using to sort and filter. Thanks
Thanks again for sharing this wonderful video Reza!! I do have a similar implementation of sorting from before. Then I encountered delegation issues. I found your pagination video last week and it worked well but was stuck in incorporating my old sort solution. Alas I stumbled on this video and confirmed all the things in my situation.... that complex types won't work, the dynamic variables are not working either, and I have to repeat the same code (filter of 5+columns) for each column I want to sort.... keep up the good work!! :)
Hi Reza! Thank you so much for your video. It was very helpful. If you wanted to add the Sort Up/Down icon to your choice field called Priority (to make the sorting of that field dynamic also), how would you incorporate that into the formula you have in the Items property of your Gallery? Because in the Items property of your Gallery, you use SortByColumns. But if you wanted to sort your choice field called Priority, you would need the Sort formula instead of the SortByColumns formula. (And I'm not worried about Delegation issues because my list only has about 60 items)
Set a variable on icon selection - up or down value. And use that to define sort direction. I do not have a specific video on this scenario hence giving an idea. You can also try posting your query on forums in case someone has done something similar powerusers.microsoft.com
Thanks a lot Reza for your awesome videos. SortByColumns(Filter('Work Trackers',StartsWith('Task Name',TextInput1.Text)&&Priority.Value=Dropdown1.Selected.Value),"cred0_id",Descending). i have small doubt Reza when i compare priority.value=dropdown1.selected.value i'm getting error invalid argument type
Your dropdown Items property must be same type as Priority column. It would be best if you post your issue with screenshots on the forums at powerusers.microsoft.com/
is Not a delegable operator. Sometimes you have to write long formulas to get around it. Lets assume you have 3 status values Not Started, IN Progress and Completed Formula would be Filter(datasource, Status = "IN Progress" || Status ="Completed")
Reza this is Amazing as usual with all your content. In terms of new videos, I'd love to see you re-do the repeating Grid video but with Sharepoint as a data source and not CDC. Thank you.
Hi Reza, another amazing video, Thanks for sharing!!!... Would it be possible to include the Switch for varSortColumn inside the Filter functions just the same way you did with the If for varSortOrder (Ascending/Descending)?
Thank you for the detailed explanation. I'm having trouble with dropdown + OR function. I am trying to filter my gallery by two dropdowns, either dropdown1 or dropdown2, or a combination of both. Both of these dropdowns are linkd to tables stored on excel. These are "month" and "task". My main data is in a table called Main. It has a month and task column. What I want to achieve is by selecting dropdown month, the gallery returns all the items with the month selected or If i click dropdown task, it returns all tasks. If i click both, it filters both the month and the task. Same as your video. I'm using Filter(Main, 'month' = dropdown1.selected.month, OR(task = dropdown2.slected.task)). However, this only then filters both combo boxes e.g., when i click the month dropdown, it will not show any results until I click on the task dropdown. It then applies the filter for both, but wont show just the months with all tasks. There is a blank option in the dropdown which is the first option to prevent accidental filtering.
You need to check if your combo boxes are empty - Check ua-cam.com/video/5dSk5iOgT68/v-deo.html Also, your expression is more of an AND than an OR. You need something like this + add logic for empty check Filter(Main, 'month' = dropdown1.selected.month || task = dropdown2.slected.task)
Great job man ... lots of vids out there on this subject and you're approach is one of the better ones... you should make a video on brainstorming methods when coming up with logic flows for answering probs like this. 🦅
Hi Reza, Awesome technic! But I have a person filed named "requestor" from here I would like to search by name . This function isn't working for that person filed. Can you let me know the actual formula?
Thanks for these videos Reza! Extremely helpful for new power apps users. I did find that the varsortcolumn function inside your switch function was not working. I noticed you said "sort direction" but the syntax shows sort column. Hope this helps anyone else who's sort icons weren't working.
@@qayyumkadri2138 There are 5-6 such videos where code need correction. I would do so in my free time which is very limited these days. I have a lot of plans but limited time.
Hello sir....I have provided the sorting to my gallery...I have one button to edit the selected form.....but when I clicked on the edit form of selected item.... there IDs are not getting matched and edit form control is showing error.....can you please help me ..... please reply
I have not come across this issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Logic should be similar. I do not have a video on that. Will add it to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
'Brilliant' describes the quality of this session. I face the problem, and there is Reza's video that exactly solves it. Not only solving it, but I learn so much from it.
Hey Reza, I watched this video in 2022 and implemented the use of variables for sorting the SortByColumns (14:38) formula and it’s been working great. Yesterday, the editor started showing a warning ⚠️ about the use of a variable instead of using the “name directly” in the formula. I believe it is a bug. When I hover over the variable I see it is set to “Modified” which is the Modified field on a SharePoint list. When I code in “Modified” it stops complaining. When I swap back to the variable, it complains but still works when I select a different column name from the dropdown. Here is the full warning message: “The expression ‘variableName’ may represent a column that is not part of the data source or has not been downloaded. Consider using the name directly.” The source is a collection. When I view the collection, all columns listed as options in the dropdown are present. The warnings disappear when I directly use the name. Authoring version is 3.23.114.25 but published with 3.23.113.30 for some reason.
Sorting by variables still requires us to hardcode the column names by using If condition for sorting. I have not tested this video in a long time so not sure if anything has changed.
Hey Reza, Thanks for your videos. I am learning alot from your channel. I am working on a vehicle inspection application. Can you just make a one tutorial to how to create a tabbed form and give the user an option to take an image and save it in a particular record. I mean with the information and the image .It ll be helpful. Thanks.
@@RezaDorrani Thank you for the reply. To avoid delegation could the switch technique you used @19:49 in the video be used on record columns? Also, just a heads up I believe lines 14 and 45 in the github syntax should be VarSortDirection and not VarSortColumn. took me awhile to figure out why mine was not working.
Hi Reza, I applied this to my Gallery, but for the drop-down code I keep getting the following error: Incompatible types of comparison, these types can't be compared: Table, Text. Is that because the Item value in my dropdown is in a table format?
I have not come across this issue & hence not sure what the resolution is. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi there I think you can only solve my issue. I have gallery. I would like to achieve these three functionality. Filter gallery by logged in user. Sort descending And also search the gallery by ticketid, priority and status. Priority and status are choice column. The third condition, I will give the search string in textbox. Please help to get the code as I am unable to achieve.
I would have to recreate your scenario to provide any guidance. Search is not a delegable function with SharePoint as a data source. So you may want to replace that with StartsWith function. I would recommend you post your query with screenshots on the forums at powerusers.microsoft.com and check if someone has done something similar.
Hi Reza, brilliant video again. I have question: I wanted to make the filter in 2 columns instead of one like: SortByColumns( Filter( Missions, StartsWith( Title, TxtUID.Text ) || StartsWith( 'Mission Name', TxtUID.Text ) && (Status.Value = DrpMissionStatus.Selected.Value || DrpMissionStatus.Selected.Value = Blank()) ), "ID", Descending ) However, is not filtering in both the text input box and dropdown box simultaneously. What I am doing wrong? thank you...
@@amigomusa DrpMissionStatus.Selected.Value = Blank() part should do the trick for empty dropdown selection. Must be something to do with how your dropdown is setup. Tough to help evaluate the issues on this chat. I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/
@@RezaDorrani I figured out the issue was with my dropdown setup. I changed "AllowEmptySelection"=True and turned Default=0. Now it's working perfectly. All thanks to you!
Hi Reza, Thank you very much, Your videos are amazing! I am following your directions for sorting functionality and got an issue, I wonder if you could give some guidence. I have a horizantal container and inside i have a data table(similar to your service desk app with responsive design), In the data table i inserted sort icons on column headers. for some reasons the icons are not getting aligned properly with data table headers, are there any known issues in using table and icons in side a container?
I have not come experienced this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
This is indeed a great video. But why i'm getting an error "specified Column Does not exist or invalid Sort Column Type" when i click the icon sort? what did I missed out?
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
I have a sharepoint list with repeated values for the name field value and I need to display them in a gallery with the unique values and grouping values according to the match. How do I do it? thanks
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you Reza for your video. But I am unable to show all records in a gallery as you have done in your video. Could you help me in guiding how to do that?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
You would need to table shaping formulas like addcolumns to get the text values from complex columns and then sort on it however those formulas are NOT delegable
Hi Reza, Quick Question - You have very well explain about the deligation issue here but again if i want to use In() function for filtering my text column it again gives me deligation exception, is their anyway i can avoide this deligation issue for in() function i am using this formula Filter( 'Assignments', (txtAssignmentID.Text in AssignmentID || AssignmentID = Blank()) //StartsWith(AssignmentID,txtAssignmentID.Text) || AssignmentID = Blank() ) And one more question is their any way to filter ID column if default value of ID is blank - Filter( 'Assignments', (txtAssignmentID.Text in AssignmentID || AssignmentID = Blank()) && (ID = Value(txtID.Text) || ID = Blank()) //StartsWith(AssignmentID,txtAssignmentID.Text) || AssignmentID = Blank() ),
Hiii Reza i have tried the same approach but getting error at column level as invalid sort column type after adding more than three functions under switch condition
I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza, I am new to Powerapps. I am unable to wrap my head around a problem in Filter function. Hope you can help. I am using Google Sheets as db. I have column by the name of Item which has values in which Item name is repeated a number of times. Each Item name has an associated value in the next column called Buy(Number). I am unable to filter and sum the values of Item Name. Formula like this Sum(Filter(checkdb,Item=dd5.SelectedText)Buy). Iam getting an error in label control. Thanks.NoteThe dropdown has distinct values.
I would have to recreate your scenario to look into what the potential solution is. Difficult to do so here on chat. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, In the last part of the video, where you talk about delegation due to dynamically defining sort column, could you explain scenarios where this delegation warning would actually return wrong output? Or will we practically never face any issues, even though there's a warning (provided that our dynamic column name assignment is valid). I have experienced that not all warnings are actually problematic e.g. countrows with firstn etc. delegation issue. Could you please address this? thanks :)
Give me all items from my SharePoint list sorted in asc order. If sort column is dynamically defined will result in delegation and Power Apps will load only the first 2000 records (assuming thats the delegation limit) in memory and then sort them. All other records in data source would be ignored. Delegation warning will never be a problem in case of data sources less than 2k records.
Hi Reza, This is great and I have an issue. App works fine on start and when I sort again, sort is not working for more than 100 rows and I see “loading data” notification. FYI- I’m using SharePoint as source and data table to display items. Any help is much appreciated. Thanks.
I will have to look at your App in action to know the cause of your issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Thanks for the great contents including this video. I have a question regarding delegation warning when I apply "&&", "||" or "in" operations with related column on a different table. See "&& (txtSearch.Value in Asset.'Asset ID' || txtSearch.Value in Asset.'Serial Number')" in the code below. How do I resolve the delegation warning for this? If ( txtSearch.Value = "" || txtSearch.Value = Blank(), Filter( 'Work Order Line Items', 'Work Order'.'WO Number' = workOrderId ), Filter( 'Work Order Line Items', 'Work Order'.'WO Number' = workOrderId //&& (Asset.'Asset ID' = txtSearch.Value) && (txtSearch.Value in Asset.'Asset ID' || txtSearch.Value in Asset.'Serial Number') ) )
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza: If I were to mimic exactly what you have in this Video, I need create SharePoint Lists with appropriate data SLT/Choice/Date/Person/Lookup columns. "SHOW MORE" does not list such screen captures. I can do this and populate some real looking data by watching the Video. But, have you provided data used in this Video somewhere?
The data in my App is in a SharePoint list. I have not loaded or provided the data anywhere. It is just sample data I added for demo purposes. "SHOW MORE" does not list such screen captures - I did not understand this.
Hey, thanks for the video! Everything seems to work great, but the sorting only goes in one order. Your arrow changed but the numbers didn't (at the very end). I'm having trouble figuring out how to fix this, any ideas?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza. I'm trying to combine SortByColumns with a Filter not based on a text input. This uses a context variable on button OnSelect: UpdateContext({SortDescending1: !SortDescending1}) - My gallery filter function works like this: Filter('testRaw Materials List', Customer.Value = "Spring Sheep") - My SortByColumns works like this: SortByColumns( 'testRaw Materials List', "Title",If(SortDescending1, Descending, Ascending)) How do I combine these two statements? When I use syntax similar to what you've done in 10:37 I get an error. Using SharePoint List as a datasource
I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
I hv a so list with 20+ number type columns (cost centres) At the movement I can filter based on a string value How do I sum by columns please I want to filter results and add to a collection and show the sum for each column in a gallery . Show some direction on this please
Probably a user error but I could not use "varSortDirection: Ascending, Descending" with SQL Server. I made the necessary changes and used "varSortAscending: true, false" If( varSortAscending, Ascending, Descending )
I will have to look at your App in action to know the reason for the error. Should work with SQL as well. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
how did you have table format after getting data from sharepoint? I am trying to use excel sheet but I am not getting the tabular layout and second... what did you code for text box and drop down menu?
This was great but for some reason, only the last of three sort columns I'm using is working for me. Selecting the other columns returns no data to the gallery when I run the app.
Not sure what column types or data source you are using. Tough to provide direction without looking at screenshots. I would recommend you post your issue with screenshots on forums at powerusers.microsoft.com/
Thanks a lot for sharing this, it solved an actual scenario when you use search as well as want user specific dynamic sorting :-)
Glad to hear that!
Hi Reza!
This video has been pretty useful to me. Just one observation. Please go to minute 21:16. There is a bug on the formula that checks sort direction. You wrote: "If ( varSortColumn = Ascending, Ascending, Descending)". It should have been: "If ( varSortDirection = Ascending, Ascending, Descending)". That´s why the sort icons seem to work unproperly as you might see between minutes 21:23 to 21:30.
Thats correct! Many have reported this in comments :)
Thanks very much for the video. I'm from the Brazil, and my english is very basic, but you bothered to speak clearly and slowly, so that everyone understands. Thanks!
Thanks Michel. Glad to hear this feedback. I have worked on my speech to ensure I speak slower and clear. Very happy to hear that folks are seeing improvements.
Hello Reza,
I am regularly watching your video. All of your videos are very useful and easy to understand.
I want to filter the gallery with predefined thee Customer name in the exclusion list.
I want to filter the gallery with all the customer name except predefined three name. which i do not want to see in the gallery.
Is this possible ?
Thanks for following my channel.
Exclusion list is possible but will run into delegation warnings.
I did show some workarounds on delegation and filters. Check ua-cam.com/video/yXvDj60-3YQ/v-deo.html
@@RezaDorrani .... Hello Reza.. Thanks for your reply. I found the solution from your suggestion video.
✅✅✅ magnifying glass is the cream of the cake 🍰 for me, like to see whenever formula is writing 🔢
Thank you!
I had a lot of comments on adding the magnifying glass. Going forward I will ensure I add that for videos that include formulas.
Reza ... Really appreciate..
Is it possible to loop a column values seperated with comma?
Ex
City Village
C1. V1
C1 V2
C1 V3
C2. V1
C2 V2
So we want to display
C1 V1, V2, V3
C2 C1, V2
Means column(village )values into single row seperate with comma as row string
Please reply
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thanks a lot Reza for your awesome videos. I can now avoid the delegation issue while multiple column sorting
Glad to hear that
This is indeed a great video. But why i'm getting an error "specified Column Does not exist or invalid Sort Column Type" when i click the icon sort? what did I missed out?
Not sure why that would be the case
few tips for more views. on videos add ur other video links which are connected to this video. Like you could've added link for how to connect sharepoint list and how to make background of powerapps. I found it useful but what if i was a beginner and didn't know this.
Thanks for the tip. I will start interlinking videos going forward.
In last section, instead of 'varSortColumn', it should be 'varSortDirection' in If condition "If(varSortColumn = Ascending, Ascending, Descending)"
That's correct.
Thanks for pointing that out!
Omg thank you so much! I have been trying to figure this out for hours!!
Hi Reza!! Nice and informative video. Can you tell me how to reset the sort icons back to original? so that no direction is selected?
Its been a long while since I did this video. I believe the variable used for defining sorting, you can try setting that to Blank()
Please note I am only guessing as I do not remember this video step by step
Brilliant content. I've seen other videos on these topics but none that combine all of the features together in one clear and working example. I am learning PowerApps for use at work and I have now subscribed to your channel based on this video alone. Great work!
Thank you for the amazing feedback and welcome to my channel.
function correction, 20:16 If(varSortDirection = Ascending,Ascending,Descending)),
Thanks 😊
Thank You Reza Duranni For This Incredible Solution 😊
You are welcome
Great Video - really helped me with clean my app. Having an issue though - when I go to choose which column I want to sort, not all of the columns in my SharePoint list appear, but a number of unnamed columns (just names "field_**" appear. I've refreshed the data and data source, but don't understand why all of my column names aren't appearing to be used in the sort.
Thanks.
I will have to look at your App in action to know the reason for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
This is exactly what I was looking for. Thank you very much for this great video.
You are most welcome
Excellent content Reza! Very clear explanatiion step-by-step. Once minor comment: I understand that Task column is bound to Title field in the gallery. I was scratching my head for a few mins when you say Title, but you were actually referring to Task field. It wasn't obvious in your video I guess. I finally got it after pausing and going through your screen and code.
Thanks so much!
Apologies for the naming confusion. SharePoint has concept of internal name and display name.
Internal name was Title and Display Name was Task
Hi Reza, Nice Video. But one thing I notice in the last part that the Descending in Sort Icon didn't work. I also follow your command and also repeating to watch the last minute which you are clicking the sort Icon. It didn't sort to Descending. Do you know what causes it? It was similar to what I'm facing right now.
Check most recent comments. Someone posted about it.
Thank you Reza. For about Reset button of after all search /filter/sort , please advise me for your VDO? thanks a lot
Welcome!
I did not understand your question.
@@RezaDorrani sorry I got it after reviewed in this content again and understood about reset button.
Hello Reza, I love your channel, I have a problem with my app, I cannot sort by more than one column, both with sort and sortbycolumns, it gives me delegation problems when I try to manage the second column. My sharepoint list has 4000 elements, the columns I use are the created column and a text column. I even splits my list into two filtered tables to narrow down the items, but whenever I append the second column of text, it gives me delegation problems. help! thanks. I tried the video example.
Thanks so much!
I have not come across any delegation issues. I cannot guess what your issue is on chat.
Thanks for reply @@RezaDorrani
I was able to fix it, many times I am very desperate, thank you very much Reza, your channel is top level and I am learning a lot.@@RezaDorrani
Very nice and informative video. I have one query regarding my one of the issue, I wanted to show data from sharepoint list Title field in PowerApps ComboBox and my Sharepoint list is having items more than 5000. Could you please suggest the best approach to achieve this.
I do not believe a combo box supports more than 2k items (or may be limit is 500).
Not sure why would you want the user to have a list of titles. What not just give a search box as shown in video?
Hi Reza, Thank you again and again for the great video's you make. I followed the switch formula you provided, i am sorting on ID column and 3 other Date fields, everything works great except 3 date fields, when sorting on date fields , any empty fields are not included and some rows go missing, any idea why? your help is appreciated. Thanks in advance!
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Great video! I used this in a few apps already. Quick question for a different use case I'm working on. Is there any way to integrate this with the Search( function? I'm working on a FAQ app and for that, the startswith function isn't convenient for searching, but it is still beneficial to be able to do some basic filters on the content.
ua-cam.com/video/zxZGaXQlZqo/v-deo.html
Hi I want to filter date and Status in gallery ---Below code getting error please help me ....Filter(M1_TRACKER_UPDATE, Textsearch.Selected.Result=Node Name,DateCol=FilterDate.Selected.Result) .........................One more ---Filter(M1_TRACKER_UPDATE,Textsearch.Selected.Result='Node Name',M1_TRACKER_UPDATE=FilterDate.Selected.Result=Date)
It is not easy to debug issues here on chat.
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Thank you! very useful.
I tried similar code but it is working just for first click
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani No worries, it’s resolved.
Thank you for the video!:)
These are all brilliant insights. Could you make a video using a people picker as part of the filter for the gallery. This seems to be a gap in UA-cam university. Thanks.
I have shown that in some of my videos. Title may not be that specific. You will need to look through.
Ok, i would not like the first minute but at the end this tutorial helped me a lot and i should appreciate it, so i do!!!, Thanks Reza! Regards!
You are most welcome. As long as the content is providing value, that’s a win for me.
Above and beyond, even the last part about delegation. Perfect video!
Thank You
This is a great stuff with a combination of SharePoint Online and Powerapps. That would be great if you can post a session how can we create a SharePoint list Grid view in the gallery.
I have done 2 videos on grid views on my channel. If I do another version then I will choose SharePoint.
Thanks once again for your comprehensive tutorial!! @ quesrtions:
1)What about those filter and reset icons. I figure the filtering would set one of two filter icons (filled, empty) visible and one hidden and the reset would reset filtering. HOWEVER, how do we know when the "filtering" is engaged?
2)Is that fancy header a component and how did you construct it? I cant get the quarter circle icon to rotate.
Thanks
1 - To check if filtering is engaged, I check to see if the filter controls have values in them.
2 - Fancy header is a string of label controls tied together :)
Check ua-cam.com/video/bnC8u3gdWss/v-deo.html
@@RezaDorrani Thanks Reza. It didn't work that way for me. I had to put a hidden label above the search boxes which pulled the value then the code checked if those labels had values. I had to put a circle on top of the filter icons as I found it was only working if you clicked the edge of the icon/text. The transparent circle on top seems to work.
Thanks. LOVE YOUR VIDEOS!!
Looks good. However would be great if you could provide more context to the gallery that you are using at the very start. I have no idea how to get started and create the gallery that you are using to sort and filter. Thanks
I have videos on gallery designs and styles.
Check - ua-cam.com/video/bnC8u3gdWss/v-deo.html
Thanks again for sharing this wonderful video Reza!! I do have a similar implementation of sorting from before. Then I encountered delegation issues.
I found your pagination video last week and it worked well but was stuck in incorporating my old sort solution. Alas I stumbled on this video and confirmed all the things in my situation.... that complex types won't work, the dynamic variables are not working either, and I have to repeat the same code (filter of 5+columns) for each column I want to sort....
keep up the good work!! :)
Sometimes we just have to write long formulas to get around delegation.
Hi Reza! Thank you so much for your video. It was very helpful. If you wanted to add the Sort Up/Down icon to your choice field called Priority (to make the sorting of that field dynamic also), how would you incorporate that into the formula you have in the Items property of your Gallery? Because in the Items property of your Gallery, you use SortByColumns. But if you wanted to sort your choice field called Priority, you would need the Sort formula instead of the SortByColumns formula. (And I'm not worried about Delegation issues because my list only has about 60 items)
Set a variable on icon selection - up or down value. And use that to define sort direction. I do not have a specific video on this scenario hence giving an idea.
You can also try posting your query on forums in case someone has done something similar
powerusers.microsoft.com
Thanks a lot Reza for your awesome videos. SortByColumns(Filter('Work Trackers',StartsWith('Task Name',TextInput1.Text)&&Priority.Value=Dropdown1.Selected.Value),"cred0_id",Descending). i have small doubt Reza when i compare priority.value=dropdown1.selected.value i'm getting error invalid argument type
Your dropdown Items property must be same type as Priority column.
It would be best if you post your issue with screenshots on the forums at powerusers.microsoft.com/
@@RezaDorrani Thanks a lot
Hi Reza, you are amazing and helped so much with my project. Just wanted to let you know! Keep it up!
Glad I could help! Thanks for watching my videos.
Thank you very much for this wonderful post. I have a question how to sort status where the status is 'Not started' ?
is Not a delegable operator. Sometimes you have to write long formulas to get around it.
Lets assume you have 3 status values
Not Started, IN Progress and Completed
Formula would be
Filter(datasource, Status = "IN Progress" || Status ="Completed")
Reza this is Amazing as usual with all your content. In terms of new videos, I'd love to see you re-do the repeating Grid video but with Sharepoint as a data source and not CDC. Thank you.
Thanks for watching.
I have done the grid video 2 times with Power Apps and Dataverse for Teams.
If I ever do a 3rd version, I will choose SharePoint.
Super helpful video! Was able to troubleshoot and role out my app for user testing same day. Much appreciated!
Great to hear! Thanks for sharing the feedback
Amazing! I am watching this video for the 1st time on 3rd of April 1 year later 😄
Awesome! 😊
Hi Reza, another amazing video, Thanks for sharing!!!... Would it be possible to include the Switch for varSortColumn inside the Filter functions just the same way you did with the If for varSortOrder (Ascending/Descending)?
You can but it will result in delegation warning and will not work with large data sets.
Thank you for the detailed explanation. I'm having trouble with dropdown + OR function.
I am trying to filter my gallery by two dropdowns, either dropdown1 or dropdown2, or a combination of both. Both of these dropdowns are linkd to tables stored on excel. These are "month" and "task".
My main data is in a table called Main. It has a month and task column.
What I want to achieve is by selecting dropdown month, the gallery returns all the items with the month selected or If i click dropdown task, it returns all tasks. If i click both, it filters both the month and the task. Same as your video.
I'm using Filter(Main, 'month' = dropdown1.selected.month, OR(task = dropdown2.slected.task)).
However, this only then filters both combo boxes e.g., when i click the month dropdown, it will not show any results until I click on the task dropdown. It then applies the filter for both, but wont show just the months with all tasks.
There is a blank option in the dropdown which is the first option to prevent accidental filtering.
You need to check if your combo boxes are empty - Check ua-cam.com/video/5dSk5iOgT68/v-deo.html
Also, your expression is more of an AND than an OR.
You need something like this + add logic for empty check
Filter(Main, 'month' = dropdown1.selected.month || task = dropdown2.slected.task)
This is an excellent tutorial, shortened my formula by at least 40 lines and improved app speed
Awesome 👍
Great job man ... lots of vids out there on this subject and you're approach is one of the better ones... you should make a video on brainstorming methods when coming up with logic flows for answering probs like this. 🦅
Thanks so much.
As usual, great video, thanks for helping us accomplish better apps!!
My pleasure!
Thanks for this video, It solved the most demanded features from my app users.
Glad to hear that. Thanks for watching.
Hi Reza, Awesome technic! But I have a person filed named "requestor" from here I would like to search by name . This function isn't working for that person filed. Can you let me know the actual formula?
Check ua-cam.com/video/tPxE_-DcWkg/v-deo.html
That is cool. Your explaination in Each and every step is very clear in all the videos. You're are a Master of powerapps.
Wow, thanks!
Thanks for these videos Reza! Extremely helpful for new power apps users. I did find that the varsortcolumn function inside your switch function was not working. I noticed you said "sort direction" but the syntax shows sort column. Hope this helps anyone else who's sort icons weren't working.
Thanks. I made a mistake on that part of the video :)
Hi @@RezaDorrani Your Videos Really help us a lot !! one thing we can do is change "Sort Direction " in github
@@qayyumkadri2138 Thanks!
Sort direction in GitHub?
@@RezaDorrani yes , you can paste corrected code there with single line note on top.
@@qayyumkadri2138 There are 5-6 such videos where code need correction. I would do so in my free time which is very limited these days.
I have a lot of plans but limited time.
Reza. Nice One as always. Is there a sample template for this app? I want to know how you implemented gallery design.
Never Mind. Google gave me this ua-cam.com/video/bnC8u3gdWss/v-deo.html. I will change my search engine to rezadorrani.com :)
I did a video on gallery designs. This is an extension version of the data table style.
Check ua-cam.com/video/bnC8u3gdWss/v-deo.html
Hello sir....I have provided the sorting to my gallery...I have one button to edit the selected form.....but when I clicked on the edit form of selected item.... there IDs are not getting matched and edit form control is showing error.....can you please help me ..... please reply
I have not come across this issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Very rare content and useful example
Thanks for watching
ANOTHER Life-saver... THANK YOU REZA!!!
Most welcome
Can you please show how sorting can be done in data table ? It will be really helpful ! :)
Logic should be similar.
I do not have a video on that.
Will add it to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
I was wrestling with multiple filters for my gallery. This is a great help, thanks!
Great to hear!
'Brilliant' describes the quality of this session. I face the problem, and there is Reza's video that exactly solves it. Not only solving it, but I learn so much from it.
Thanks so much for the awesome feedback.
Hey Reza, I watched this video in 2022 and implemented the use of variables for sorting the SortByColumns (14:38) formula and it’s been working great. Yesterday, the editor started showing a warning ⚠️ about the use of a variable instead of using the “name directly” in the formula. I believe it is a bug.
When I hover over the variable I see it is set to “Modified” which is the Modified field on a SharePoint list. When I code in “Modified” it stops complaining. When I swap back to the variable, it complains but still works when I select a different column name from the dropdown.
Here is the full warning message: “The expression ‘variableName’ may represent a column that is not part of the data source or has not been downloaded. Consider using the name directly.” The source is a collection.
When I view the collection, all columns listed as options in the dropdown are present. The warnings disappear when I directly use the name.
Authoring version is 3.23.114.25 but published with 3.23.113.30 for some reason.
Sorting by variables still requires us to hardcode the column names by using If condition for sorting.
I have not tested this video in a long time so not sure if anything has changed.
Hey Reza, Thanks for your videos. I am learning alot from your channel. I am working on a vehicle inspection application. Can you just make a one tutorial to how to create a tabbed form and give the user an option to take an image and save it in a particular record. I mean with the information and the image .It ll be helpful. Thanks.
Thank You.
I do have a video planned for working with the camera control (take an image) and upload to a particular record.
@@RezaDorrani Thanks for the reply. I ll appreciate this. Please do it. It ll be very usefull.
@@lohitdevgan6799 It's in my backlog
This is an amazing video, thank you very much.
Is it possible to sort record type columns such as Choice, People or lookup?
Possible. I do show Choice column sorting in video. However, it will run into delegation issues.
@@RezaDorrani Thank you for the reply. To avoid delegation could the switch technique you used @19:49 in the video be used on record columns?
Also, just a heads up I believe lines 14 and 45 in the github syntax should be VarSortDirection and not VarSortColumn. took me awhile to figure out why mine was not working.
@@jbo1253 It would not help with delegation.
You are correct on that mistake :)
Hi Reza,
I applied this to my Gallery, but for the drop-down code I keep getting the following error: Incompatible types of comparison, these types can't be compared: Table, Text. Is that because the Item value in my dropdown is in a table format?
I have not come across this issue & hence not sure what the resolution is. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi there I think you can only solve my issue. I have gallery. I would like to achieve these three functionality.
Filter gallery by logged in user.
Sort descending
And also search the gallery by ticketid, priority and status. Priority and status are choice column. The third condition, I will give the search string in textbox.
Please help to get the code as I am unable to achieve.
I would have to recreate your scenario to provide any guidance. Search is not a delegable function with SharePoint as a data source. So you may want to replace that with StartsWith function. I would recommend you post your query with screenshots on the forums at powerusers.microsoft.com and check if someone has done something similar.
Hi Reza, brilliant video again. I have question: I wanted to make the filter in 2 columns instead of one like:
SortByColumns(
Filter(
Missions,
StartsWith(
Title,
TxtUID.Text
) ||
StartsWith(
'Mission Name',
TxtUID.Text
) &&
(Status.Value = DrpMissionStatus.Selected.Value || DrpMissionStatus.Selected.Value = Blank())
),
"ID",
Descending
)
However, is not filtering in both the text input box and dropdown box simultaneously. What I am doing wrong? thank you...
Try
SortByColumns(
Filter(
Missions,
(StartsWith(
Title,
TxtUID.Text
) ||
StartsWith(
'Mission Name',
TxtUID.Text
)) &&
(Status.Value = DrpMissionStatus.Selected.Value || DrpMissionStatus.Selected.Value = Blank())
),
"ID",
Descending
)
I tried that, however, if nothing is selected from the dropdown, the gallery gets empty.
@@amigomusa DrpMissionStatus.Selected.Value = Blank() part should do the trick for empty dropdown selection. Must be something to do with how your dropdown is setup. Tough to help evaluate the issues on this chat. I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/
@@RezaDorrani I appreciate that, thank you so much. Posting it there
@@RezaDorrani I figured out the issue was with my dropdown setup. I changed "AllowEmptySelection"=True and turned Default=0. Now it's working perfectly. All thanks to you!
This method is by far the easiest I have seen to achieve the end result. Thank you Reza!
Thanks so much Dan
Hi Reza, Thank you very much, Your videos are amazing! I am following your directions for sorting functionality and got an issue, I wonder if you could give some guidence. I have a horizantal container and inside i have a data table(similar to your service desk app with responsive design), In the data table i inserted sort icons on column headers. for some reasons the icons are not getting aligned properly with data table headers, are there any known issues in using table and icons in side a container?
I have not come experienced this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you you saved me a lot of time with this video 😎😎😎😎
Glad it helped!
@5:21 SortByColumns doesn't seem to work with complex column , Sort function works fine.
Your statement is correct.
This is indeed a great video. But why i'm getting an error "specified Column Does not exist or invalid Sort Column Type" when i click the icon sort? what did I missed out?
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
I have a sharepoint list with repeated values for the name field value and I need to display them in a gallery with the unique values and grouping values according to the match. How do I do it?
thanks
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
There is always this one hater lol. Great work man!
They are my fans :)
I feel everyone is entitled to their own opinion. As long as constructive feedback is provided, I am fine with it.
Thank you Reza for your video. But I am unable to show all records in a gallery as you have done in your video. Could you help me in guiding how to do that?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Awesome video. Thank you for covering the delegation part. It is very useful.
You are most welcome
The sort dynamically is not working for choices and number column types
Was this shown in video?
Great content again. Thank you!
Is there a way to search with "Contains", not "StartsWith"?
I've tried combining the knowledge from your other video: ua-cam.com/video/5dSk5iOgT68/v-deo.html but couldn't make the search function work :(
Here is the video that explains "Contains" ua-cam.com/video/zxZGaXQlZqo/v-deo.html
@@RezaDorrani Thank you! Helpful as always. :)
thank you. Is there any way to accomodate complex column within this dynamic sort?. i.e. sort of priority column from your demo?
You would need to table shaping formulas like addcolumns to get the text values from complex columns and then sort on it however those formulas are NOT delegable
Hi Reza, Quick Question - You have very well explain about the deligation issue here but again if i want to use In() function for filtering my text column it again gives me deligation exception, is their anyway i can avoide this deligation issue for in() function
i am using this formula
Filter(
'Assignments',
(txtAssignmentID.Text in AssignmentID || AssignmentID = Blank())
//StartsWith(AssignmentID,txtAssignmentID.Text) || AssignmentID = Blank()
)
And one more question is their any way to filter ID column if default value of ID is blank -
Filter(
'Assignments',
(txtAssignmentID.Text in AssignmentID || AssignmentID = Blank()) &&
(ID = Value(txtID.Text) || ID = Blank())
//StartsWith(AssignmentID,txtAssignmentID.Text) || AssignmentID = Blank()
),
In function is not delegable with SharePoint as a data source. (assuming you are using SharePoint)
Hiii Reza i have tried the same approach but getting error at column level as invalid sort column type after adding more than three functions under switch condition
I have not come across the mentioned issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Thank you!!! This is what I need for my app.
Glad to hear that. Thanks for watching
Hi Reza, I am new to Powerapps. I am unable to wrap my head around a problem in Filter function. Hope you can help. I am using Google Sheets as db. I have column by the name of Item which has values in which Item name is repeated a number of times. Each Item name has an associated value in the next column called Buy(Number). I am unable to filter and sum the values of Item Name. Formula like this Sum(Filter(checkdb,Item=dd5.SelectedText)Buy). Iam getting an error in label control. Thanks.NoteThe dropdown has distinct values.
I would have to recreate your scenario to look into what the potential solution is. Difficult to do so here on chat. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Muito bom, obrigado pela aula,ja irei seguir voce!!!
Thanks
Hi Reza,
In the last part of the video, where you talk about delegation due to dynamically defining sort column, could you explain scenarios where this delegation warning would actually return wrong output? Or will we practically never face any issues, even though there's a warning (provided that our dynamic column name assignment is valid).
I have experienced that not all warnings are actually problematic e.g. countrows with firstn etc. delegation issue.
Could you please address this? thanks :)
Give me all items from my SharePoint list sorted in asc order. If sort column is dynamically defined will result in delegation and Power Apps will load only the first 2000 records (assuming thats the delegation limit) in memory and then sort them. All other records in data source would be ignored.
Delegation warning will never be a problem in case of data sources less than 2k records.
@@RezaDorrani Ok, then how do we solve for dynamically defined sort columns with delegation in mind?
@@kx2793 That is a limitation.
you are the best Mr Reza, thank you for everything
Thanks Salim
The King of Power Apps. Thank You!
Content is 👑
Thank You
Hi Reza,
This is great and I have an issue.
App works fine on start and when I sort again, sort is not working for more than 100 rows and I see “loading data” notification.
FYI- I’m using SharePoint as source and data table to display items.
Any help is much appreciated.
Thanks.
I will have to look at your App in action to know the cause of your issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Thanks for the great contents including this video. I have a question regarding delegation warning when I apply "&&", "||" or "in" operations with related column on a different table. See "&& (txtSearch.Value in Asset.'Asset ID' || txtSearch.Value in Asset.'Serial Number')" in the code below. How do I resolve the delegation warning for this?
If (
txtSearch.Value = "" || txtSearch.Value = Blank(),
Filter(
'Work Order Line Items',
'Work Order'.'WO Number' = workOrderId
),
Filter(
'Work Order Line Items',
'Work Order'.'WO Number' = workOrderId //&& (Asset.'Asset ID' = txtSearch.Value)
&& (txtSearch.Value in Asset.'Asset ID' || txtSearch.Value in Asset.'Serial Number')
)
)
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@popgugu You cannot sort on complex columns directly. Its shown in video. I will recommend posting your issues with screenshots on forums.
Hi Reza, whats the version your power apps in this videos, Congratulations for videos ...
Video was done over a year ago. Whatever was the latest version on that day
PERFECT!!! Amazing work brother!!!
Thank you! Cheers!
Hi Reza: If I were to mimic exactly what you have in this Video, I need create SharePoint Lists with appropriate data SLT/Choice/Date/Person/Lookup columns. "SHOW MORE" does not list such screen captures. I can do this and populate some real looking data by watching the Video. But, have you provided data used in this Video somewhere?
The data in my App is in a SharePoint list. I have not loaded or provided the data anywhere. It is just sample data I added for demo purposes.
"SHOW MORE" does not list such screen captures - I did not understand this.
Hello sir....I want to provide sorting by On select of button.......
You would need to use variables then to do that. I do not have a specific video reference on this though.
Really Nice. I always learn something.
Glad to hear it!
Hi Raza , thank you for your effort , can you please explain how can i filter a blank value or sort by a blank value
I have done many videos on filtering. Check my playlists.
Hey, thanks for the video! Everything seems to work great, but the sorting only goes in one order. Your arrow changed but the numbers didn't (at the very end). I'm having trouble figuring out how to fix this, any ideas?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Another amazing tutorial. Always in anticipation of something new in your videos. Keep it up.
Glad you like them! Goal is to show something different each time.
Thank you! Does this work on the Data table too?
Yes. Same concept will work.
Hi Reza. I'm trying to combine SortByColumns with a Filter not based on a text input. This uses a context variable on button OnSelect: UpdateContext({SortDescending1: !SortDescending1})
- My gallery filter function works like this: Filter('testRaw Materials List', Customer.Value = "Spring Sheep")
- My SortByColumns works like this: SortByColumns( 'testRaw Materials List', "Title",If(SortDescending1, Descending, Ascending))
How do I combine these two statements? When I use syntax similar to what you've done in 10:37 I get an error. Using SharePoint List as a datasource
I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
I hv a so list with 20+ number type columns (cost centres)
At the movement I can filter based on a string value
How do I sum by columns please
I want to filter results and add to a collection and show the sum for each column in a gallery .
Show some direction on this please
Key is to avoid delegation. Check ua-cam.com/video/qsIn0mytC_8/v-deo.html
Probably a user error but I could not use "varSortDirection: Ascending, Descending" with SQL Server. I made the necessary changes and used "varSortAscending: true, false"
If(
varSortAscending,
Ascending,
Descending
)
I will have to look at your App in action to know the reason for the error. Should work with SQL as well. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
this functionaly dont work with excel file taken through one drive for row more then 2k
Excel data does not support delegation.
how did you have table format after getting data from sharepoint? I am trying to use excel sheet but I am not getting the tabular layout and second... what did you code for text box and drop down menu?
I customized the gallery design.
Check ua-cam.com/video/bnC8u3gdWss/v-deo.html
how do you change filter icon from empty to filled? Thanks a lot for this video
If any of the filters have a value, I change icon style
This was great but for some reason, only the last of three sort columns I'm using is working for me. Selecting the other columns returns no data to the gallery when I run the app.
Not sure what column types or data source you are using. Tough to provide direction without looking at screenshots.
I would recommend you post your issue with screenshots on forums at powerusers.microsoft.com/
Things go crazy when you apply pagination. Can you add Pagination on top of it.
Pagination is not needed for galleries.
Check delegation video - ua-cam.com/users/live0nhGaQ_J278