Shane, I can’t even begin to express my gratitude. I’m so glad I found your channel. Your videos will help me and my small business to skyrocket. Thank you so much. You just gained a new subscriber buddy.
I have done novice programming over many years to support my primary job function. Our IT department recently forced me to abandon Visual Basic and switch to PowerApps. Thanks in great part to your videos, I was able to develop a moderately complex app in a few weeks. Whenever I got stuck on an issue I would ask, "What would Shane have to say about this?". Not only are you a Power Apps Guru, your presentation and ability to explain Power Apps is top notch. Hey, do they award Emmys for You Tube videos?
@17:41... I tried that and it does not work... I have a dropdown menu in SP and have it listed here in PA under the Text property as ThisItem.'Form Status' and it throws a red line saying This Formula uses scope, which is not presently supported for evaluation. Data Type: Record.
I am guessing ThisItem.'Form Status' is not a text column but a choice column. Complex column. Try ThisItem.'Form Status'.Value or similar. This video will help you understand the concept more ua-cam.com/video/d1xR-YZifxo/v-deo.html
Thank you Shane. I got lost where you delete ThisItem from the Items property on 15:45 and on 17:35. I get an error when I remove ThisItem. It would also be great to include your data sources. I'm getting confused about where you are getting the values that you type in the Filter function around 18:20.
ThisItem used to be optional. Now it is required. Some of my data sources info and lots of the apps are available to subscribers at training.powerapps911.com to the Curated Library.
Shane. How do I put a button that searches in a (large) Sharepoint for the User and any of the other columns, but get too many hits so I need a secondary search of the supplier, so first it was user "x" and supplier "any or all" by default but then it's User "x" and supplier "intel".
I love learning from your videos. I can actually assess the tiny details and hurdles that we come across when using powerapps. Indeed learning the trouble that goes into making a pie
Great tutorial Shane but my issue is a bit different. I need to filter values from a table BEFORE loading those items into a gallery. The attribute I need to filter by is a type 'Choices' in the CDS/Dataverse table. I was able to filter against a simple text attribute.
Shane, you are simply the "go to" for so many of us - thank you! The videos are fantastic. I wondered if you can point me to a video where you show how to use "If" with Filter. So for example a gallery would only display those who's favourite colour was RED but only IF they were older than 32 (trying to put this in terms of your data). I have tried using two labels (one showing a criteria for IF and a second for the FILTER criteria. Something like If(AgeBox.Value > 32, Filter('Employees', FavouriteColourBox.Text = FavouriteColour.Value), "")) but I am missing something. I hope I am describing what I want, and I am sure it is an existing video somewhere. Would love a pointer. Again thanks for your helpful videos
Hello Shane and thanks for all the knowledge you share. Do you have any example of a gallery within a form that populates with the information that I write in that form? Example (but is not what I'm going to do), an invoice system. Where for a client you should write several lines of products. Do you understand what i want to do? Thank you.
Hi Shane, Thank you for the video, I am new to Powerapps,
1) Can you explain the line at 15:38 which says Project = Gallery2.Selected.ProjectName in filter function. 2) what is the data type of "Project" column. 3) what is the data type returned after using Gallery2.Selected.ProjectName ? 4) I am asking these because I had a lot problem when I tried to filter Contact gallery when user clicks on Account gallery. For this I used following code Filter('Contacts', GUID('Company Name') = GUID(Gallery1.Selected.Account)) . I do not know how much good is this for performance wise. Thank you Shane
Hi Shane, Thanks for your videos. I have an app with 2 dropdown filters and a search box. But now Im trying to create a button that will clear all the filters and give me all the list . I tried a few ways but nothing seemed to work well. Do you know how I can do that?
Usually, in those complex scenarios, I use the filters/search box to create a collection. And then have the gallery just show the collection. That way my reset button can reset the controls and the collection.
Great videos...I may be searching the wrong things... but what video would I watch to find out how to open a full record after I have filtered it down?
Kelly it depends. If you are using a gallery to find a record and then want to view it you will most likely want to do that with a form control. ua-cam.com/video/yT4gGVunU0o/v-deo.html Or my free 101 class might help you connect the dots better. training.powerapps911.com/courses/power-apps-and-power-automate-getting-started
Hi Shane. I can't seem to figure my issue out. I want to create a gallery that filters a master list of employees from SharePoint. The filter would be their employee number. I need the gallery to see which employees are listed on various other SharePoint lists. So if an employee is on the master list, the gallery would show which, if any, of the 4 sub lists I have.
Hi, Can we search multiple text fields of gallary ( like.. Title, place, manger etc...) from single search box.. using Filter option. Note: I am already showing a specific user data in the gallery
I want to add a filter box for the SharePoint ID field. It does not like using Text=ID. It says there is a Incompatible type (text vs number). But typing Number in place of Text does not work either.
How do you do the multiple filters using a search box as well? Is that possible? Thank you so much for the video it was great and very helpful the best one yet bc you included some ways it could break.
Amy this video show Search around a filter. I think that should get you on the right track. 😁 Power Apps Search and Filter Function with SharePoint + Workarounds ua-cam.com/video/lYi24okXDPs/v-deo.html
How do you filter for more numerical and text data fields in one 'search box'? My database is 'Office Equipment', while my text field includes 'Department name' and numerical field includes 'serial number'. How should the code look like?
Thanks Shane, Pretty new to this and love your videos. I'm trying to add a Filter to show all records except for one type. I can set the 'Project Status'.Value = "Open" and I know I can't use "Closed" with SP lists. How can I show all records except those the are marked as "Closed"
Hi Shane, thank you so much for this video. Can you please confirm/help if this works with same list as well? Means I would like to show all the items belongs to 1 category in a second gallery.
Hi Shane great video I have a filtering question I hope you can help me with. I have one SP List called Hospitals and Sponsors (SP List1) that is a list of that I need to use to filter data selections in another list called Project Requests (SP List2). The filtering needs to work on both New and Edit SP form modes. For example, I have a field called Request Type in both lists that has the values of Hospital and Non-Hospital and a field called Location that has values of States (AK, AL, ME) for hospitals and "Corporate" for Non Hospitals . When I select Hospital in SP List2 I need my location field in SP List 2 to go to SP List1 figure out all the locations that match "Hospital" and filter my Location drop down in SP List2 to only match the locations found for "Hospital" in SP List1. The idea is the customer can add new Locations in SP List1 and they will just show up when they are adding new Project Requests to SP List2. Would you have any ideas on how this could work? Also if the customer edits the item I also need "Location" in SP List 2 to show the saved value in SP List2 but also only show the filtered values allowed. Any advice would be appreciated.
Look at one of my videos on relationships. I think that will help. Maybe this one ua-cam.com/video/43ekj5MlNJU/v-deo.html which isn’t exactly what you want but the right concept
Thank you so much for your videos. I will be grateful to you if you can guide me that how can I use Distinct with the Filter results that we have received. I am using a combo box whose feed comes from the filter command of another drop down.
I am first using Distinct (Table2, Final_Status) This helps me find out the status of the material using table 2 that whether it is delivered, in inventory or production. Once this is doing out I used control box to filter only those customers whose materials are delivered , in inventory or production . The issue that I am facing is that I am not able to find the distinct customer names because there are multiple materials that are brought by the same customer therefore the name of the customer is repeating multiple times in the drop down of the control box. I am trying to make an app that provides the status of the customer order. And have a table with all all the status and customer order. I need to filter specific fields depending upon previous chosen values. So I made dependent control boxes over the other control box inputs. I hope this makes it clear.
@@ShanesCows For the drop down = Distinct (Table2, Final_Status) I use a drop down This drop down feeds into Controlbox Items = Filter(Table2, Status = 'Dropdown1 - Status'.Selected.Result) Display Fields = ["Ship-to_x0020_Name","Sales_x0020_Document_x0020_Item"]
Question: You use the galleries a lot to reflect data. Is it possible to do the same thing in a table format, showing rows of data? I find that the gallery isn't as attractive for the data I have.
There is a control called Data Table that does what you want. But it doesn’t allow any customization. Customization is why I like Galleries so much. If you play with them you can make them look anyway you want.
Hi Shane! Is it possible to use this function if I have one list, where I would like see the items in gallery 2 based on status. So I have two lists like you, the first would be something like "active, closed, in progress" - Gallery two should show the items that is in active if selected in gallery one? How would one do this - or are you able to link to the data sources that you have used to see the information? :) Have a nice day!
Hello Sir, i have the SP list, in which Title Column is empty(i'm not using it) how can i use Filter/search in Multiple columns like Numeric Column, Date Column & Text Column. Filter('List', StartsWith(Title, TextSearchBox1.Text))
StartsWith only works on text columns. YOu can filter on a choice like so Filter(SharePointList, FavoriteColor.Value = "Red") assuming FavoriteColor was a choice column and Red was a value for it.
Hi Shane - Thanks for all your videos. I can't figure why Filter isn't working for me unless I press enter and it has to be the exact location. I've tried to add StartWith and nothing happens. The Default for the Gallery is blank. Any suggestions to troubleshoot?
Hi Shane, How do I filter a table from a guid/lookup colum from a different table with an equivalent of "Not In" operator? Example There are three tables OOTB tables in D365 Field Service. Opportunity Name: ABC Opportunity Product Opportunity: ABC Product: 1 Product: 5 Product: 10 Product: contains 1 - 10 What kind of Filter syntax to show a list of products that are not in the opportunity ABC? Meaning, the result should return product 2, 3, 4, 6, 7, 8 and 9.
Hi, Shane Young! Great video, btw. But i have question. How can I filter sharepoint list using values from other list. My process is I want to check if this value from ListA is existing from ListB, then if true, i will show the data. Thanks!
@@ShanesCows The thing is I want to use it inside of my ClearCollect function. If this value exist on another list, I will collect the data. Thanks! :)
If I get this right... the StartsWith will only search for titles starts with the search text, what about search for text within the title? in which is not delegable? So what is the choice here?
Hi Shane, thanks for your very useful videos. I have a similar situation in my project, my biggest difficult is this: How can I do to filter gallery2 starting from value of "task" in gallery3?? Using your example: In my search text I write "Go to the kitchen" as a task, and in Gallery2 my result is "Do the dishes" ??? I'm trying using "in" in my filter but I have delegation problem!! I'm doing crazy!! Have you some suggestion for me???
Hello Shane, Many thanks for the nice tutorial. I have a question here. How can I filter an entire screen based on several criteria? For example: I have two Cities New York and Washington. When the user opens a specific Screen, then all the items should be displayed which comes under Washington only. How to achieve that?
What about gallery filters based off numbers? "in" will cause delegation issues, Startswith doesn't work on numbers, and using "=" will work only on exact matches. Is there a proper fix which will search for parts of numbers (let's say a staff number), but also be delegable?
Hi Shane, I just wanted to say thanks for the great videos. I am currently forming some apps for our business in my spare time and your videos are really easy to understand. I will inevitably end up getting a proper engineer on the job but for the time being your input has been invaluable. Take it easy
Awesome. Keep up the good work. I will do my best to make enough videos you can do it all yourself. Also, I will mention if you need help I am always available for consulting. ;)
Is it possible if the column condition is a variable? Example below: Filter(EXTRA_EMP_FIELD, LookupExtra = LookUpValue) where EXTRA_EMP_FIELD is the source and LookUpExtra & LookUpValue are variables
Hi Shane, how to use Filter function to search using more than one column in SharePoint in same form? for Ex. if i have a sharepoint list with 3 columns, I would like to search for the 3 columns
hii Shane This vedeo is really helpful.but i want to ask one question.Is there any raw limitation in sharepoint? because im facing problem in id incrementing when sharepoint data exceeds500. pls consider my question. Thank yo
How do you make the Gallery in your Items property display those values when two conditions of a SharePoint data source are met? I only want to show in the Gallery the items that have an attachment and that in its Status field its value is "Valid".
@@ShanesCows Thanks a lot Shane, I tried that same line of code, but since I'm handling HasAttachments (True/False) the syntax appears to me with a warning symbol and doesn't filter out items that meet two conditions.
hi... as usual great video on filter function. how can i search multiple columns like name or address or phone number (means or criteria) from a single text box using filter function... can u plz let me know?
Thanks a lot for your videos it's great help! What I am looking for now though and couldn't find its a way to add multiple new records to a SharePoint list. Is it possible at all?
Thanks so much for these Shane. I am wondering if it is possible to filter on multiple SharePoint lists at the same time. I have three lists with a shared column name through each of the of "Independent_Contractor_name" (There are more columns with the same names but this is my example) and I want to build an app that lets someone see the information from all three lists at the same time. I am pretty sure it is possible but haven't gone far enough into your videos to find it yet.
Hello Shane, Oracle of PowerApps. Filter Question involving SharePoint: I have a list currently under 500 items, but could go over 2000. List is Grouped by Status Open and Archive. Typically, there are under 30 items "Open" at anytime. Filter(List_Name, Status="Open") Despite the Delegation Warning, can I use this formula? Will it filter the 30 programs when the list size goes above 500? Delegation is a confusing topic.
Yes, the list being bigger than 500 isn't an issue. It is about getting your filter operations correct. Best idea? Change your Delegation limit to 1 and then see if you can make your data all come back. Easier testing. 😀
I have another problem with filtering a gallery. I created a gallery based on an Excel table. In the gallery I added a label in which I show data by a look up function which come from a sharepoint list. Now I want to filter the gallery by the information given in the column with the look up function. Is this possible and how?
Hi Shane, Great video, Small request , Kindly show us if you using any lookup data columns from SPO lists, Could you please let us show also list data another videos how using in power apps
Is there any way to filter a gallery by multiple values? Example: I have a choice column where options are Blue, Red, Green, and Yellow. On my search page I want to be able to filter the gallery by any of those combinations. First choice is check boxes but seems that this is unsupported unless you use an If for each combination (which could get really long). Do you know of any other ways to solution this?
It is a complex one. Basically, you have to put all of the data into a collection, then you filter that collection based on the values of the dropdowns. We use this technique but hard to explain in a comment.
@@ShanesCows Thank you for the response. I do have some other ways of filtering in my app by text boxes and drop downs (thanks to your videos). With the drop down I still think I'd be limited to the one value to filter by (ex. only items where choice field is blue, not items where choice field is blue or green or red not yellow) which doesn't quite capture what I'm trying to do. Hopefully some kind of support for this gets added
Hi Shane, lovin' the videos! I'm having an issue and am not sure if it's due to the changes in PowerApps over that past year: I'm being told that I've created a circular reference every time I follow your steps. Thinking I did something wrong, I started from scratch a few times, but still nothing... any thoughts on this?
I enjoyed your video. But I'm having a problem duplicating the process with nested gallerys. my filter expressions looks like this: Filter(SO_contracts, Client_ID = Gallery2.Selected.ID) I get the following error: incompatiable type, the left value is a Number and the right value is Text type. Client_ID is Number Type and gallery2.selected.id is Text type. how can i fix this filter to make them compatible. I would appreciate your help. Thanks
Hi Shane, in your search video I watched before this, you had the issue (right at the end) where you created your app from a Sharepoint List which only searched based on Title, and you mentioned looking at and fixing that issue in the filter video. I still can't seem to work this out...my app only searches on my title, but I have a contact list where I want users to be able to lookup contacts based on contact persons name, title (organisation), contact number or email address etc...So I want search to work based on multiple fields. Is there a way to do this? Thank you :)
Hi Shane, I am struggling with displaying my search results on a different screen. I have used the filter function to search and I would like to add a button called 'Search' that enables the results to display on the next screen. Please help!
Hey Shane! thanks for the video it was so helpful, i was wondering if i would still be able to use the groupby function with this filter I have a gallery with many replicated items at the moment I have this- Filter('Index Resources',WWorEMEA= MyProfileResources_1.Selected.WWorEMEA), GroupBy('Index Resources',"titlegroups","empty2") where empty2 is where I want to group the data and titlegroups is what I want to group from my sharepoint list (index resources)
Good afternoon, I would like to thank you for all the content you post, I am Brazilian here there is content but it does not come close to your explanations. Thank you very much for your time and dedication, I will continue to follow your publications. Sorry for the writing I am not very good at the language.
Hi Shane!!! I am filtering sharepoint list data same way as your video But I guess yellow delegation warning saying "Delegation warning. The highlighted part of this formula might not work correctly on large data sets. The "CountRows" operation is not supported by this connector. The data source might not be able to process the formula and might return an incomplete data set. Your application might not return correct results or behave correctly if the data set is incomplete.". How to get rid of this. My formula is "CountRows(SharePoint ListName)". Its working but warning shows up.
Hi Shane, Thanks for your videos, they're a great asset to power-apps. I have a question. When you select the play button on top right to view the gallery, I don't get any fields showing up. Just a blank screen. Any idea why this maybe the case? Thanks in advance.
Hi! great vid, little question. Is the Title that you use in the logical test the name of the column in the sharepoint list or the name of an element inside of the gallery?
Hi, firstly, thank you so much for sharing :). I want to ask a question that instead we use 3 different datasources, can i use only 1 data source but show different fields? For example, i have a SP list contained all fields from Project name, project task and project detail. Can i do the same as yours? Thanks in advance and hope to get your response.
I have an issue: I have a gallery that is selectable, and based on that it filters another gallery on the screen. Both galleries' data sources are from different Sharepoint Lists, but have a unique "key value", let's say their Family name. So it's a one to many relationship, Surname table has only one Smith, but First name table has many Smiths. Let's say I click Smith, in another gallery I get John and Jane. But my problem is that I would want to do the reverse: when I click John, I want to see Smith chosen in the other gallery. I wrote the code for this reverse gallery exactly like the first one I have (which works fine) but it doesn't show any items in the table where it should say Smith. Is there something structurally built in Power apps which prevents these many to one connections? BR, Mika
Hey Shane, thank you for the video. First off I'd like to say I am a complete beginner with PowerApps and coding language and this is also my first attempt at a PowerApp. I'm having issues using my TextInput box to filter my data source. I tried using your formula but everytime PowerApps says that the TextInput box is unsupported for evaluation due to my data source being "data type = table" and my filter text box being "data type = control". Instead of trying to filter a sharepoint list gallery I am trying to filter a gallery for an Excel spreadsheet from OneDrive. Is there a different formula I have to use? Below is the formula I am currently using from your video. Formula Filter(datasource, FilterTextBox.Text = Title) Thank you!
Hi Shane! Once Again big Fan!!! Lets say now you have a team assigned for the project activities and when one fofthem Mark it as "Completed" notify all teammates on the project Thanks!!!
Hi Shane, thanks for all your videos. Do you have a video about using the 'Search' or 'Filter' function for a 'Choice' column in a Sharepoint list? No matter what I try, I get an error message - usually along the lines of 'Wrong type. Expects text type'. I trawled forums and documentation high and low but can't find any useful information on this. I would love for end users to be able to search for items by the 'Week' choice column in the Sharepoint list (eg: Week-01, Week-02 ...etc).
Shane, I'm having similar issues as threewiseman1. Looks like I am running into delegation problems when I try to filter by the choice column from the sharepoint list. I've figured out that I can create a collection from the sharepoint list, add a new column using the values from the choice column and then filter from the newly added column to get the gallery to show what I want. However, this doesn't help the overall project I'm working on because I still need to be able to edit and update the original sharepoint connection in the edit screen. How would I do that? The project I'm working on is a simple status update app that a field agent can use to respond to new task requests entered in the sharepoint list. The sharepoint choice column that I'm referencing and having trouble with happens to be a status column. SInce there are many rows in the list, it only makes sense to display SP list records that are "open" and filter out the ones that are "complete." Am I on the right track with using a collection on the gallery?
Hi, I love your videos, but I am still unable to filter and sort my products by the gallery. I have 7 rooms, and each room has its own inventory, and I want it to sort and filter items available per room. Please help.
I have problem about filter in my apps. In sharepoint I have 5 column , 2 in 5 column set choice type. I cannot filter it in power apps. Please let me know how to fix them.
Good afternoon Shane! Thank you for your videos. They have helped me a great deal in my new job as a Power Apps dev (I was a software tester for almost 10 years). I have been making updates to our company's internal newsletter, which is created using a canavs app, and sent out via a power automate flow. In the canvas app, there is a search box used to find existing entries, but it is clunky and doesn't return all of the results. My data source is a Sharepoint list that currently contains just 640 entries (It has been around 2021, and is growing). I want to improve the search function so I want to use a filter function that will look at several columns in the SP list. How can I fix the following formula so the red triangle goes away? Search('Weekly Digest', TextInput1.Text, "Group", "Category", "Title", "Narative", "Client") TextInput1.Text is the new text box I created for the employees to enter their keywords (and where I want to put my filter function). I realize narrative is spelled incorrectly... but that it how it appears at the bottom of the screen when you highlight the column name in the SP list setting screen (the list predates my employment here). Also, I need to make sure it is truly searching the keyword(s), and not only finding an item the if the search term is the first word. Can you help me?? Thank you in advance!
Hi Shane, My Name is Raoul Elias Miraglia and I am currently working on a Power App (source: KVP) with a Gallery and many filters. However, when filtering the gallery with one specific filter and editing one of the filtered entries, the altered entry does not show up, but still the old one. Only when adding another filter to the gallery it updates the entry/data. The Refresh button with the function Refresh(KVP) does not work. Why? Do you have any idea how to solve this?
Can I use FIRST function within this FILTER function? I have this : Filter(Customers, 'AccountNum ' = "CTLE001") I know LOOKUP function does it, but I´d like to try using FIRST with FILTER function.
Hi Shane, can you please tell me how to change gallery selected item on button click or any other event, like passing as parameter to change the slected item of Gallery ?
Great video again Shane. Is there a way to created Sumifs in powerapps? So if I wanted to do something like the following how would this be done. Sum of column Days, where column Name = Name=User().FullName and column Status = Approved So in Excel it would be something like =SUMIFS(H:H, G:G, "Approved", A:A, "Craig Jenkins")
Hmmm. In my head it is something like this: Sum(Filter(datasource, Name=User().FullName and column Status = Approved), Days) That isn't working code but I think enough to get the wheels turning for you.
Hi, Shane. How are you? I've been trying to filter a gallery by a specific field of a SharePoint list. It works well, but it doesn't update the data when I make some change in the list. For example: I want to display every record which the field Status is equal to "FALSE" (Filter(My_List,Status = "FALSE"); when I update the Status to "TRUE", the records are still displayed, even though is "TRUE". The gallery is just updated when I refresh the PowerApps website, then I can see the result I want. Do you know what might be the problem? Thanks in advance!
Shane thank you for the numerous videos and information. I'm looking for a little more help, I have a table (TruckData) that contains a column named "Status" and the two options for status are "in service" or "out of service". I'm looking to create buttons (3 buttons "view all trucks" "view in service trucks" "view out of service trucks") that allow me to filter (or search) my results based on the text in the status field. I feel like this video is close to what I'm looking for but can't get it to populate correctly. Any suggestions?
Hi Shane, your videos are amazing. I have a query with respect to this video, do you have another video which explains how to edit the specific entry which we get as a result of filter?
Hi Shane, another great video! :) I have a bit of an issue with date picking and live filtering; the drop-down boxes and input fields all auto-filter the gallery I'm wanting to fix, but the date-picker (I have two pickers to determine a range) doesn't auto-filter. If another input is changed it'll filter then, but it doesn't filter by itself/doesn't filter live like other. Apologies for the bombardments of questions lately
Hi Shane. Thanks for this video, this was my first day with PowerApps but still it clarified Filter Function effectively ---- but one thing I am not clear of, I am building a simple TimeSheet solution using PowerApps (based on a SharePoint List) in my powerApps list I want to show only those List items which are "Created By" = [Me] ...how can I achieve that?
Thank you for the video's, they have been very helpful and informative. I do have a question though. I have a sharepoint list for Toner inventory, and I want to filter the list to only show Toner that needs to be ordered. I have tried to filter using a calculation from 2 columns, but I keep getting error. The function I tried was Filter(Toners, DesiredQuantity > QuantityOnHand) but I get Fetching Items failed error. Any help would be appreciated. Thanks Again.
@@ShanesCows Yes, both are number columns, I had also created a calculated column called OrderQuantity in sharepoint and had it calculate from those 2 columns and tried to filter based on OrderQuantity being greater than 0, that didn't work either, but that error was expecting text, even though I selected number as the result.
hi, why Filter(Essenplan; StartsWith(Kunde.Value; TextSearchBox_Essensplan_edit_Kunde.Text) ) worked with a delegation warning? why? and what is better for a filter with big datasets ?
How would Filter on Drop Down Box on form be performed. Using 2 columns one shows value some text(Homepage) column and if the Active Column equal to "Yes" then display only those lines to select from.
How can you filter a gallery, if you are using a group column, so if i have there Shane, Mark and Laura, only they will see that information? Like this: ('Created By'.DisplayName = Office365Users.MyProfile().DisplayName) but with a group column
Hi Shane, Thank you for the video - I have no much experience in coding. the way you described using filter is very clear. Thanks again. I am trying to edit a sharepoint list display form in powerapps, to show corresponding records from other sharepoint lists based on a common field in both the lists. How do I put up this condition - If "commonfield" value in the first list selected item is "X", the second list should filter list items with "X" value in same "commonfield". Here "common field" is the field present in both the lists. I tried to put in condition by comparing 2 fields directly from both lists - Filter(List2, list1.commonfield = list2.commonfield) Powerapps say '=' is invalid argument type and 'list1.commonfield' would not work correctly with larger data sets - delegation error! Appreciate your inputs on this. Thanks again.
Hey Shane, There isnt a single day passed in past week without me watching your videos. Keep up the awesome work. I love your videos. Do you have the video explaining about Lookup function using SharePoint lists? If so, can you share me the link?
Shane, I can’t even begin to express my gratitude. I’m so glad I found your channel. Your videos will help me and my small business to skyrocket. Thank you so much. You just gained a new subscriber buddy.
Appreciate that Mario! As a fellow small business owner this make my night. 😎
I have done novice programming over many years to support my primary job function. Our IT department recently forced me to abandon Visual Basic and switch to PowerApps. Thanks in great part to your videos, I was able to develop a moderately complex app in a few weeks. Whenever I got stuck on an issue I would ask, "What would Shane have to say about this?". Not only are you a Power Apps Guru, your presentation and ability to explain Power Apps is top notch. Hey, do they award Emmys for You Tube videos?
😍 I like the idea.
Id be lost without your videos. Thank you sir!
Glad to help.
Just wanted to say thanks for these videos. They've been incredibly helpful for me on the job. (Please, I'm begging) Keep it up!
I will if you promise to keep learning
@17:41... I tried that and it does not work... I have a dropdown menu in SP and have it listed here in PA under the Text property as ThisItem.'Form Status' and it throws a red line saying This Formula uses scope, which is not presently supported for evaluation. Data Type: Record.
I am guessing ThisItem.'Form Status' is not a text column but a choice column. Complex column. Try ThisItem.'Form Status'.Value or similar. This video will help you understand the concept more ua-cam.com/video/d1xR-YZifxo/v-deo.html
Thank you Shane. I got lost where you delete ThisItem from the Items property on 15:45 and on 17:35. I get an error when I remove ThisItem. It would also be great to include your data sources. I'm getting confused about where you are getting the values that you type in the Filter function around 18:20.
ThisItem used to be optional. Now it is required. Some of my data sources info and lots of the apps are available to subscribers at training.powerapps911.com to the Curated Library.
@@ShanesCows Thank you so much Shane. I was beginning to go crazy.
Shane. How do I put a button that searches in a (large) Sharepoint for the User and any of the other columns, but get too many hits so I need a secondary search of the supplier, so first it was user "x" and supplier "any or all" by default but then it's User "x" and supplier "intel".
I love learning from your videos. I can actually assess the tiny details and hurdles that we come across when using powerapps. Indeed learning the trouble that goes into making a pie
Awesome
Great tutorial Shane but my issue is a bit different. I need to filter values from a table BEFORE loading those items into a gallery. The attribute I need to filter by is a type 'Choices' in the CDS/Dataverse table. I was able to filter against a simple text attribute.
You are the most extensive source of insights!!!! Thanks a lot for sharing!!
Awe! thank you. 🐶
Shane, you are simply the "go to" for so many of us - thank you! The videos are fantastic. I wondered if you can point me to a video where you show how to use "If" with Filter. So for example a gallery would only display those who's favourite colour was RED but only IF they were older than 32 (trying to put this in terms of your data). I have tried using two labels (one showing a criteria for IF and a second for the FILTER criteria. Something like If(AgeBox.Value > 32, Filter('Employees', FavouriteColourBox.Text = FavouriteColour.Value), "")) but I am missing something. I hope I am describing what I want, and I am sure it is an existing video somewhere. Would love a pointer. Again thanks for your helpful videos
Filter(Employees, Age > 32 and Color = "Red")
Great Videos. I have just started to work with PowerApps and your videos helped me to build powerful applications.
Awesome 😎
Brilliant. How about a dropdown option that filters a gallery, and a button to clear that filter? Thanks.
This will help. ua-cam.com/video/kLGglidmPxg/v-deo.html 😀
Hello Shane and thanks for all the knowledge you share. Do you have any example of a gallery within a form that populates with the information that I write in that form? Example (but is not what I'm going to do), an invoice system. Where for a client you should write several lines of products. Do you understand what i want to do? Thank you.
I think this is what you want. ua-cam.com/video/xgznk4XlPCo/v-deo.html
Hi Shane, Thank you for the video, I am new to Powerapps,
1) Can you explain the line at 15:38 which says Project = Gallery2.Selected.ProjectName in filter function.
2) what is the data type of "Project" column.
3) what is the data type returned after using Gallery2.Selected.ProjectName ?
4) I am asking these because I had a lot problem when I tried to filter Contact gallery when user clicks on Account gallery. For this I used following code Filter('Contacts', GUID('Company Name') = GUID(Gallery1.Selected.Account)) . I do not know how much good is this for performance wise.
Thank you Shane
Depends on what type of column you made Project.
Hi Shane, Thanks for your videos. I have an app with 2 dropdown filters and a search box. But now Im trying to create a button that will clear all the filters and give me all the list . I tried a few ways but nothing seemed to work well. Do you know how I can do that?
Usually, in those complex scenarios, I use the filters/search box to create a collection. And then have the gallery just show the collection. That way my reset button can reset the controls and the collection.
Great videos...I may be searching the wrong things... but what video would I watch to find out how to open a full record after I have filtered it down?
Kelly it depends. If you are using a gallery to find a record and then want to view it you will most likely want to do that with a form control. ua-cam.com/video/yT4gGVunU0o/v-deo.html Or my free 101 class might help you connect the dots better. training.powerapps911.com/courses/power-apps-and-power-automate-getting-started
Shane... Thank you so much... You have literally made my day... I spent hours on this today and have now resolved!! Thank you so much!!
Hi Shane. I can't seem to figure my issue out. I want to create a gallery that filters a master list of employees from SharePoint. The filter would be their employee number. I need the gallery to see which employees are listed on various other SharePoint lists. So if an employee is on the master list, the gallery would show which, if any, of the 4 sub lists I have.
Hi, Can we search multiple text fields of gallary ( like.. Title, place, manger etc...) from single search box.. using Filter option.
Note: I am already showing a specific user data in the gallery
Yes. Look for my video on Search functionality . ua-cam.com/video/FaTnOOc34os/v-deo.html
I want to add a filter box for the SharePoint ID field. It does not like using Text=ID. It says there is a Incompatible type (text vs number). But typing Number in place of Text does not work either.
Filter(datasource, ID = 1) should be the correct answer.
How do you do the multiple filters using a search box as well? Is that possible? Thank you so much for the video it was great and very helpful the best one yet bc you included some ways it could break.
Amy this video show Search around a filter. I think that should get you on the right track. 😁 Power Apps Search and Filter Function with SharePoint + Workarounds
ua-cam.com/video/lYi24okXDPs/v-deo.html
Tx for the vídeo! I’m struggling to filter a main gallery by data fields inside a nested gallery. Any thoughts?
Yikes. I haven’t done that in a long time. I don’t have an easy suggestion. Sorry
How do you filter for more numerical and text data fields in one 'search box'? My database is 'Office Equipment', while my text field includes 'Department name' and numerical field includes 'serial number'.
How should the code look like?
The search function only works on text columns. 😑
Thanks Shane, Pretty new to this and love your videos. I'm trying to add a Filter to show all records except for one type. I can set the 'Project Status'.Value = "Open" and I know I can't use "Closed" with SP lists. How can I show all records except those the are marked as "Closed"
With SharePoint might be easiest to do all of the positive. Status = Opened Or Status = pending Something like that.
Hi Shane, thank you so much for this video. Can you please confirm/help if this works with same list as well? Means I would like to show all the items belongs to 1 category in a second gallery.
Hi Shane great video I have a filtering question I hope you can help me with. I have one SP List called Hospitals and Sponsors (SP List1) that is a list of that I need to use to filter data selections in another list called Project Requests (SP List2). The filtering needs to work on both New and Edit SP form modes. For example, I have a field called Request Type in both lists that has the values of Hospital and Non-Hospital and a field called Location that has values of States (AK, AL, ME) for hospitals and "Corporate" for Non Hospitals . When I select Hospital in SP List2 I need my location field in SP List 2 to go to SP List1 figure out all the locations that match "Hospital" and filter my Location drop down in SP List2 to only match the locations found for "Hospital" in SP List1. The idea is the customer can add new Locations in SP List1 and they will just show up when they are adding new Project Requests to SP List2. Would you have any ideas on how this could work? Also if the customer edits the item I also need "Location" in SP List 2 to show the saved value in SP List2 but also only show the filtered values allowed. Any advice would be appreciated.
Look at one of my videos on relationships. I think that will help. Maybe this one ua-cam.com/video/43ekj5MlNJU/v-deo.html which isn’t exactly what you want but the right concept
Thanks for the tutorials, you are helping me to keep me busy at Covid 19 time.
Happy to help Andre. Keep learning 😀
Thank you so much for your videos. I will be grateful to you if you can guide me that how can I use Distinct with the Filter results that we have received. I am using a combo box whose feed comes from the filter command of another drop down.
What are your formuls
I am first using Distinct (Table2, Final_Status)
This helps me find out the status of the material using table 2 that whether it is delivered, in inventory or production.
Once this is doing out I used control box to filter only those customers whose materials are delivered , in inventory or production .
The issue that I am facing is that I am not able to find the distinct customer names because there are multiple materials that are brought by the same customer therefore the name of the customer is repeating multiple times in the drop down of the control box.
I am trying to make an app that provides the status of the customer order.
And have a table with all all the status and customer order. I need to filter specific fields depending upon previous chosen values. So I made dependent control boxes over the other control box inputs.
I hope this makes it clear.
@@ShanesCows
For the drop down = Distinct (Table2, Final_Status)
I use a drop down
This drop down feeds into Controlbox
Items = Filter(Table2, Status = 'Dropdown1 - Status'.Selected.Result)
Display Fields = ["Ship-to_x0020_Name","Sales_x0020_Document_x0020_Item"]
Question: You use the galleries a lot to reflect data. Is it possible to do the same thing in a table format, showing rows of data? I find that the gallery isn't as attractive for the data I have.
There is a control called Data Table that does what you want. But it doesn’t allow any customization. Customization is why I like Galleries so much. If you play with them you can make them look anyway you want.
Hi Shane!
Is it possible to use this function if I have one list, where I would like see the items in gallery 2 based on status. So I have two lists like you, the first would be something like "active, closed, in progress" - Gallery two should show the items that is in active if selected in gallery one? How would one do this - or are you able to link to the data sources that you have used to see the information? :)
Have a nice day!
Look at my video on cascading Dropdowns for that concept covered from a different perspective
Hello Sir,
i have the SP list, in which Title Column is empty(i'm not using it)
how can i use Filter/search in Multiple columns like Numeric Column, Date Column & Text Column.
Filter('List', StartsWith(Title, TextSearchBox1.Text))
StartsWith only works on text columns. YOu can filter on a choice like so Filter(SharePointList, FavoriteColor.Value = "Red") assuming FavoriteColor was a choice column and Red was a value for it.
Nice content. If I wanna store filtered results into a variable, how can I achieve that?
To store a table of results you would use a collection ua-cam.com/video/yS6mTRlmuls/v-deo.html
Hi Shane - Thanks for all your videos. I can't figure why Filter isn't working for me unless I press enter and it has to be the exact location. I've tried to add StartWith and nothing happens. The Default for the Gallery is blank. Any suggestions to troubleshoot?
Hi Shane,
How do I filter a table from a guid/lookup colum from a different table with an equivalent of "Not In" operator?
Example
There are three tables OOTB tables in D365 Field Service.
Opportunity
Name: ABC
Opportunity Product
Opportunity: ABC
Product: 1
Product: 5
Product: 10
Product: contains 1 - 10
What kind of Filter syntax to show a list of products that are not in the opportunity ABC? Meaning, the result should return product 2, 3, 4, 6, 7, 8 and 9.
@Shane Young, Do you combine Forms with Galleries using the filter fuction?, could you do something in this direction? Thks
I show that in this video I think ua-cam.com/video/if_mFIfi5PM/v-deo.html
Hi, Shane Young! Great video, btw. But i have question. How can I filter sharepoint list using values from other list. My process is I want to check if this value from ListA is existing from ListB, then if true, i will show the data. Thanks!
Adapt this concept ua-cam.com/video/Ap3_Ea9H8b0/v-deo.html I didn’t want duplicates you do 😀
@@ShanesCows The thing is I want to use it inside of my ClearCollect function. If this value exist on another list, I will collect the data. Thanks! :)
Hi, is it possible to see a screen shot of the three lists you used as the data source for the three galleries? Thanks in advance
Ben did you get this figured out? If not email me and I will send you the screenshots.
If I get this right... the StartsWith will only search for titles starts with the search text, what about search for text within the title? in which is not delegable? So what is the choice here?
Not possible with SharePoint
Hi Shane, thanks for your very useful videos. I have a similar situation in my project, my biggest difficult is this: How can I do to filter gallery2 starting from value of "task" in gallery3?? Using your example: In my search text I write "Go to the kitchen" as a task, and in Gallery2 my result is "Do the dishes" ??? I'm trying using "in" in my filter but I have delegation problem!! I'm doing crazy!! Have you some suggestion for me???
Hi Shane,
How do I use SharePoint dropdown columns as a filter value for the Gallery?
Filter (datasource, columnname = Dropdown.selected.value) should get you close.
Hello Shane, Many thanks for the nice tutorial. I have a question here. How can I filter an entire screen based on several criteria? For example: I have two Cities New York and Washington. When the user opens a specific Screen, then all the items should be displayed which comes under Washington only. How to achieve that?
Set a variable based on the screen and the use that to filter. If will be your friend.
What about gallery filters based off numbers?
"in" will cause delegation issues, Startswith doesn't work on numbers, and using "=" will work only on exact matches.
Is there a proper fix which will search for parts of numbers (let's say a staff number), but also be delegable?
Do you have video on drop down menu + search input text, then filter gallery??
I don’t but that would be fun. This is closer though ua-cam.com/video/kLGglidmPxg/v-deo.html
Hi Shane, I just wanted to say thanks for the great videos. I am currently forming some apps for our business in my spare time and your videos are really easy to understand. I will inevitably end up getting a proper engineer on the job but for the time being your input has been invaluable. Take it easy
Awesome. Keep up the good work. I will do my best to make enough videos you can do it all yourself. Also, I will mention if you need help I am always available for consulting. ;)
Is it possible if the column condition is a variable?
Example below:
Filter(EXTRA_EMP_FIELD, LookupExtra = LookUpValue)
where EXTRA_EMP_FIELD is the source
and LookUpExtra & LookUpValue are variables
Hi Shane, how to use Filter function to search using more than one column in SharePoint in same form? for Ex. if i have a sharepoint list with 3 columns, I would like to search for the 3 columns
With Filter you can do commas. Filter(SharePointList, Column1 = "Red", Column2 = "Active, Column3 = "Shane")
@@ShanesCows Thanks very much Shane
hii Shane
This vedeo is really helpful.but i want to ask one question.Is there any raw limitation in sharepoint?
because im facing problem in id incrementing when sharepoint data exceeds500.
pls consider my question.
Thank yo
Look up PowerApps Delegation in the documentation. That is your issue.
How do you make the Gallery in your Items property display those values when two conditions of a SharePoint data source are met?
I only want to show in the Gallery the items that have an attachment and that in its Status field its value is "Valid".
You can use And in your filter. Filter(SharePointList, Column1 = "Chewy" And Column2 = "Barking")
@@ShanesCows Thanks a lot Shane, I tried that same line of code, but since I'm handling HasAttachments (True/False) the syntax appears to me with a warning symbol and doesn't filter out items that meet two conditions.
hi... as usual great video on filter function. how can i search multiple columns like name or address or phone number (means or criteria) from a single text box using filter function... can u plz let me know?
Try the search function instead ua-cam.com/video/FaTnOOc34os/v-deo.html
Thanks a lot for your videos it's great help!
What I am looking for now though and couldn't find its a way to add multiple new records to a SharePoint list. Is it possible at all?
I think the concept you are looking for is in this video ua-cam.com/video/mbKovagC7As/v-deo.html
@@ShanesCows thanks a lot!
Thanks so much for these Shane. I am wondering if it is possible to filter on multiple SharePoint lists at the same time. I have three lists with a shared column name through each of the of "Independent_Contractor_name" (There are more columns with the same names but this is my example) and I want to build an app that lets someone see the information from all three lists at the same time. I am pretty sure it is possible but haven't gone far enough into your videos to find it yet.
You would need a gallery for each list and set each to filter.
Still watching and learning in 2020. Hope you are safe and well
I am and thank you. Almost to 100 videos so I am still going. Hope the help you
Hello Shane, Oracle of PowerApps. Filter Question involving SharePoint: I have a list currently under 500 items, but could go over 2000. List is Grouped by Status Open and Archive. Typically, there are under 30 items "Open" at anytime. Filter(List_Name, Status="Open") Despite the Delegation Warning, can I use this formula? Will it filter the 30 programs when the list size goes above 500? Delegation is a confusing topic.
Yes, the list being bigger than 500 isn't an issue. It is about getting your filter operations correct. Best idea? Change your Delegation limit to 1 and then see if you can make your data all come back. Easier testing. 😀
I have another problem with filtering a gallery. I created a gallery based on an Excel table. In the gallery I added a label in which I show data by a look up function which come from a sharepoint list. Now I want to filter the gallery by the information given in the column with the look up function. Is this possible and how?
Hi Shane, Great video, Small request , Kindly show us if you using any lookup data columns from SPO lists, Could you please let us show also list data another videos how using in power apps
Is there any way to filter a gallery by multiple values? Example: I have a choice column where options are Blue, Red, Green, and Yellow. On my search page I want to be able to filter the gallery by any of those combinations. First choice is check boxes but seems that this is unsupported unless you use an If for each combination (which could get really long). Do you know of any other ways to solution this?
It is a complex one. Basically, you have to put all of the data into a collection, then you filter that collection based on the values of the dropdowns. We use this technique but hard to explain in a comment.
@@ShanesCows Thank you for the response. I do have some other ways of filtering in my app by text boxes and drop downs (thanks to your videos). With the drop down I still think I'd be limited to the one value to filter by (ex. only items where choice field is blue, not items where choice field is blue or green or red not yellow) which doesn't quite capture what I'm trying to do. Hopefully some kind of support for this gets added
Hi Shane, i have some problem using with dates, mi sharepoint list is type "date", i cant filter, any suggestion please
Yeah you can’t filter on dates in SharePoint. This video might help ua-cam.com/video/UaBmVUQx_Fk/v-deo.html
Hi Shane, lovin' the videos! I'm having an issue and am not sure if it's due to the changes in PowerApps over that past year: I'm being told that I've created a circular reference every time I follow your steps. Thinking I did something wrong, I started from scratch a few times, but still nothing... any thoughts on this?
Joy I am guessing you have the code in the wrong property maybe? What does your formula look like and where did you put it?
Not sure exactly what I had as I decided to tare down and rebuild - of course it's now fine!
Instead of a Gallery can we have a button that opens a view that's filtered by the text?
You could have a button that displays a new screen and shows the gallery with the filtered data.
The filters are not available for 'Excel' database? I try several times to connect the filter but with no luck
Excel isn’t the best but Filter should work.
@@ShanesCows try all the ways possible but each time it shows an error: Filter(Table2 , 'Field' = Dropdown2.Selected.Result) syntax error in position
I enjoyed your video. But I'm having a problem duplicating the process with nested gallerys. my filter expressions looks like this: Filter(SO_contracts, Client_ID = Gallery2.Selected.ID) I get the following error: incompatiable type, the left value is a Number and the right value is Text type. Client_ID is Number Type and gallery2.selected.id is Text type. how can i fix this filter to make them compatible. I would appreciate your help. Thanks
Put Value(gallery.selected.Id) to make it a number
@@ShanesCows Thanks so much it worked!!! I've been trying to resolve this for a few days.
Hi Shane, Can you tell me how to apply 2 filters (2dropdown or 2input text) in one gallery...
Look for my video on cascading Dropdown
Hi Shane, in your search video I watched before this, you had the issue (right at the end) where you created your app from a Sharepoint List which only searched based on Title, and you mentioned looking at and fixing that issue in the filter video. I still can't seem to work this out...my app only searches on my title, but I have a contact list where I want users to be able to lookup contacts based on contact persons name, title (organisation), contact number or email address etc...So I want search to work based on multiple fields. Is there a way to do this? Thank you :)
Thank you for this video, i just have an issue, i did exactly the same but the '=' sign is underlined in my case and i don't understand why...
If you hover over the underline with your mouse PowerApps should tell you why it is angry.
Hi Shane, I am struggling with displaying my search results on a different screen. I have used the filter function to search and I would like to add a button called 'Search' that enables the results to display on the next screen. Please help!
Answered your other comments.
Hey Shane! thanks for the video it was so helpful, i was wondering if i would still be able to use the groupby function with this filter I have a gallery with many replicated items at the moment I have this- Filter('Index Resources',WWorEMEA= MyProfileResources_1.Selected.WWorEMEA), GroupBy('Index Resources',"titlegroups","empty2") where empty2 is where I want to group the data and titlegroups is what I want to group from my sharepoint list (index resources)
That seems like it would work.
@@ShanesCows Hi Shane, the error is for the comma and I have tried a semi colon instead but same error still.
Hi Shane, Is it possible to filter a list form and make the results searchable?
Forms only show one record. Ao not sure what you are trying to do?
Good afternoon, I would like to thank you for all the content you post, I am Brazilian here there is content but it does not come close to your explanations. Thank you very much for your time and dedication, I will continue to follow your publications. Sorry for the writing I am not very good at the language.
Your English is great. Thank you for the kind words. 🐶
Hi Shane!!! I am filtering sharepoint list data same way as your video But I guess yellow delegation warning saying "Delegation warning. The highlighted part of this formula might not work correctly on large data sets. The "CountRows" operation is not supported by this connector. The data source might not be able to process the formula and might return an incomplete data set. Your application might not return correct results or behave correctly if the data set is incomplete.". How to get rid of this. My formula is "CountRows(SharePoint ListName)". Its working but warning shows up.
You cannot. CountRows is not delegable. :(
Hi Shane, Thanks for your videos, they're a great asset to power-apps. I have a question. When you select the play button on top right to view the gallery, I don't get any fields showing up. Just a blank screen. Any idea why this maybe the case? Thanks in advance.
I would look at your items property again. Also check you have a label that is set to show a field with data
Hi! great vid, little question. Is the Title that you use in the logical test the name of the column in the sharepoint list or the name of an element inside of the gallery?
Title is the SharePoint column name.
@@ShanesCows thanks a lot, Shane! keep up the great work :))
Hi,
firstly, thank you so much for sharing :). I want to ask a question that instead we use 3 different datasources, can i use only 1 data source but show different fields?
For example, i have a SP list contained all fields from Project name, project task and project detail. Can i do the same as yours? Thanks in advance and hope to get your response.
Yes. Each gallery you control what fields you show so should work.
I have an issue: I have a gallery that is selectable, and based on that it filters another gallery on the screen. Both galleries' data sources are from different Sharepoint Lists, but have a unique "key value", let's say their Family name. So it's a one to many relationship, Surname table has only one Smith, but First name table has many Smiths. Let's say I click Smith, in another gallery I get John and Jane. But my problem is that I would want to do the reverse: when I click John, I want to see Smith chosen in the other gallery. I wrote the code for this reverse gallery exactly like the first one I have (which works fine) but it doesn't show any items in the table where it should say Smith. Is there something structurally built in Power apps which prevents these many to one connections?
BR, Mika
Hey Shane, thank you for the video. First off I'd like to say I am a complete beginner with PowerApps and coding language and this is also my first attempt at a PowerApp. I'm having issues using my TextInput box to filter my data source. I tried using your formula but everytime PowerApps says that the TextInput box is unsupported for evaluation due to my data source being "data type = table" and my filter text box being "data type = control". Instead of trying to filter a sharepoint list gallery I am trying to filter a gallery for an Excel spreadsheet from OneDrive. Is there a different formula I have to use? Below is the formula I am currently using from your video.
Formula Filter(datasource, FilterTextBox.Text = Title)
Thank you!
Filter(datasource, column = control.text) 😀
Hi Shane!
Once Again big Fan!!!
Lets say now you have a team assigned for the project activities and when one fofthem Mark it as "Completed" notify all teammates on the project
Thanks!!!
Look for ForAll video. 😀
Hi Shane, thanks for all your videos. Do you have a video about using the 'Search' or 'Filter' function for a 'Choice' column in a Sharepoint list? No matter what I try, I get an error message - usually along the lines of 'Wrong type. Expects text type'.
I trawled forums and documentation high and low but can't find any useful information on this.
I would love for end users to be able to search for items by the 'Week' choice column in the Sharepoint list (eg: Week-01, Week-02 ...etc).
Shane, I'm having similar issues as threewiseman1. Looks like I am running into delegation problems when I try to filter by the choice column from the sharepoint list. I've figured out that I can create a collection from the sharepoint list, add a new column using the values from the choice column and then filter from the newly added column to get the gallery to show what I want. However, this doesn't help the overall project I'm working on because I still need to be able to edit and update the original sharepoint connection in the edit screen. How would I do that?
The project I'm working on is a simple status update app that a field agent can use to respond to new task requests entered in the sharepoint list. The sharepoint choice column that I'm referencing and having trouble with happens to be a status column. SInce there are many rows in the list, it only makes sense to display SP list records that are "open" and filter out the ones that are "complete." Am I on the right track with using a collection on the gallery?
Hi, I love your videos, but I am still unable to filter and sort my products by the gallery. I have 7 rooms, and each room has its own inventory, and I want it to sort and filter items available per room. Please help.
I have problem about filter in my apps. In sharepoint I have 5 column , 2 in 5 column set choice type. I cannot filter it in power apps. Please let me know how to fix them.
.value is usually the key to choice columns.
Good afternoon Shane! Thank you for your videos. They have helped me a great deal in my new job as a Power Apps dev (I was a software tester for almost 10 years). I have been making updates to our company's internal newsletter, which is created using a canavs app, and sent out via a power automate flow. In the canvas app, there is a search box used to find existing entries, but it is clunky and doesn't return all of the results. My data source is a Sharepoint list that currently contains just 640 entries (It has been around 2021, and is growing). I want to improve the search function so I want to use a filter function that will look at several columns in the SP list. How can I fix the following formula so the red triangle goes away?
Search('Weekly Digest', TextInput1.Text, "Group", "Category", "Title", "Narative", "Client")
TextInput1.Text is the new text box I created for the employees to enter their keywords (and where I want to put my filter function). I realize narrative is spelled incorrectly... but that it how it appears at the bottom of the screen when you highlight the column name in the SP list setting screen (the list predates my employment here). Also, I need to make sure it is truly searching the keyword(s), and not only finding an item the if the search term is the first word. Can you help me?? Thank you in advance!
Did you see this video? It should help? ua-cam.com/video/lYi24okXDPs/v-deo.html
Hi Shane, My Name is Raoul Elias Miraglia and I am currently working on a Power App (source: KVP) with a Gallery and many filters. However, when filtering the gallery with one specific filter and editing one of the filtered entries, the altered entry does not show up, but still the old one. Only when adding another filter to the gallery it updates the entry/data. The Refresh button with the function Refresh(KVP) does not work. Why? Do you have any idea how to solve this?
The filter, that I meant has a delegation warning. However, there are only 300 records in total until now. So this can't be the issue right?
Not sure. Delegation shouldn't be an issue with only 300 records.
Can I use FIRST function within this FILTER function?
I have this : Filter(Customers, 'AccountNum ' = "CTLE001")
I know LOOKUP function does it, but I´d like to try using FIRST with FILTER function.
Yup. First( Filter(Customers, 'AccountNum ' = "CTLE001")) works just like you want. 😀
Hi, I'm trying to use filter function for a data table, not a gallery. Is it possible?
Yes. Same functions work for a data table.
Hi Shane, can you please tell me how to change gallery selected item on button click or any other event, like passing as parameter to change the slected item of Gallery ?
I don’t think you can. What are you trying to do?
Great video again Shane. Is there a way to created Sumifs in powerapps? So if I wanted to do something like the following how would this be done. Sum of column Days, where column Name = Name=User().FullName and column Status = Approved So in Excel it would be something like =SUMIFS(H:H, G:G, "Approved", A:A, "Craig Jenkins")
Hmmm. In my head it is something like this:
Sum(Filter(datasource, Name=User().FullName and column Status = Approved), Days)
That isn't working code but I think enough to get the wheels turning for you.
Hi, Shane. How are you?
I've been trying to filter a gallery by a specific field of a SharePoint list. It works well, but it doesn't update the data when I make some change in the list.
For example: I want to display every record which the field Status is equal to "FALSE" (Filter(My_List,Status = "FALSE");
when I update the Status to "TRUE", the records are still displayed, even though is "TRUE".
The gallery is just updated when I refresh the PowerApps website, then I can see the result I want.
Do you know what might be the problem?
Thanks in advance!
Try using the Refresh(SharePointList) function to force the update
@@ShanesCows It worked, thanks!
thank you. very helpful in explaining the functionality and some of the quirks. looking fwd to doing something like this w/drop down boxes.
Awesome 😎
Shane thank you for the numerous videos and information. I'm looking for a little more help, I have a table (TruckData) that contains a column named "Status" and the two options for status are "in service" or "out of service". I'm looking to create buttons (3 buttons "view all trucks" "view in service trucks" "view out of service trucks") that allow me to filter (or search) my results based on the text in the status field. I feel like this video is close to what I'm looking for but can't get it to populate correctly. Any suggestions?
Hi Shane, your videos are amazing. I have a query with respect to this video, do you have another video which explains how to edit the specific entry which we get as a result of filter?
Maybe look at some of my content around forms or patch for help editing data.
Hi Shane, another great video! :) I have a bit of an issue with date picking and live filtering; the drop-down boxes and input fields all auto-filter the gallery I'm wanting to fix, but the date-picker (I have two pickers to determine a range) doesn't auto-filter. If another input is changed it'll filter then, but it doesn't filter by itself/doesn't filter live like other. Apologies for the bombardments of questions lately
Justin see if this video helps you think through how better ua-cam.com/video/kLGglidmPxg/v-deo.html
Hi Shane. Thanks for this video, this was my first day with PowerApps but still it clarified Filter Function effectively ---- but one thing I am not clear of, I am building a simple TimeSheet solution using PowerApps (based on a SharePoint List) in my powerApps list I want to show only those List items which are "Created By" = [Me] ...how can I achieve that?
I have a video on the User function. That does the Me from SharePoint. 😀
Hi Shane,
Thanks for all the tutorials. Really informative & easy to follow!
Cheers,
Joe
Glad to help. 😀
Hey Nice video does this work with multible filters?
ua-cam.com/video/kLGglidmPxg/v-deo.html This help?
Thank you for the video's, they have been very helpful and informative. I do have a question though. I have a sharepoint list for Toner inventory, and I want to filter the list to only show Toner that needs to be ordered. I have tried to filter using a calculation from 2 columns, but I keep getting error. The function I tried was Filter(Toners, DesiredQuantity > QuantityOnHand) but I get Fetching Items failed error. Any help would be appreciated. Thanks Again.
That seems like it should work. I will try tomorrow to confirm. Are they both number columns?
@@ShanesCows Yes, both are number columns, I had also created a calculated column called OrderQuantity in sharepoint and had it calculate from those 2 columns and tried to filter based on OrderQuantity being greater than 0, that didn't work either, but that error was expecting text, even though I selected number as the result.
How did you interlink the data in the sharepoint lists
Try this ua-cam.com/video/43ekj5MlNJU/v-deo.html
hi, why Filter(Essenplan; StartsWith(Kunde.Value; TextSearchBox_Essensplan_edit_Kunde.Text) ) worked with a delegation warning?
why?
and what is better for a filter with big datasets ?
What is your data source? Starts with is only delegable with SharePoint
@@ShanesCows i use share point
Oh I see. Kunde is a complex column type. They are never delegable 😔
@@ShanesCows complex? i store only text (or from a other List)
How would Filter on Drop Down Box on form be performed. Using 2 columns one shows value some text(Homepage) column and if the Active Column equal to "Yes" then display only those lines to select from.
Use the filter function in the items property of the drop down
How can you filter a gallery, if you are using a group column, so if i have there Shane, Mark and Laura, only they will see that information? Like this: ('Created By'.DisplayName = Office365Users.MyProfile().DisplayName) but with a group column
I have a video for that. PowerApps Filter Gallery by the Current User ua-cam.com/video/-VaADTTPYmg/v-deo.html
Hi Shane, I have developed a 3 screen app from a Sharepoint list. I need to be use a multiple filters. Is that Possible?
Sure. You can do And or Or to add additional criteria
Hi Shane,
Thank you for the video - I have no much experience in coding. the way you described using filter is very clear. Thanks again.
I am trying to edit a sharepoint list display form in powerapps, to show corresponding records from other sharepoint lists based on a common field in both the lists.
How do I put up this condition - If "commonfield" value in the first list selected item is "X", the second list should filter list items with "X" value in same "commonfield". Here "common field" is the field present in both the lists.
I tried to put in condition by comparing 2 fields directly from both lists - Filter(List2, list1.commonfield = list2.commonfield)
Powerapps say '=' is invalid argument type and 'list1.commonfield' would not work correctly with larger data sets - delegation error!
Appreciate your inputs on this.
Thanks again.
Look for my video on SharePoint Lookup columns or a video on cascading Dropdowns. Both should help.
Hey Shane, There isnt a single day passed in past week without me watching your videos. Keep up the awesome work. I love your videos. Do you have the video explaining about Lookup function using SharePoint lists? If so, can you share me the link?
Glad to help. Maybe this video? ua-cam.com/video/43ekj5MlNJU/v-deo.html