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?
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
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. ;)
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
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
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
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 descriptions are very clear. I have zero coding experience. I am a heavy excel user. Saw this and "PowerApps User Function and intro to Office 365 User connector" and made a PowerApp for my team to track time spent on various JIRA issues on various projects. Thanks a lot for sharing. Plan to do more apps.
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
I was hoping you'd go a little more in depth on how to add multiple search parts to a filter. PowerApps automatically created a filter for me that works ok but not great. Here's what it says: SortByColumns(Filter('Truck Inventory', StartsWith(Title, 'Search Bar'.Text)), "Title", If(SortDescending1, Descending, Ascending)) The problem is it only searches the title. I have tried a few ways to get it to also search the Item Description field so we can search by all these areas but I can't seem to find the right setup. I'm also not fond of the "StartsWith" because if the search is for a word later in the name of the field, it won't find it. Suggestions? Is there a "Contains" option? Your videos have been a great help so far. Thanks in advance.
Does this work: SortByColumns(Filter('Truck Inventory', StartsWith(Title, 'Search Bar'.Text)||StartsWith(Description,'Search Bar'.Text)), "Title", If(SortDescending1, Descending, Ascending)) Where Description is the name of the item description column that you want to make searchable.
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 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?
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, 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.
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... 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?
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 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, 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! I love your videos so much, finally I can understand not just how to do something in PowerApps but I also understand why it works! I am having an awful time understanding nested filters. For example I have a list of schools, I have another list of jobs, then I have a list where you pick a school from a lookup to the school list, and you pick a job from a lookup to the job list and then you enter the number of that job assigned to that school. So three lists. In one of my screens I want the user to pick a job from the job list and then in a gallery I want to show all the schools that DON'T have that job assigned to them. I'm dying.....it takes me so long to figure it out (like hours) and when I do finally get it working I am not even sure what I did to make it work. If anyone can explain it you can. Can you help? Do you already have a video that might cover this? Help me Obi-Wan, you're my only hope.....
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)
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.
- Great stuff, you are really helping me. I am designing something amazing for our workplace and you are going to be our saving grace. THANKS! I know I will have questions and will send through to you. Would love to show you what I came up with in the end, as a non-developer who just wants to make life easier (oh, and enjoys this stuff!). Thank you for being so clear and being very honest about what works, what doesn't and what wastes time. So helpful!
Hello Shane, thank you so much for producing PowerApps videos that are easy to follow and explain the mechanics. Sure it is possible to secure what a user has access to by security groups. For example in my app I need give teams of people access to specific areas in the app through the gallery. For instance say my departments are Peru, India, Ireland, and US, a team needs the ability to access Peru, but not see the other departments. Thank you in advance for your help. Keep up the great work.
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 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. 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?
Hi Shane, Great demos and tutorials, thanks for your guidance. I have a question, Is there any way to change dynamically the data source of a Gallery? Based on a button on screen 1, show a specific SharePoint list on screen 2? So we could apply a filter on the second screen? Thanks
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.
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 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! :)
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
Shane, thank you for making this channel. Your videos have helped me so much. I have been trying to build a more robust search box that will return the correct items even if the user enters the words in the incorrect order. For example: if the title of the item is Blue Cat I want the item to still show up if the user enters Cat Blue into the search box. Do you have any suggestions on how to set this up in PowerApps? Thanks in advance!
Hello Shane, first your videos are life savers. I have a quick question. If I want a list to display as a gallery filtered on the current user (I.e. I have Sharepoint list filtered to [me]) how would accomplish the same thing in a powerapp?
Great videos. Would have been nice to see the detail in your SharePoint list. I'm a newbie and it would have helped me put things together much easier since we went so fast viewing the filter. Thanks for posting.
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
Hi Shane, Firstly, thank you for these tutorials they have been a massive help to me in understanding how PowerApps work. I have a sharepoint list with 30+ columns and am trying to build a power app to enable me to better manage that data (it's an order tracker for hosted telephony). I can display the fields I want in a data table but only want the records that are not marked as complete to show in the table (so as to track the states of in progress orders). My sharepoint list has a field called "Order Status" which, in sharepoint is a "Choice" field. WHen I am trying to filter the info in this data table, I am hitting errors. I'm very new to this so am probably missing something really simple, but the filter statement is along the lines of "Filter('PBX Systems'.'Order Status', 'Order Status' "Complete")". Can you tell me what I am missing?
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!
@@ShanesCows unfortunately not didn't quite do what I wanted. On a form we want to pull the list of choices from SharePoint choice field and then set the default on the the field based on a selection from a different field...just not working. Thinking it has to do with the fact powerapps see that field as a record with all the fields of SharePoint in it. Going to tinker more when I get time to see if I can make it work.
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
Hi Shane! this video is very helpful -thank you so much! However, I am having issues with my data source. I have a excel file with more than 10,000 records but PowerApps only shows 2,000 records when I do the filtering. What is your recommendation in this case? Thank you!
You need to read up on Delegation in PowerApps. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview Long story short for that much info I think you will need to consider a different data source.
Hey Shane I have come across something I cant find on your videos, I know crazy ;), and I cannot find it anywhere else either. What I am trying to do is sum a column of number values in a gallery in a gallery =D. What I have is an outer Side-Scrolling Gallery of classes where each item has a Vertical-Scrolling Gallery full of time entries for labs for that class. For example It shows a Gallery for the 2 labs that student A has, Science 111 and Math 111. This means my side-scrolling gallery now has 2 items in it. Each of those items has a gallery in it that filters the master time sheet to only show items for that student in that class's lab. So if student A signed into the lab on the 5th and the 7th for 45 min and 60 min, there would be 2 entries inside the inner gallery that would have the Date, Time In, Time Out, and Minutes Logged for each of those times. I have this working and I even have the total minutes showing for each of the inner galleries in powerapps. My issue is that I need to patch those times up to the SP list and to do so I have tried the follow with no luck: ForAll(ClassList,Patch(MasterRoster,LookUp(MasterRoster,StudentID=Value(student.StudentID) And ClassCRN=Value(ThisRecord.ClassCRN)),{TotalMinutes:Sum(Gallery4.Selected.Gallery3.AllItems,TimeLogged)})); Hopefully this is possible and I'm close! Thanks for all the videos!
You have been very helpful in getting me up to speed on PowerApps. Thanks! Shane. A quick question: How do I know when to put something in quotes? IOW, what kinds of things must be in quotes, and when is the name of the object (sans quotes) the right syntax?
Text is always in quotes. Sometimes column names inside of functions are in quotes. (Like SortByColumns and Search). I don't know I have a solid answer here. You Just have to kind of figure it out. The best way is if you look at what the formula is suggesting in the dropdown as you type that is a hint. Sorry for a weak answer.
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?
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?
Hi Shane, your videos are super helpful! Is it possible to apply a search function and a filter function to the same gallery? I'd like to make it possible to search all columns, and also make it possible to filter by specific columns. I've gotten the search and filter functions to work separately, but I'm having trouble applying them both to a single gallery. Thanks!
Hey Shane. These vids are boss, thank you. Question: what about filtering with collections? Your examples worked well with SharePoint data, but didn't return any results when I swapped the data for a collection. Thoughts?
Every time I watch one of your videos, I up my game that much more. This is great! I am creating an app that will allow complete management of items in a list without having to go to the list at all. One of my galleries is used along with a form to input new records. I have the this gallery filtered to show only items created by the current user and created today(). The app opens to this screen. What settings do I need to change so the frame and first item separator of the gallery are visible before any new records are added? The page is empty except for the Title I added and the NewForm. The gallery itself is not visible until the first record in the current session is added.
Hi Shane, Suppose I need to use only one DataTable to display from SharePoint. But i have to display only two columns out of 8 columns based on selection of buttons. My Scenario: If I select "customer" button i have to display "customer" column and "Title"Column. If I select "Product" button i have to display "product" column and "Title"Column.....Similarly for other columns too. The thing is I have to make use of single data table to display only two columns out of 8 columns based on button selection
I relied to Prasad in email but in case anyone else is wondering what I would do is use multiple data tables on top of each other. Then only make the one visible that shows the columns I want to show.
Love your videos Shane! Great instructional content, hitting major sought after content and perhaps best of all...getting right to the point on how to use these various features and configurations. Well done!
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!
Hi Shane. Great video, very informative! Any advice on how to utilize the filter functionality to create a search center app for SharePoint document libraries (potentially hundreds of libraries)? Since the search in SP itself isn't great, I am considering building a solution in PowerApps for my company instead of using a SP Search Center site. 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?
Thank you so much for this, it's incredibly valuable and precisely what I need to build for a client of mine! You are straightforward and very knowledgeable.
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 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, 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.
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.
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?
Shane Young, Hi, for me also the filter is not working for the data table. Can u pls help with this? I have inserted the data table and connected with SQL table. now the data are showing but the filter is not working for me. I have tried a lot. And also can u pls explain how the sum of a specific column will be shown.
Thanks again for a clear and concise video. The expression "Filter(’Project Details’,ProjectName = Gallery2.Selected.ProjectName, ProjectTask = Gallery3.Selected.tasks)" makes perfect sense to me , but how about using a DatePicker control in stead of a gallery for the second logical text? I am building an app that allows a production manager to keep track of hours used by external employees on a given case pr. day. The user selects case and relevant date and the app presents which external employees were on site and how many hours each used in a DataForm. My expression looks like this: Filter(ExternalWorkers; Titel=GlryCases.Selected.Title2.Text; Date = DatePicker1.SelectedDate) which returns no data to the form and a grumpy reply from PowerApps that the expression is not valid. Using only the first logical expression it works fine - obviously without filtering by date, so, something is fishy with the dates, but what?
@@ShanesCows a SharePoint list "ExternalWorkers" containing data on case name and number, employee details, and the date of the entry. I am beginning to think that there is a conflict between the date picker's output and the data in the date field of the SharePoint list. I exchanged the DataForm with a gallery and again the first logical argument worked perfectly, but adding the Date picker still fouls things up.
I would play with. What you want to do is normal so something weird must be messing with you. If you display the date in the gallery do you see what you expect?
@@ShanesCows I tried making a new SharePoint List and rather than using a template I made the corresponding new app from scratch. The result however is the same; Fitering by case number works just fine, but as soon as I try to add the expression with the DatePicker into the string it comes to a screeching halt again. I have no problem having a label repeating the DatePicker1 selected date (using your "if in doubt use a label as a control measure"), hence the issue seems to be focused on filtering by the same value - both alone and as part of a series of filter expressions like the one in the post above. SharePoint returns this message: “The desired action is invalid. The expression "DatoP_x00e5_Job eq 2018-11-15 is invalid. clientRequestID.......” What I notice here is the DatePicker1 value is US style YYYY-MM-DD and DatoP_x00e5_Job is Scandinavian DD-MM-YYYY, could it be something as simple?
@@ShanesCows Solved it! in short, the two dates need to be converted to values i.e. Filter(TempHourAccount; Value(DateOnJob)= Value(DatePicker1.SelectedDate)). It does produce a blue squiggly line, but it works - both on its own and in the original expression.
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".
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"]
Another great video Shane. I would really like to see a parent-child and a parent-child-grandchild application where you are not just pulling data but writing back data to SharePoint list. Say a Purchase Requisition (PR) or Purchase Order (PO) system with a PR/PO header, PR/PR Line items and some of the items may have lines of details attached to them. For the Child/Grandchild form can you edit multiple lines in one screen/form then post back/save all the items back to the data source with a link to the parent.
Great video ... I'll be watching many more of them. I just have one nagging issue. My filter box says "This data type is unsupported for evaluation | Data type:Control".
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
Hi There, your videos are very helpful. Do you have any videos that shows how to save results of a gallery/collection after multiple filters, to be saved in sharepoint list? (details could have several rows, but can it be saved in just one sharepoint list record?
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. 😀
Hi Shane, thanks a lot for your videos. Great teaching and very interesting. I got a question you might help with. So far I used an excel file from OneDrive/Sharepoint to create the PowerApp and also "write back" within the App to the file. Is it possible to do this write back into an on premise sql server? This would be really interesting to me. Thanks and best regards
For some reasons it tells me my credentials are wrong. Using my windows credentials. Are there common errors which often happen and could lead to this?
Hi Shane, Great vide, I’ve watched a fair few of them now and they are very informative! :) . Could you please advise how I would filter data by user? I have one sharepoint list that contains a job sheet. This job sheet list has columns such as customer details and jobs description and one of the columns contains a drop down box linked to another sharepoint list which contains employee details where one of the columns in this list holds the employee email address...however this isn’t the column that is displayed In my job sheet form, the job sheet form shows their actual name from a separate column in the employee details list. I want the resulting filtered data to display all the items from the Job sheet but only for the jobs that are assigned to the user that is filtered. Either via a filter box or appstartup. Is this possible? Note. Each employee has a office 365account and email address.
Shane Young thanks for the Reply shane. I guess I’m a little stuck on how to get the user() username to reference a certain record in the form. For example I have a record in my form and this is called “AssignedTo” in this record I have the name of the employee that the job is assigned too. We have several employees and I’m wanting when they load the app on their phone/device to just see any jobs that have their name in the “AssignedTo” record. I can’t work out the formula for the app startup property to make the current user have to match the record in “AssignedTo”. Does that make more sense? 😳
Hi Shane, Thank you for the wonderful guide as always. Quick question, how do you suggest that we replicate the same for date filters? I have tried many methods, but '>' or '
Hi, I tried the following; SortByColumns(Filter(Events_table, To.Text >= Today())) , "From" , Ascending) Also tried to to use the different text box with Today() as default. But nothing seems to work.
Tried following as well; SortByColumns(Filter(Events_table, To >= Today())) , "From" , Ascending) SortByColumns(Filter(Events_table, To >= TextInput5.Text)) , "From" , Ascending)
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. 😎
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
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.
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 Videos. I have just started to work with PowerApps and your videos helped me to build powerful applications.
Awesome 😎
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
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. ;)
Thanks for the tutorials, you are helping me to keep me busy at Covid 19 time.
Happy to help Andre. Keep learning 😀
You are the most extensive source of insights!!!! Thanks a lot for sharing!!
Awe! thank you. 🐶
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
Filter(Employees, Age > 32 and Color = "Red")
Hi Shane
New to PowerApps. Your videos are helping me a lot in learning the basics. Appreciate the sharing of knowledge.
You are welcome.
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 😎
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
Hi Shane,
Thanks for all the tutorials. Really informative & easy to follow!
Cheers,
Joe
Glad to help. 😀
Thanks Shane! You're the man. I used the same method on a data table with the same results.
Awesome
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!!
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. 🐶
Your descriptions are very clear.
I have zero coding experience. I am a heavy excel user.
Saw this and "PowerApps User Function and intro to Office 365 User connector" and made a PowerApp for my team to track time spent on various JIRA issues on various projects.
Thanks a lot for sharing.
Plan to do more apps.
Awesome! Kudos to you for rolling up your sleeves and learning some new stuff.
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
I was hoping you'd go a little more in depth on how to add multiple search parts to a filter. PowerApps automatically created a filter for me that works ok but not great. Here's what it says:
SortByColumns(Filter('Truck Inventory', StartsWith(Title, 'Search Bar'.Text)), "Title", If(SortDescending1, Descending, Ascending))
The problem is it only searches the title. I have tried a few ways to get it to also search the Item Description field so we can search by all these areas but I can't seem to find the right setup. I'm also not fond of the "StartsWith" because if the search is for a word later in the name of the field, it won't find it. Suggestions? Is there a "Contains" option? Your videos have been a great help so far. Thanks in advance.
Does this work:
SortByColumns(Filter('Truck Inventory', StartsWith(Title, 'Search Bar'.Text)||StartsWith(Description,'Search Bar'.Text)), "Title", If(SortDescending1, Descending, Ascending))
Where Description is the name of the item description column that you want to make searchable.
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 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!
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
Great instruction. Got it working after some ‘trail and error’ with CDS database. Your video helped a great deal!
Very cool. I haven't tried it with CDS yet.
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.
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... 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
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 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, 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! I love your videos so much, finally I can understand not just how to do something in PowerApps but I also understand why it works! I am having an awful time understanding nested filters. For example I have a list of schools, I have another list of jobs, then I have a list where you pick a school from a lookup to the school list, and you pick a job from a lookup to the job list and then you enter the number of that job assigned to that school. So three lists. In one of my screens I want the user to pick a job from the job list and then in a gallery I want to show all the schools that DON'T have that job assigned to them. I'm dying.....it takes me so long to figure it out (like hours) and when I do finally get it working I am not even sure what I did to make it work. If anyone can explain it you can. Can you help? Do you already have a video that might cover this? Help me Obi-Wan, you're my only hope.....
This video is probably the best advice I have. 😑 !(job = jobtocheck) is how to do that part.
@@ShanesCows Thanks Shane! I figured it out....and documented my solution so I know what to do in the future!!
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,
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.
- Great stuff, you are really helping me. I am designing something amazing for our workplace and you are going to be our saving grace. THANKS! I know I will have questions and will send through to you. Would love to show you what I came up with in the end, as a non-developer who just wants to make life easier (oh, and enjoys this stuff!). Thank you for being so clear and being very honest about what works, what doesn't and what wastes time. So helpful!
Feel free to email me shane @powerapps911.com anything you want to share. Thank 😻
Shane you're a hero !
Thanks!
Hello Shane, thank you so much for producing PowerApps videos that are easy to follow and explain the mechanics. Sure it is possible to secure what a user has access to by security groups. For example in my app I need give teams of people access to specific areas in the app through the gallery. For instance say my departments are Peru, India, Ireland, and US, a team needs the ability to access Peru, but not see the other departments.
Thank you in advance for your help. Keep up the great work.
Try out this video for some ideas. ua-cam.com/video/0MB-z9cyFCQ/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!
your tutorials are very helpful !
Glad you like them!
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. 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,
Great demos and tutorials, thanks for your guidance. I have a question, Is there any way to change dynamically the data source of a Gallery? Based on a button on screen 1, show a specific SharePoint list on screen 2? So we could apply a filter on the second screen? Thanks
Not really. You can use If or a collection of the two datasource have the same columns
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.
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 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 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
Shane, thank you for making this channel. Your videos have helped me so much. I have been trying to build a more robust search box that will return the correct items even if the user enters the words in the incorrect order. For example: if the title of the item is Blue Cat I want the item to still show up if the user enters Cat Blue into the search box. Do you have any suggestions on how to set this up in PowerApps? Thanks in advance!
I don’t have a good answer here. 🧐 Not saying not possible but no one has asked before so I got nothing off the top of my head.
Thanks for getting back to me. I did find a way to do it using the split function for future reference!
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, first your videos are life savers. I have a quick question. If I want a list to display as a gallery filtered on the current user (I.e. I have Sharepoint list filtered to [me]) how would accomplish the same thing in a powerapp?
Filter(SharePointlist, emailcolumn = user().email) is an example
Great videos. Would have been nice to see the detail in your SharePoint list. I'm a newbie and it would have helped me put things together much easier since we went so fast viewing the filter. Thanks for posting.
Sorry Linda. Did you get it figured out? I will try to do better in future videos. Thanks for The feedback
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
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.
Hi Shane, Firstly, thank you for these tutorials they have been a massive help to me in understanding how PowerApps work. I have a sharepoint list with 30+ columns and am trying to build a power app to enable me to better manage that data (it's an order tracker for hosted telephony). I can display the fields I want in a data table but only want the records that are not marked as complete to show in the table (so as to track the states of in progress orders). My sharepoint list has a field called "Order Status" which, in sharepoint is a "Choice" field. WHen I am trying to filter the info in this data table, I am hitting errors. I'm very new to this so am probably missing something really simple, but the filter statement is along the lines of "Filter('PBX Systems'.'Order Status', 'Order Status' "Complete")". Can you tell me what I am missing?
Filter('PBX Systems', 'Order Status' "Complete") Seems like it should work.
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) 😀
Thanks for this helped me out greatly. Love the demos you do...
Glad to hear it!
@@ShanesCows unfortunately not didn't quite do what I wanted. On a form we want to pull the list of choices from SharePoint choice field and then set the default on the the field based on a selection from a different field...just not working. Thinking it has to do with the fact powerapps see that field as a record with all the fields of SharePoint in it. Going to tinker more when I get time to see if I can make it work.
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
Hi Shane! this video is very helpful -thank you so much!
However, I am having issues with my data source. I have a excel file with more than 10,000 records but PowerApps only shows 2,000 records when I do the filtering. What is your recommendation in this case?
Thank you!
You need to read up on Delegation in PowerApps. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview Long story short for that much info I think you will need to consider a different data source.
Hey Shane I have come across something I cant find on your videos, I know crazy ;), and I cannot find it anywhere else either. What I am trying to do is sum a column of number values in a gallery in a gallery =D.
What I have is an outer Side-Scrolling Gallery of classes where each item has a Vertical-Scrolling Gallery full of time entries for labs for that class. For example It shows a Gallery for the 2 labs that student A has, Science 111 and Math 111. This means my side-scrolling gallery now has 2 items in it. Each of those items has a gallery in it that filters the master time sheet to only show items for that student in that class's lab. So if student A signed into the lab on the 5th and the 7th for 45 min and 60 min, there would be 2 entries inside the inner gallery that would have the Date, Time In, Time Out, and Minutes Logged for each of those times. I have this working and I even have the total minutes showing for each of the inner galleries in powerapps. My issue is that I need to patch those times up to the SP list and to do so I have tried the follow with no luck:
ForAll(ClassList,Patch(MasterRoster,LookUp(MasterRoster,StudentID=Value(student.StudentID) And ClassCRN=Value(ThisRecord.ClassCRN)),{TotalMinutes:Sum(Gallery4.Selected.Gallery3.AllItems,TimeLogged)}));
Hopefully this is possible and I'm close! Thanks for all the videos!
Hey Mike. Sorry I am slow. I hope you got it. I am sure it possible but that is a tricky one for sure!
You have been very helpful in getting me up to speed on PowerApps. Thanks! Shane. A quick question: How do I know when to put something in quotes? IOW, what kinds of things must be in quotes, and when is the name of the object (sans quotes) the right syntax?
Text is always in quotes. Sometimes column names inside of functions are in quotes. (Like SortByColumns and Search). I don't know I have a solid answer here. You Just have to kind of figure it out. The best way is if you look at what the formula is suggesting in the dropdown as you type that is a hint. Sorry for a weak answer.
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
2020 and still lokking at this, nice jo, thx for sharing i appreciate, it's helps me a lot
Glad to help. 😀
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.
You're the man!! One question, can I go to next gallery item if I'm in one of the detail pages?
Possible? Yes. Easy no. Lots of tweaks required but no quick answer. Sorry
Hi Shane, your videos are super helpful! Is it possible to apply a search function and a filter function to the same gallery? I'd like to make it possible to search all columns, and also make it possible to filter by specific columns. I've gotten the search and filter functions to work separately, but I'm having trouble applying them both to a single gallery. Thanks!
I am in the same predicament Shane. I need to search for a specific text but display the result filtered by those records greater or equal to today.
Hey Shane. These vids are boss, thank you. Question: what about filtering with collections? Your examples worked well with SharePoint data, but didn't return any results when I swapped the data for a collection. Thoughts?
Every time I watch one of your videos, I up my game that much more. This is great! I am creating an app that will allow complete management of items in a list without having to go to the list at all. One of my galleries is used along with a form to input new records. I have the this gallery filtered to show only items created by the current user and created today(). The app opens to this screen. What settings do I need to change so the frame and first item separator of the gallery are visible before any new records are added? The page is empty except for the Title I added and the NewForm. The gallery itself is not visible until the first record in the current session is added.
Hi Juli. You would have to write a formula for visible that didn’t show the other stuff while that first field was blank.
Thanks for such great videos! They're really helping me in my role to build PowerApps, particularly with the Search and Filter functionality :)
Glad to help. 😀
Hi Shane, Suppose I need to use only one DataTable to display from SharePoint. But i have to display only two columns out of 8 columns based on selection of buttons.
My Scenario: If I select "customer" button i have to display "customer" column and "Title"Column. If I select "Product" button i have to display "product" column and "Title"Column.....Similarly for other columns too. The thing is I have to make use of single data table to display only two columns out of 8 columns based on button selection
I relied to Prasad in email but in case anyone else is wondering what I would do is use multiple data tables on top of each other. Then only make the one visible that shows the columns I want to show.
Love your videos Shane! Great instructional content, hitting major sought after content and perhaps best of all...getting right to the point on how to use these various features and configurations. Well done!
Thanks Bill. I try to make good content that isn’t boring. 😻
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
Hi Shane. Great video, very informative! Any advice on how to utilize the filter functionality to create a search center app for SharePoint document libraries (potentially hundreds of libraries)? Since the search in SP itself isn't great, I am considering building a solution in PowerApps for my company instead of using a SP Search Center site. Thanks!
I think SharePoint search is probably better than what you can do in PowerApps. But I hope you prove me wrong. 😀
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?
Thank you so much Shane!!! This helped me greatly!!!
Awesome!
Shane keep on rocking mate! Very helpfull stuff
Glad to help :)
Thank you so much for this, it's incredibly valuable and precisely what I need to build for a client of mine! You are straightforward and very knowledgeable.
Glad to help
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
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
Hey Nice video does this work with multible filters?
ua-cam.com/video/kLGglidmPxg/v-deo.html This help?
You are the best! Tanks a lot for your content!!
Glad to help. 😀
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, 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.
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.
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, thanks for this tutorial. I have a question for you. Can you give me an example of a DataTable Filter? I cannot make it work.
What have you tried? Filter works the same regardless of what control you use it with.
Shane Young, Hi, for me also the filter is not working for the data table. Can u pls help with this? I have inserted the data table and connected with SQL table. now the data are showing but the filter is not working for me. I have tried a lot. And also can u pls explain how the sum of a specific column will be shown.
Brilliant! Thank you very much for all of these tutorials!
Glad to help. 😀
Thanks again for a clear and concise video. The expression "Filter(’Project Details’,ProjectName = Gallery2.Selected.ProjectName, ProjectTask = Gallery3.Selected.tasks)" makes perfect sense to me , but how about using a DatePicker control in stead of a gallery for the second logical text?
I am building an app that allows a production manager to keep track of hours used by external employees on a given case pr. day. The user selects case and relevant date and the app presents which external employees were on site and how many hours each used in a DataForm. My expression looks like this: Filter(ExternalWorkers; Titel=GlryCases.Selected.Title2.Text; Date = DatePicker1.SelectedDate) which returns no data to the form and a grumpy reply from PowerApps that the expression is not valid. Using only the first logical expression it works fine - obviously without filtering by date, so, something is fishy with the dates, but what?
What is your data source?
@@ShanesCows a SharePoint list "ExternalWorkers" containing data on case name and number, employee details, and the date of the entry. I am beginning to think that there is a conflict between the date picker's output and the data in the date field of the SharePoint list.
I exchanged the DataForm with a gallery and again the first logical argument worked perfectly, but adding the Date picker still fouls things up.
I would play with. What you want to do is normal so something weird must be messing with you. If you display the date in the gallery do you see what you expect?
@@ShanesCows I tried making a new SharePoint List and rather than using a template I made the corresponding new app from scratch. The result however is the same; Fitering by case number works just fine, but as soon as I try to add the expression with the DatePicker into the string it comes to a screeching halt again. I have no problem having a label repeating the DatePicker1 selected date (using your "if in doubt use a label as a control measure"), hence the issue seems to be focused on filtering by the same value - both alone and as part of a series of filter expressions like the one in the post above. SharePoint returns this message: “The desired action is invalid. The expression "DatoP_x00e5_Job eq 2018-11-15 is invalid. clientRequestID.......” What I notice here is the DatePicker1 value is US style YYYY-MM-DD and DatoP_x00e5_Job is Scandinavian DD-MM-YYYY, could it be something as simple?
@@ShanesCows Solved it! in short, the two dates need to be converted to values i.e. Filter(TempHourAccount; Value(DateOnJob)= Value(DatePicker1.SelectedDate)). It does produce a blue squiggly line, but it works - both on its own and in the original expression.
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".
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"]
Another great video Shane. I would really like to see a parent-child and a parent-child-grandchild application where you are not just pulling data but writing back data to SharePoint list.
Say a Purchase Requisition (PR) or Purchase Order (PO) system with a PR/PO header, PR/PR Line items and some of the items may have lines of details attached to them.
For the Child/Grandchild form can you edit multiple lines in one screen/form then post back/save all the items back to the data source with a link to the parent.
We could do something like that. I will put it on the list but, it might be a while. The list is getting long. :)
I'm with Marlon, Shane. Please move this up on your list of videos to make.
I think this is the video you are looking for. :) ua-cam.com/video/43ekj5MlNJU/v-deo.html
Thank you and well done. How would you add data to those tables, from PowerApps? Example, like access, a form with a subform?
Look for my video on repeating tables like infopath
Great video ... I'll be watching many more of them. I just have one nagging issue. My filter box says "This data type is unsupported for evaluation | Data type:Control".
You set the value to TextInput instead of TextInput.Text
Hi!! thanks for your videos, really helpfull!! , do you know if there is a way to create something like a pivot table (Excel) in powerapps???
... Maybe. I have never tried but I am guessing with enough elbow grease you could get something similiar. Not sure
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
Hi There, your videos are very helpful. Do you have any videos that shows how to save results of a gallery/collection after multiple filters, to be saved in sharepoint list? (details could have several rows, but can it be saved in just one sharepoint list record?
To make it one record check out the concat function.
Good Coverage. Thanks!
Happy to help
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. 😀
Hi Shane,
thanks a lot for your videos. Great teaching and very interesting. I got a question you might help with. So far I used an excel file from OneDrive/Sharepoint to create the PowerApp and also "write back" within the App to the file. Is it possible to do this write back into an on premise sql server? This would be really interesting to me. Thanks and best regards
Yes. This video Powerapps on premise data gateway ua-cam.com/video/uqx_h4Ym8ng/v-deo.html
For some reasons it tells me my credentials are wrong. Using my windows credentials. Are there common errors which often happen and could lead to this?
Hi Shane, Great vide, I’ve watched a fair few of them now and they are very informative! :) . Could you please advise how I would filter data by user? I have one sharepoint list that contains a job sheet. This job sheet list has columns such as customer details and jobs description and one of the columns contains a drop down box linked to another sharepoint list which contains employee details where one of the columns in this list holds the employee email address...however this isn’t the column that is displayed In my job sheet form, the job sheet form shows their actual name from a separate column in the employee details list. I want the resulting filtered data to display all the items from the Job sheet but only for the jobs that are assigned to the user that is filtered. Either via a filter box or appstartup. Is this possible?
Note. Each employee has a office 365account and email address.
Yes. 😀 But I am a little lost. Remember you can use User().Email to get the current logged in user.
Shane Young thanks for the Reply shane. I guess I’m a little stuck on how to get the user() username to reference a certain record in the form. For example I have a record in my form and this is called “AssignedTo” in this record I have the name of the employee that the job is assigned too. We have several employees and I’m wanting when they load the app on their phone/device to just see any jobs that have their name in the “AssignedTo” record. I can’t work out the formula for the app startup property to make the current user have to match the record in “AssignedTo”. Does that make more sense? 😳
This what I to filter assigned Projects. Filter(Projects, Status.Value = "In Progress", AssignedTo.DisplayName = User().FullName)
Hi Shane, Thank you for the wonderful guide as always.
Quick question, how do you suggest that we replicate the same for date filters?
I have tried many methods, but '>' or '
What is the formulas you have tried?
Hi, I tried the following;
SortByColumns(Filter(Events_table, To.Text >= Today())) , "From" , Ascending)
Also tried to to use the different text box with Today() as default.
But nothing seems to work.
Tried following as well;
SortByColumns(Filter(Events_table, To >= Today())) , "From" , Ascending)
SortByColumns(Filter(Events_table, To >= TextInput5.Text)) , "From" , Ascending)