Thank you for leaving the moments where you have no idea what's going on...I think we spend most of our time in PowerApps in that state! It helps a lot 😊
Thank you Shane, for giving people who have no idea what they are doing the opportunity to impress other people that have no idea what they are doing! Making me look like a rock start!
Thank you for hard work you´re has been doing to the rest of the mortals. From two week´s ago, you´re my "Master of Powerapps" (like He-Man was of the universe!). Hugs from Córdoba, Argentine to Cincinnatti.
Random comment but I find it funny that every PowerApps teacher on UA-cam always says: "But first, here's the intro!". Its the only time time I've every seen someone introduce an introduction.
Thank you, i learned a lot, there maybe some new techniques but i keep on watching your other Videos based on filtering and make my notes. It took me 90min to write down everything and combine that with screenshots. I have a very good docu to your video which i put on my favorite list.
Thank you for this, I enjoy practicing on your Vedio and I learn a lot. I appreciate how you follow simple approaches and add functionalities gradually, it makes my practice less overwhelming. thank you so much.
Wow wow wow.... finally I prepared my own application with the help of your video... Thanks, Much bro.. Had so many difficulties in between, but I was able to resolve though...
Another great video Shane. I do this all the time but I have a slightly different approach. I do the two collections to add the All, but then for each dropdown I have a hidden label with the dropdown result based on the IF. If(Dropdown?.Selected.Result = "All","",Dropdown?.Selected.Result )The my items filter uses Startswith() based on the Labels. I have one Gallery with over 25000 records that has three dropdowns and three Text Input fields. Two of the Text Input are ID fields. This approach allows for a filter for the Gallery to be based on one or all of the fields. I use an IF to use the ID Fields in isolation.
Hi Shane, I'm using a shorter solution that I hope you'll find interesting. Here is an example with 3 Dropdowns : Filter( Requests, If(IsBlank(Dropdownstatus.Selected.Value), true,Dropdownstatus.Selected.Value = Status), If(IsBlank(Dropdowntype.Selected.Value),true,Dropdowntype.Selected.Value = Type), If(IsBlank(Dropdowncustomer.Selected.cre86_name),true,Dropdowncustomer.Selected.cre86_name = Customer.Name) ) Thank you for your videos .
I just want to comment that I had a very hard time with this but it was also due to my own fault, lol. I'm using a region and location from a different source but I'm using the location as the filter. On the OnVisible Property, instead of using Collect for the static record, I had to use another ClearCollect as "All" is already being used in my filter using Distinct. Surprisingly, I didn't have to modify the if statement (after several tries, mind you, lol). Also surprising, I watched this video a little while ago but it didn't HIT me that maybe I should pay closer attention until I decided to tackle the delegation as there's no reason for the icon to show (got that from your other videos). All in all, I was able to successfully add the functions into my app. Anyways, love your videos, they've helped me immensely, and I've shared with fellow app makers your feats. Thanks again!
I am building out the option for 3 dropdowns and has seemed very straightforward. It was mentioned at about 23:09 of the video about needing 9 combinations. I can only find 8 combinations and so was inquiring what combination I might be missing. I am having trouble with all data returning for the "All", "All", "All" option, but all other scenarios work. What I have is a label that's doing a SUM of the gallery for a distinct column of data, and so the SUM is not gathering all of the data in the gallery of this column which has been my test for each of the scenarios to make sure it's working.
Thanks Shane, I would like you to make a video in which you explain how to create an alert to the mail or with push notifications in which you warn that there is some time to reach a deadline, that is, an alert that notifies an upcoming date, greetings from Chile.
Hi Shane . Problem solved. I had to 'un pack' and fine tune my code further 'bit by bit' ( as you suggested), and eventually I got it right. Thanks for your support and tips . Kind Regards Martin
Hi Shane. I have a dropdown based on a choice column (status for production). My dropdown items hence is set to: Choices('Production Calendar'.Status) , this returns 3 values. Not Results. How should I modify the: 'ClearCollect(collectStatus, {Result: "All"}); so that the dropdown list 'All' as well?
This is exactly what I needed this morning. I have a twist. 2 dropdowns. Filter and Sort. The initial concept isn't difficult. Is it possible to sort a column so items with an blank value are shown first and the remaining items are shown in either ascending or descending order? Example: Sorting a Status column would return the items in this order. Blank, Approved, Completed, Deferrred, Needs More Info, Rejected
Wow! Exactly what I was looking for. Thanks Shane. I'm sure Chewy had a hand (paw) in it though. Although, it doesnt work with the OnVisible ClearCollect since my dropdown is based on a choice field 'Category'. Filtering works fine using the first section because you can pull in fieldname.value. Using the ClearCollect OnVisible doesn't seem to offer the 'value' part of the expression. Surprise!! I have to use Choices('listname'.choicefield) so this doesnt work in the OnVisible property in order to setup for "All" SO, for anyone interested or those that have the same issue, this little variation works: [OnVisible] ClearCollect(colCategory, {Value:"All"}); Collect(colCategory, Choices('Grocery Items'.ITEM_x0020_CATEGORY)) [GALLERY ITEMS} If(ddCategory.Selected.Value = "All", 'Grocery Items', Filter('Grocery Items',ITEM_x0020_CATEGORY.Value = ddCategory.Selected.Value)) Obviously I now have to figure out the sorting part.
I think I've watched this video every month for the last 6 months, and get a little more out of it each time. Thank you. I am at the point where I might be so bold as to critique. That last Filter with the "And"... I believe multiple logical-tests in a filter are AND-ed, so you could put the two logical tests separated by commas, rather than combined with an And. Maybe there are delegation or performance ramifications?
You are correct about the , and the And being the same thing. I don’t believe one way or the other affects anything though. I believe they are the same
Great video! My only sticking point right now is how can I get the second drop-down to show options only after the first drop-down is selected. I'm trying the cascading method from that video but I can't get it to work.
When I use the first drop down box, and build the function in OnVisible as you have, the collection evaluates with "All" under the "Result" column and nothing in a "Value" column for that row. The is has my choices in the "Value" column of the next few rows, with nothing in the "Result" column.
Sharing another tactic to show "all". I was able to avoid building a collection to show "all". Instead I used a IF(ISBlank(dropdown),"Standard Filter Gallery without dropdown","Standard Filter Gallery with dropdown". Don't know if better because it doubles the formula length, but accomplishes same functionality.
I had an issue where the dropdown was resetting to all after a I went to a details page and then back. It's because populating the variable using OnVisible rebuilds the list every time you view the page. The solution was to move those fields to OnStart under the App (at the top of the left panel)
Hi Shane, great video, really helped me a lot! One last thing I am trying to accomplish is the Search box you included at the end. I have a column called Voyagenumber which contains integers and not text and that's why I can't get it to work. So far I've got the Search( If( //This is for all vessels and all status DDVessel.Selected.Value = "All" And DDStatus.Selected.Value = "All",Voyages, //This is for all vessels and selected status DDVessel.Selected.Value = "All" And DDStatus.Selected.Value "All", Filter(Voyages,Status.Value = DDStatus.Selected.Value), //This is for selected vessel and All status DDStatus.Selected.Value = "All" And DDVessel.Selected.Value "All", Filter(Voyages,Vessel.Value = DDVessel.Selected.Value), //This is for selected vessel and selected status DDVessel.Selected.Value "All" And DDStatus.Selected.Value "All", Filter(Voyages,Vessel.Value = DDVessel.Selected.Value And Status.Value = DDStatus.Selected.Value) ), TextInput1.Text, and this is where it fails. Any tips on how to search on the Voyagenumber column? Much appreciated!
Hi, great video! Unfortunately I'm having difficultly right at the beginning. When I add the dropdown and select my datasource (items=my sharepoint list), it appears that none of my "choice" columns from my sharepoint list appear in the "value" for me to select. For example, I have sharepoint columns = status (new, in progress, closed, on hold), column = priority (critical, high, medium, low), etc...but none of these columns appear for me to select to tie to the dropdown. Any idea what I'm missing?
@shane I have problem here using ALL. How do we manage change/flip of screens in preview mode . To me combo box drop down is listing only ALL , but not the other drop down values . But it works when i go out of preview and into dev mode and flip screens
Hello, I have a question, I hope you can help me. I have several drop-down lists, where each one has a field, however these may change, let me explain. In the list In the data source, in the column I put the option "values can be added manually", however, when doing a test it does let me put the option, but it does not save it in sharepoint or in the app. Can values that are not defined in sharepoint be saved in the drop-down list?
This video shows you how to use the API to update a SharePoint Choice column to add it, I think that is what you are looking for. ua-cam.com/video/TH6oqsfxPaE/v-deo.html
I have spotted a couple comments below suggesting an easier method of doing the multiple filters rather than IF testing for All/All, All/Selected, Selected/All and Selected/Selected (which becomes 9 possibilities for 3 dropdowns) using IF statements within the Filter function, but I have got a method that just uses logical functions. Try: Filter(Employees, Department=ddDepartment.Selected.Result OR ddDepartment.Selected.Result="All", 'Favorite Color'.Value=ddColor.Selected.Result OR ddColor.Select.Result="-" ) Essentially each criteria/line of the filter returns True if the column matches the dropdown or the dropdown is All (or "-" or blank [use IsBlank]). Each additional dropdown or search box only adds one more criteria to the filter, don't know if there is a limit but even then you could put each criteria in parentheses with AND between each. I even included the text search function in my app within the filter - actually I forgot about Search when I did it - by adding a third criteria: TextInput2.Text in FirstName OR TextInput2.Text in LastName OR IsBlank(TextInput2.Text) I have got so many tips from your videos, I thought I would give one back.
@@ShanesCows Very nice video shane, been looking for this for quite some time.Thank you very much . Also i have multiple and multiple for filter i wanna do. You showed exampled for 2 dropdown. I have like more than 10 i wanna do. Is there any other alternative than the If, Not ,and . i can do baby steps for all . but just wanna know if theres other ways i can do it with in Powerapps.
Dear Shane, ihave a problem when i do a search in een gallery and select an item(record) it goes to the detailscreen but after a second the details go to another item(record). So it do not keep the focus on the record i selected in the browse gallery. Can you help, thank you in advance, Dave Jonker, Netherlands
I am pretty sure in this video I talk about varRecord. ua-cam.com/video/UWy5I_MuIgU/v-deo.html instead of using gallery.selected set a variable to varRecord with the selected record that way it can’t change.
I hit on the like and follow button on duration 22:52. You made it is just not a tutorial, it's you know the student reaction is when he can made it by himself.
@@ShanesCows Is there a way to use the text searchbox filter and the dropbox filter but change the text searchbox to allow partial search? for instance i previously used this "Filter('NTF Lookup',TextSearchBox1.Text in Title1,"Title")" when only using my searchbox and it would partial text search, but i have been unable to convert this into the format you used at the end of the video for using a searchbox and some dropboxes. My current search that does not allow partial looks like this "Search(Filter('NTF Lookup',Resolved.Value = dropdown1.Selected.Value),TextSearchBox1.Text,"Title")"
now that i am looking at that i think fiddled with it so much the original working search in script looks like it is no longer the same that i had before.
@@ShanesCows I ran into one small problem since I added the dropdowns. When a user filters the items and then clicks and goes to the details screen and comes back, the text search is still there but the dropdown's are back to All. Would I need to set a variable and pass it in as the default value or is there a simple tip. Or maybe I set something wrong somewhere when creating?
I followed the steps exactly and no matter what I do, The collection table has a value column not a result column. I then add the "all" exactly as you showed but I doesn't show.
Try creating again from scratch and it should work. I had same issues as you. And of course as noted below...Value is what is available now not Result.
Great video Shane! Would love to see how to create a filter experience for users that allows the user to filter their gallery data using 3+ columns. Right now the approach I would use for this scenario uses a lot of IF statements and the logic gets a bit unwieldy. I'm not sure I want to go there.
@10.06 i have stored the distinct query at on-visible as "ClearCollect(First, Distinct(Compute,portfolio))" but when i use First in dropdown1 , the data is not getting displayed
Great content, Shane. Need help on the one type you omitted. Have to filter based on dropdown and date field together. Not much out there on datepicker filtering much less date and D’s selection.
Hey Shane, great video once again and I was keen to see this one as I am currently working on a gallery that I want to give users the ability to filter in a number of ways. I would love to know the steps of creating a gallery that is filtered with a combination of dropdowns and a combobox and possibly search as well. So essentially you have two dropdowns where you filter by fields when you only want to select a single record, but then use a combobox for a field where you want to see items relating to multiple records. As an example based on this video, imagine you had a company that had multiple work sites. Here you not only want to find out what an employees favourite colour was and which department they worked in, but you also wanted to know which work site they belonged to. So you could quickly see all the employees in the IT department at say work sites A&B (and not sites C&D) and see what their favourite colours were.....Hope that makes sense
Hi Shane, is there a workaround in the Distinct function if my data source is a sharepoint list? Distinct(Employees, Department) is not working on my end, could it be because of the datasource? Please help. Thanks!
@@ShanesCows hi shane thanks so much for the quick response. Actually yeah, there was issue on the column so i just created a fresh sharepoint list and the distinct funtion worked.
Hi Shane, thanks for this tutorial but need some help as im stuck in the collection. When i try to use the CollectVideo to Dropdown Items it doesn't work and shows no data. Hope you could help. Thanks!
I finally managed to do everything you did and more. I am blown away by the way you explain things. Absolutely brilliant. I had difficulties at the start following the steps as my Dropdowns use Complex Columns, and for a newbie like me, it was so hard to figure out. Have your covered relational database like training? Because that will be interesting. Thank you very much.
Hi I am using a sharepoint dropdown field in my PowerApps Dropdown but it is not able to pick up this sharepoint field (it is picking up other text fields though). How can I solve this? Thanks
Hi Shane, Question: @5.18 When I try to click on value, I see a bunch of columns - Compliance ID, Created.. etc but not those I'd want to select (have created in sharepoint). Appreciate your help here.
Hi Shane, I have created a powerapp from an existing sharepoint list. I have setup a few custom fields to give the form a parent/child ability as well and I am able to fill the form in via the app and submit. All the data gets sent to the sharepoint list except the parent child fields data. What am i doing wrong. I have exhausted google searching.
Hi Shane! Thanks for your videos! I'm building an app for mobile-use, everything was ok (Desktop everything worked fine, thanks to you) but galleries doesnt show the images, neither powerapp in browser nor the app, (The gallery gets data from a Sharepoint list, the images are as files in Sharepoint too and placed as links in a hyperlink column)... Maybe something missing?
Hello Shane! I have 5 filters that need this logic. Can you explain a little more about the "filtering collections upon collections" you mentioned in this video, or a different direction you think might be more effective?
Sorry I am slow Ana. You click a button to filter the data OnSelect I process each control one at a time. Updating a collection with the results until I get to a final collection. If(dropdown 1 = All, ClearCollect(collectedItems, datasourece), ClearCollect(collectedItems, Filter(datasourece, column = dropdown1); Do that 5 times. :)
Hey Shane, firstly LOVE YOUR VIDEOS, appreciate everything you have done to help in this space. Issue I am having is I am trying to do a search and a filter. I have been successful in combining the two and being able to use the ClearCollect and "ALL" filter classification for my list however, I cannot seem to search on the ALL filter. I have a distinct feeling its because of the Clear Collect but I am not sure how to work around it. Any suggestions?
@@ShanesCows I am having the same issue Robert is having! I watched the video you suggested but am still not able to figure out how to search on the ALL filter. Any other suggestions?
Great video. What if I was to use a checkbox, and wanted to filter so that a checked checkbox only showed SharePoint list entries with a "yes" value, and and unchecked box showed only entries with a "no" value? After hours of playing around, I still havent been able to solve this :(
Hi Shane, thanks a lot for all your videos. I needed a help. How can sort the filter dropdown list ? i.e. in the video we are using clear collect and distinct. So, how can I sort the dropdown list values in alphabetic order ?
Hi Shane, why not write a filter statement like: Filter( dataSource, If(ddDeparment='All', true, Department=ddDepartment.selected.result) and If(ddColor = '-', true, favoriteColor=ddColor.selected.result)) Is your method better for performance?
Nice video, Shane! But I have a question, I am trying to sort by ascending my gallery with the value of ["Bioa",Bio-c", "Biob"]. It shows the following order like this 1. Bio-c 2. Bioa 3. Biob. What I am expecting is 1. Bioa 2. Biob 3. Bio-c like from excel. Hope you can find some time to help me. Thanks!
5:39 when I type in my equivalent of "Department" it puts ' ' on either side. Doesnt work when I erase them either. Mine is called Batch Number and it should like to a column in a SP list. Any suggestions?
IT is because you have a space in your display name. So you need 'Batch Number'. This video will help you understand column names a bit better. ua-cam.com/video/mwXnJUkTug0/v-deo.html
@@ShanesCows Ok im getting much farther now. I have made it to the "All" option but when I follow up to that point it seems to corrupt my collection. The error says "Expected a different collection record structure" It is a plain text field populated with numbers
Hi Shane - this is amazing.... Thank you for always sharing your knowledge with us. CAn you also put some light on using this with SORT function as well. Thanks
Hey Shane. Great video. I also bought the everything plan on the site. Question - I did as you described and works great, but then I found a different example (not one of yours) that doesn't use the IF statement and instead just uses Filter(table, dropdown1 = "All" Or TableColumn1 = dropdown1.selected.value, dropdown2 = "All" Or TableColumn2 = dropdown2.selected.value, dropdown3 = "All" Or TableColumn3 = dropdown3.selected.value) Seems more straight forward and also seems to work. Each additional dropdown just repeat. I'm assuming I'm missing some reason why you suggest your method here instead, but cants seem to figure out what that may be?
Interesting. I have never thought about it that way. I don't see why that wouldn't work but not sure, haven't tried it. The joys of Power Apps, so many ways to do the same thing. :)
Hi, Shane. I have a display problem. On PC, the gallery images looks good, but on the phone, the image is not seen. I have tried on IOS and ADROID but they don't look. Can You Help Me Please.?
Great videos, big fan. For this video, I got off-track really early, in the first Filter() call, in fact: Filter(HouseholdInteractionSurveyData, DoorAnswer = DoorAnswerDD.Selected.Value) ( .Result is not an option) I am drawing off of a SP list, HouseholdInteractionSurveyData, that has a header, DoorAnswer. I have a Dropdown called DoorAnswerDD. I get a red underscore under the equal sign, "Invalid Argument Type." DoorAnswer and DoorAnswerDD are both Control data types. DoorAnswer was originally gathered via a dropdown. If you can offer any advice, it would be greatly appreciated. Thank you, Shane.
Here is the working reply I got off of Power Apps Forum: Filter(HouseholdInteractionSurveyData, DoorAnswer.Value = DoorAnswerDD.Selected.Value) I needed this because the column data type for my SharePoint list was Choice
Hello Shane, I am getting my data from a sharepoint list. I have some fields as Dropdown lists set in Sharepoint. None of the dropdown list I am able to add to the Search string, if I add it it returns me an error. Do you know why?
Hi @Shane ~ tried to use your example but somehow even though my fields do not have single quotation in the excel file that was later converted to a SharePoint List, whenever I try to use the same formula, it was giving errors due to having single quotation on both side of each column (i.e. Column1 changed into 'Column1') ... whenever I tried to remove the single quotation ... well the red line was all over the forrnula. Thank you!
Dear Sir, i'm Frustrated & Exhausted in this Simple Formula. i have cross checked this again & again. didn't understanding, where exactly i'm missing. my SP list column name is "Status" Filter('GRN List', Status = ComboBox1.Selected.Value) it's still showing the error 😢
Hi Shane - so helpful. I'm trying to build this, but with attached documents instead of people listed, so that you could have dropdowns by document type, then click on a document to see it / download it. Would this be possible?
I use to do it in Excel using Indirect Function. Below is the formula i am using. All I want is to replace "Impact Award" with dropdown1 selected text. If(Dropdown2.Selected.Result="All Units", 'Impact Award', Filter('Impact Award', Unit = Dropdown2.Selected.Result)) So there is total 2 dropdowns, Type of project and unit selection. User should first select the type of project and then the unit name. Unit name column is there in all the lists. Do you still think its not possible without creating multiple gallery.
Hey Shane. I am having this issue, I initialize a collection On Visible, and I also have the All added. I am even able to filter through stuff using the combo box. However, the drop down has the correct number of slots, and each does what it should, except there is no text, so you have no idea what you are clicking on. Any idea what I may have done wrong, or how to fix this?
@11:35, I tried to mimic you, but I am getting red X for the Screen, the Gallery, and the Filter box. Incompatible type, Invalid argument type, expected a different record structure- respectively are the error messages.
I have a gallery with employee data. In another Sharepoint list, I have data about positions. The link between Employee and Positions is position ID. How can I filter the galler with Employees who are on specific position - by position name, which is only in the Position list? Thx
I did it exactly the same till 22:40, but I'm getting error on the last if statement: "//This is for selected department and selected color". Power Apps is highlighting the first red and second blue in this statement. Red: "Incompatible types for comparison. These types cannot be compared: Text, Error." Blue: "Incompatible types for comparison. These types cannot be compared: Boolean, Error." The only thing i did differently i called both of them "All". And this error doesn't make sense, because the first 3 if statements work properly EDIT after 1 hour of clicking around re-typing it 3 times, this suddenly works. Probably related to the table being a bit slow to refresh/sometimes Power Apps seems to "break" for a moment. Anyway, very helpful video, thanks
Hi, I don’t know if this is possible... I am trying to create a search but essentially using drop down to filter categories. When I try to do this my column from share point doesn’t come up as an option... is it because it is a drop down that lets you select multiples? Therefor is it not possible or do you have a video that covers this? Thanks kelly
Oh wow, this answered TONS of questions I had - thank you, Shane! My one dilemma is... what if the Search box is looking for numbers, because when a numeric value is entered there, only employees with that same or greater numeric value should be found? I did hear you say, "Search function only works with text columns" ... do I need to adjust the column in Sharepoint from "Currency" to "Single line of text"?
Thank you for leaving the moments where you have no idea what's going on...I think we spend most of our time in PowerApps in that state! It helps a lot 😊
You’re welcome. Several people have told me that my issues help them connect the dots. 😎
Oh yes... I totally agree!!!
Thank you Shane, for giving people who have no idea what they are doing the opportunity to impress other people that have no idea what they are doing! Making me look like a rock start!
Awesome Peter! 🤩
Thank you for hard work you´re has been doing to the rest of the mortals.
From two week´s ago, you´re my "Master of Powerapps" (like He-Man was of the universe!).
Hugs from Córdoba, Argentine to Cincinnatti.
Thanks Diego. I loved that cartoon🐶
Random comment but I find it funny that every PowerApps teacher on UA-cam always says: "But first, here's the intro!". Its the only time time I've every seen someone introduce an introduction.
I didn’t know anyone did it besides me? 100+ videos of doing it most of my viewers expect it. 🐶
Thank you, i learned a lot, there maybe some new techniques but i keep on watching your other Videos based on filtering and make my notes. It took me 90min to write down everything and combine that with screenshots. I have a very good docu to your video which i put on my favorite list.
Happy to help!
Searched all afternoon for how to do this. Thanks for the great video!
Glad I could help!
Thanks so much! Your channel is my usual go-to for power apps and related. All excellent videos.
Great to hear!
Shane, Love your videos. To the point and with some humor. Learned so much from your work. Thanks!
Thanks Martin. 😎
This is so awesome. Takes a while to wrap the head around it, but it's beautiful. But lots and lots of dropdown filters is complicated.
I have a better way now 🤩 ua-cam.com/video/Fstk03c9dcg/v-deo.html
Awesome stuff Shane!!! I couldn't finish this app without all of your help!
Glad it helps Eric!
Thank you so much Shane, this just saved me hours of figuring out the filter.
Glad to help. 😀
Thank you for this, I enjoy practicing on your Vedio and I learn a lot. I appreciate how you follow simple approaches and add functionalities gradually, it makes my practice less overwhelming. thank you so much.
Glad it was helpful!
Wow wow wow.... finally I prepared my own application with the help of your video... Thanks, Much bro.. Had so many difficulties in between, but I was able to resolve though...
Excellent work as usual, Shane!!
Thanks!
Another great video Shane. I do this all the time but I have a slightly different approach. I do the two collections to add the All, but then for each dropdown I have a hidden label with the dropdown result based on the IF. If(Dropdown?.Selected.Result = "All","",Dropdown?.Selected.Result )The my items filter uses Startswith() based on the Labels. I have one Gallery with over 25000 records that has three dropdowns and three Text Input fields. Two of the Text Input are ID fields. This approach allows for a filter for the Gallery to be based on one or all of the fields. I use an IF to use the ID Fields in isolation.
Thanks for sharing Mark 😎
I watched timestamp 13:45 to 14:30 on 0.75 speed and it was hilarious. This video saved my butt today. Thank you!
Glad I could entertain 😂
Hi Shane,
I'm using a shorter solution that I hope you'll find interesting.
Here is an example with 3 Dropdowns :
Filter(
Requests,
If(IsBlank(Dropdownstatus.Selected.Value), true,Dropdownstatus.Selected.Value = Status),
If(IsBlank(Dropdowntype.Selected.Value),true,Dropdowntype.Selected.Value = Type),
If(IsBlank(Dropdowncustomer.Selected.cre86_name),true,Dropdowncustomer.Selected.cre86_name = Customer.Name)
)
Thank you for your videos .
I didn't see Derek Shannon used quite the same solution ^^'
Very nice. Thanks for sharing. 😀
Thank you Shane for sharing this link. You rock and I have learned a lot from your videos.
My pleasure!
This is gold, really liked this video, really helped me alot. Keep up the great content.
Thanks. You might like this later video that shows and even easier way to do it. :) ua-cam.com/video/Fstk03c9dcg/v-deo.html
Awesome Shane, thanks so much for sharing. I've just used this to add filtering to a form in Project Oakdale.
Nice Job Alex.
I just want to comment that I had a very hard time with this but it was also due to my own fault, lol. I'm using a region and location from a different source but I'm using the location as the filter. On the OnVisible Property, instead of using Collect for the static record, I had to use another ClearCollect as "All" is already being used in my filter using Distinct. Surprisingly, I didn't have to modify the if statement (after several tries, mind you, lol). Also surprising, I watched this video a little while ago but it didn't HIT me that maybe I should pay closer attention until I decided to tackle the delegation as there's no reason for the icon to show (got that from your other videos). All in all, I was able to successfully add the functions into my app. Anyways, love your videos, they've helped me immensely, and I've shared with fellow app makers your feats. Thanks again!
Glad you got it and thank you for sharing with others so everyone learns. 🐶
Seriously Shane, thank you! Also, my favorite line that I now use of yours “Why are you mad?!”
I am building out the option for 3 dropdowns and has seemed very straightforward. It was mentioned at about 23:09 of the video about needing 9 combinations. I can only find 8 combinations and so was inquiring what combination I might be missing. I am having trouble with all data returning for the "All", "All", "All" option, but all other scenarios work. What I have is a label that's doing a SUM of the gallery for a distinct column of data, and so the SUM is not gathering all of the data in the gallery of this column which has been my test for each of the scenarios to make sure it's working.
Thanks Shane, I would like you to make a video in which you explain how to create an alert to the mail or with push notifications in which you warn that there is some time to reach a deadline, that is, an alert that notifies an upcoming date, greetings from Chile.
I would use flow for that. Sounds like a great video.
Hi Shane . Problem solved. I had to 'un pack' and fine tune my code further 'bit by bit' ( as you suggested), and eventually I got it right. Thanks for your support and tips . Kind Regards Martin
Good job Martin. I am proud of you for breaking it down. 🐶
Hi Shane. I have a dropdown based on a choice column (status for production).
My dropdown items hence is set to: Choices('Production Calendar'.Status) , this returns 3 values. Not Results.
How should I modify the: 'ClearCollect(collectStatus, {Result: "All"}); so that the dropdown list 'All' as well?
Thanks a lot🤝, much needed video indeed. Keep sharing your wisdom!!
My pleasure 😊
This is exactly what I needed this morning. I have a twist. 2 dropdowns. Filter and Sort. The initial concept isn't difficult. Is it possible to sort a column so items with an blank value are shown first and the remaining items are shown in either ascending or descending order? Example: Sorting a Status column would return the items in this order. Blank, Approved, Completed, Deferrred, Needs More Info, Rejected
Hey Juli hopefully we got this on class. 😀
Thank you Shane! I understand the logic behind all this! Thank you!
Glad it helped you!
Thank you Shane! This was very helpful!!! I appreciate all you do.
Glad it was helpful!
Wow! Exactly what I was looking for. Thanks Shane. I'm sure Chewy had a hand (paw) in it though. Although, it doesnt work with the OnVisible ClearCollect since my dropdown is based on a choice field 'Category'. Filtering works fine using the first section because you can pull in fieldname.value. Using the ClearCollect OnVisible doesn't seem to offer the 'value' part of the expression. Surprise!!
I have to use Choices('listname'.choicefield) so this doesnt work in the OnVisible property in order to setup for "All" SO, for anyone interested or those that have the same issue, this little variation works:
[OnVisible]
ClearCollect(colCategory, {Value:"All"});
Collect(colCategory, Choices('Grocery Items'.ITEM_x0020_CATEGORY))
[GALLERY ITEMS}
If(ddCategory.Selected.Value = "All", 'Grocery Items', Filter('Grocery Items',ITEM_x0020_CATEGORY.Value = ddCategory.Selected.Value))
Obviously I now have to figure out the sorting part.
Thanks for sharing!
I think I've watched this video every month for the last 6 months, and get a little more out of it each time. Thank you. I am at the point where I might be so bold as to critique. That last Filter with the "And"... I believe multiple logical-tests in a filter are AND-ed, so you could put the two logical tests separated by commas, rather than combined with an And. Maybe there are delegation or performance ramifications?
You are correct about the , and the And being the same thing. I don’t believe one way or the other affects anything though. I believe they are the same
Thanks Shane... very nice video and fun to watch
Glad you enjoyed it
Great video! My only sticking point right now is how can I get the second drop-down to show options only after the first drop-down is selected. I'm trying the cascading method from that video but I can't get it to work.
Maybe set the second dropdown to Visible = false if there isn't something set in the first?
Thanku so much Shane, for all your powerapps tutorial
My pleasure!
Shane this has helped me so much thank you !!
Happy to help. :)
When I use the first drop down box, and build the function in OnVisible as you have, the collection evaluates with "All" under the "Result" column and nothing in a "Value" column for that row. The is has my choices in the "Value" column of the next few rows, with nothing in the "Result" column.
Thanks Shane for another great tutorial. I'm developing a big app with power apps using your videos.
Awesome
Very usefull tutorial. Changed my life
Awesome
Sharing another tactic to show "all". I was able to avoid building a collection to show "all". Instead I used a IF(ISBlank(dropdown),"Standard Filter Gallery without dropdown","Standard Filter Gallery with dropdown". Don't know if better because it doubles the formula length, but accomplishes same functionality.
Thanks for sharing! 🐶
I had an issue where the dropdown was resetting to all after a I went to a details page and then back. It's because populating the variable using OnVisible rebuilds the list every time you view the page. The solution was to move those fields to OnStart under the App (at the top of the left panel)
Thanks for sharing
Brilliant solution. Works perfect thanks
Hi Shane, great video, really helped me a lot! One last thing I am trying to accomplish is the Search box you included at the end. I have a column called Voyagenumber which contains integers and not text and that's why I can't get it to work. So far I've got the
Search(
If(
//This is for all vessels and all status
DDVessel.Selected.Value = "All" And DDStatus.Selected.Value = "All",Voyages,
//This is for all vessels and selected status
DDVessel.Selected.Value = "All" And DDStatus.Selected.Value "All",
Filter(Voyages,Status.Value = DDStatus.Selected.Value),
//This is for selected vessel and All status
DDStatus.Selected.Value = "All" And DDVessel.Selected.Value "All",
Filter(Voyages,Vessel.Value = DDVessel.Selected.Value),
//This is for selected vessel and selected status
DDVessel.Selected.Value "All" And DDStatus.Selected.Value "All",
Filter(Voyages,Vessel.Value = DDVessel.Selected.Value And Status.Value = DDStatus.Selected.Value)
),
TextInput1.Text, and this is where it fails. Any tips on how to search on the Voyagenumber column? Much appreciated!
You can only Search text columns 😕
Hi, great video! Unfortunately I'm having difficultly right at the beginning. When I add the dropdown and select my datasource (items=my sharepoint list), it appears that none of my "choice" columns from my sharepoint list appear in the "value" for me to select. For example, I have sharepoint columns = status (new, in progress, closed, on hold), column = priority (critical, high, medium, low), etc...but none of these columns appear for me to select to tie to the dropdown. Any idea what I'm missing?
@shane I have problem here using ALL. How do we manage change/flip of screens in preview mode . To me combo box drop down is listing only ALL , but not the other drop down values . But it works when i go out of preview and into dev mode and flip screens
I am not sure Sri. 😑
Hello,
I have a question, I hope you can help me.
I have several drop-down lists, where each one has a field, however these may change, let me explain.
In the list
In the data source, in the column I put the option "values can be added manually", however, when doing a test it does let me put the option, but it does not save it in sharepoint or in the app.
Can values that are not defined in sharepoint be saved in the drop-down list?
This video shows you how to use the API to update a SharePoint Choice column to add it, I think that is what you are looking for. ua-cam.com/video/TH6oqsfxPaE/v-deo.html
I have spotted a couple comments below suggesting an easier method of doing the multiple filters rather than IF testing for All/All, All/Selected, Selected/All and Selected/Selected (which becomes 9 possibilities for 3 dropdowns) using IF statements within the Filter function, but I have got a method that just uses logical functions.
Try:
Filter(Employees,
Department=ddDepartment.Selected.Result OR ddDepartment.Selected.Result="All",
'Favorite Color'.Value=ddColor.Selected.Result OR ddColor.Select.Result="-"
)
Essentially each criteria/line of the filter returns True if the column matches the dropdown or the dropdown is All (or "-" or blank [use IsBlank]). Each additional dropdown or search box only adds one more criteria to the filter, don't know if there is a limit but even then you could put each criteria in parentheses with AND between each. I even included the text search function in my app within the filter - actually I forgot about Search when I did it - by adding a third criteria:
TextInput2.Text in FirstName OR TextInput2.Text in LastName OR IsBlank(TextInput2.Text)
I have got so many tips from your videos, I thought I would give one back.
Thanks for sharing David. 🤩
Your videos lead to great learning :)
Glad you like them!
Great video Shane. I’m assuming you can do the same with Combo boxes for the filters?? Would also like to see the options for more than 3 filters too.
Never tried for a Combobox but I would assume yes. 😊
@@ShanesCows Very nice video shane, been looking for this for quite some time.Thank you very much . Also i have multiple and multiple for filter i wanna do. You showed exampled for 2 dropdown. I have like more than 10 i wanna do. Is there any other alternative than the If, Not ,and . i can do baby steps for all . but just wanna know if theres other ways i can do it with in Powerapps.
@@AdroitZen Same Here! Did you find out a way?
@@ShanesCows For some reason, combo box is not returning "All" value on screen visible. Your solution only applicable for Dropdown boxes.
Dear Shane, ihave a problem when i do a search in een gallery and select an item(record) it goes to the detailscreen but after a second the details go to another item(record). So it do not keep the focus on the record i selected in the browse gallery. Can you help, thank you in advance, Dave Jonker, Netherlands
I am pretty sure in this video I talk about varRecord. ua-cam.com/video/UWy5I_MuIgU/v-deo.html instead of using gallery.selected set a variable to varRecord with the selected record that way it can’t change.
I hit on the like and follow button on duration 22:52. You made it is just not a tutorial, it's you know the student reaction is when he can made it by himself.
Thank you, glad it helped. 😎
Thank you. This is exactly what i was looking for.
Glad it was helpful!
@@ShanesCows Is there a way to use the text searchbox filter and the dropbox filter but change the text searchbox to allow partial search? for instance i previously used this "Filter('NTF Lookup',TextSearchBox1.Text in Title1,"Title")" when only using my searchbox and it would partial text search, but i have been unable to convert this into the format you used at the end of the video for using a searchbox and some dropboxes. My current search that does not allow partial looks like this "Search(Filter('NTF Lookup',Resolved.Value = dropdown1.Selected.Value),TextSearchBox1.Text,"Title")"
now that i am looking at that i think fiddled with it so much the original working search in script looks like it is no longer the same that i had before.
Brilliant as always. This is exactly the solution I needed
Awesome sauce!
@@ShanesCows I ran into one small problem since I added the dropdowns. When a user filters the items and then clicks and goes to the details screen and comes back, the text search is still there but the dropdown's are back to All. Would I need to set a variable and pass it in as the default value or is there a simple tip. Or maybe I set something wrong somewhere when creating?
@@ShanesCows I just seen the solution further down in the comments by Joseph.
I followed the steps exactly and no matter what I do, The collection table has a value column not a result column. I then add the "all" exactly as you showed but I doesn't show.
They changed the function so now it outputs Value. Replace where I used Result with Value and it should all still work.
Try creating again from scratch and it should work. I had same issues as you. And of course as noted below...Value is what is available now not Result.
Great video Shane! Would love to see how to create a filter experience for users that allows the user to filter their gallery data using 3+ columns. Right now the approach I would use for this scenario uses a lot of IF statements and the logic gets a bit unwieldy. I'm not sure I want to go there.
One day I will cover it. One day. 😑 So many videos I need to do. 😀
Hi, thank you for the video, I was trying to do the collect but it’s not showing any records in the drop down.
Make sure you are showing the right field in the dropdown. Also, make sure there are items in your collection.
@@ShanesCows thanks for your quick response! I tried checking the collection and it wasn’t showing any items as well.
@10.06 i have stored the distinct query at on-visible as "ClearCollect(First, Distinct(Compute,portfolio))" but when i use First in dropdown1 , the data is not getting displayed
I would try using Distinct formula directly and see if it returns results.
@@ShanesCows Distinct query is working fine. Thank you
You are a life-saver!
Happy to help
love u sir!. i have been fed up i didn't find any solution. here i fix it.
Glad I could help
Hi Shane, Is there a cascading dropdown option for this? I need the 2nd dropdown results to only show what's filtered on the first dropdown
I don't see why you couldn't use this. ua-cam.com/video/pkZG2boN7jQ/v-deo.html
Hi!
For the Dropdown list, I cannot find the name of my column in the Value Properties. What could be wrong?
Did you use a function like Distinct maybe? It changes the items
Great content, Shane. Need help on the one type you omitted. Have to filter based on dropdown and date field together. Not much out there on datepicker filtering much less date and D’s selection.
Depends on the data source. Sadly SharePoint has delegation issues with dates. 😑
Hey Shane, great video once again and I was keen to see this one as I am currently working on a gallery that I want to give users the ability to filter in a number of ways. I would love to know the steps of creating a gallery that is filtered with a combination of dropdowns and a combobox and possibly search as well. So essentially you have two dropdowns where you filter by fields when you only want to select a single record, but then use a combobox for a field where you want to see items relating to multiple records. As an example based on this video, imagine you had a company that had multiple work sites. Here you not only want to find out what an employees favourite colour was and which department they worked in, but you also wanted to know which work site they belonged to. So you could quickly see all the employees in the IT department at say work sites A&B (and not sites C&D) and see what their favourite colours were.....Hope that makes sense
It does. I will have to think about a future more complex video. The In function will help you in the meantime
Hi Shane, is there a workaround in the Distinct function if my data source is a sharepoint list? Distinct(Employees, Department) is not working on my end, could it be because of the datasource? Please help. Thanks!
Maybe try a different column? I have never seen distinct not work. 🤔
@@ShanesCows hi shane thanks so much for the quick response. Actually yeah, there was issue on the column so i just created a fresh sharepoint list and the distinct funtion worked.
Hi Shane, thanks for this tutorial but need some help as im stuck in the collection. When i try to use the CollectVideo to Dropdown Items it doesn't work and shows no data. Hope you could help. Thanks!
I finally managed to do everything you did and more. I am blown away by the way you explain things. Absolutely brilliant. I had difficulties at the start following the steps as my Dropdowns use Complex Columns, and for a newbie like me, it was so hard to figure out. Have your covered relational database like training? Because that will be interesting. Thank you very much.
Maybe this will help? ua-cam.com/video/jmh8eeQVAIc/v-deo.html
Hi I am using a sharepoint dropdown field in my PowerApps Dropdown but it is not able to pick up this sharepoint field (it is picking up other text fields though). How can I solve this? Thanks
Awesome video Shane!
Thanks!
Hi Shane,
Question: @5.18 When I try to click on value, I see a bunch of columns - Compliance ID, Created.. etc but not those I'd want to select (have created in sharepoint).
Appreciate your help here.
All of your columns are there. Maybe they are showing their encoded names
Facing the same issue, i am using sharepoint list too. The value doesn't show all my columns of type Choice
Hi Shane, I have created a powerapp from an existing sharepoint list. I have setup a few custom fields to give the form a parent/child ability as well and I am able to fill the form in via the app and submit. All the data gets sent to the sharepoint list except the parent child fields data. What am i doing wrong. I have exhausted google searching.
Maybe this video will help? ua-cam.com/video/xgznk4XlPCo/v-deo.html
@shane Would the same steps work for a combo box ?
Yes, it should.
Hi Shane! Thanks for your videos!
I'm building an app for mobile-use, everything was ok (Desktop everything worked fine, thanks to you) but galleries doesnt show the images, neither powerapp in browser nor the app, (The gallery gets data from a Sharepoint list, the images are as files in Sharepoint too and placed as links in a hyperlink column)... Maybe something missing?
I tried with other list in sharepoint (which has images in a "Image" Column) and Works!
Anyway, thank you for your videos, you are the best!
Glad you got it. There are some challenges with SharePoint images on mobile.
Hi Shane, you recently showed another method to add an "All" option to a dropdown without using collection, where was it? Thanks.
I think it was toward the end of this video. ua-cam.com/video/SKMwayf_cuM/v-deo.html
@@ShanesCows THANKS!
I know it's been a few years but I'm just now jumping on the bandwagon. Instead if the complex If, would a Switch be a cleaner option?
Not sure if Switch would be better. But I did come up with a better way it is in this quick video ua-cam.com/video/Fstk03c9dcg/v-deo.html
Shane-Thanks so much for making this video. This is exactly what I was looking for! Implemented and tested and works exactly as you have described.
Great to hear!
Great video, thanks. Did you ever do a video where you show how to use more dropdowns?
I didn’t get to that. Maybe one day but not sure.
Hello Shane! I have 5 filters that need this logic. Can you explain a little more about the "filtering collections upon collections" you mentioned in this video, or a different direction you think might be more effective?
Sorry I am slow Ana. You click a button to filter the data OnSelect I process each control one at a time. Updating a collection with the results until I get to a final collection. If(dropdown 1 = All, ClearCollect(collectedItems, datasourece), ClearCollect(collectedItems, Filter(datasourece, column = dropdown1); Do that 5 times. :)
Hey Shane, firstly LOVE YOUR VIDEOS, appreciate everything you have done to help in this space. Issue I am having is I am trying to do a search and a filter. I have been successful in combining the two and being able to use the ClearCollect and "ALL" filter classification for my list however, I cannot seem to search on the ALL filter. I have a distinct feeling its because of the Clear Collect but I am not sure how to work around it. Any suggestions?
Robert check out this video. A better way to do it. 😎 Filtering your Gallery Better in Canvas Apps EP7
ua-cam.com/video/Fstk03c9dcg/v-deo.html
@@ShanesCows I am having the same issue Robert is having! I watched the video you suggested but am still not able to figure out how to search on the ALL filter. Any other suggestions?
Great video. What if I was to use a checkbox, and wanted to filter so that a checked checkbox only showed SharePoint list entries with a "yes" value, and and unchecked box showed only entries with a "no" value?
After hours of playing around, I still havent been able to solve this :(
I think it would be filter(datasource, column =checkbox.value) but maybe not. I don’t filter yes no too often.
Hi Shane, thanks a lot for all your videos. I needed a help. How can sort the filter dropdown list ? i.e. in the video we are using clear collect and distinct. So, how can I sort the dropdown list values in alphabetic order ?
Wrap it in a SortByColumns 😍
Hi Shane, why not write a filter statement like:
Filter( dataSource,
If(ddDeparment='All', true, Department=ddDepartment.selected.result)
and
If(ddColor = '-', true, favoriteColor=ddColor.selected.result))
Is your method better for performance?
My Method is terrible. :) I have a better method, I just need to make a video on it. Darn me. But you are on the right track.
Nice video, Shane! But I have a question, I am trying to sort by ascending my gallery with the value of ["Bioa",Bio-c", "Biob"]. It shows the following order like this 1. Bio-c 2. Bioa 3. Biob. What I am expecting is 1. Bioa 2. Biob 3. Bio-c like from excel. Hope you can find some time to help me. Thanks!
YOu might have to create your own custom Sort Order. 😐 ua-cam.com/video/_NCLeRpot3k/v-deo.html
5:39 when I type in my equivalent of "Department" it puts ' ' on either side. Doesnt work when I erase them either. Mine is called Batch Number and it should like to a column in a SP list. Any suggestions?
IT is because you have a space in your display name. So you need 'Batch Number'. This video will help you understand column names a bit better. ua-cam.com/video/mwXnJUkTug0/v-deo.html
@@ShanesCows Ok im getting much farther now. I have made it to the "All" option but when I follow up to that point it seems to corrupt my collection. The error says "Expected a different collection record structure" It is a plain text field populated with numbers
Its not letting me add the "All" to the collection and when I try thats when it goes into error
Hi Shane - this is amazing....
Thank you for always sharing your knowledge with us. CAn you also put some light on using this with SORT function as well.
Thanks
Put SortByColumns around the filter part of the formula.
@@ShanesCows thank you 👍🏾
@@ShanesCows Could you provide the syntax on how to do it? I'm just starting out with PowerApps, and these tutorials are teaching me a lot.
Hey Shane. Great video. I also bought the everything plan on the site.
Question - I did as you described and works great, but then I found a different example (not one of yours) that doesn't use the IF statement and instead just uses
Filter(table, dropdown1 = "All" Or TableColumn1 = dropdown1.selected.value, dropdown2 = "All" Or TableColumn2 = dropdown2.selected.value, dropdown3 = "All" Or TableColumn3 = dropdown3.selected.value)
Seems more straight forward and also seems to work. Each additional dropdown just repeat. I'm assuming I'm missing some reason why you suggest your method here instead, but cants seem to figure out what that may be?
Interesting. I have never thought about it that way. I don't see why that wouldn't work but not sure, haven't tried it. The joys of Power Apps, so many ways to do the same thing. :)
Hi, Shane. I have a display problem. On PC, the gallery images looks good, but on the phone, the image is not seen. I have tried on IOS and ADROID but they don't look. Can You Help Me Please.?
Because you are pulling the files from SharePoint and the mobile doesn’t have a cookie to authenticate with the file.
Great videos, big fan. For this video, I got off-track really early, in the first Filter() call, in fact:
Filter(HouseholdInteractionSurveyData, DoorAnswer = DoorAnswerDD.Selected.Value) ( .Result is not an option)
I am drawing off of a SP list, HouseholdInteractionSurveyData, that has a header, DoorAnswer. I have a Dropdown called DoorAnswerDD. I get a red underscore under the equal sign, "Invalid Argument Type."
DoorAnswer and DoorAnswerDD are both Control data types.
DoorAnswer was originally gathered via a dropdown.
If you can offer any advice, it would be greatly appreciated.
Thank you, Shane.
Here is the working reply I got off of Power Apps Forum:
Filter(HouseholdInteractionSurveyData, DoorAnswer.Value = DoorAnswerDD.Selected.Value)
I needed this because the column data type for my SharePoint list was Choice
Glad you got it.
Hello Shane,
I am getting my data from a sharepoint list. I have some fields as Dropdown lists set in Sharepoint.
None of the dropdown list I am able to add to the Search string, if I add it it returns me an error. Do you know why?
The search function only works on Text columns. Choice columns are complex data types, not text, so search doesn't work.
Hi @Shane ~ tried to use your example but somehow even though my fields do not have single quotation in the excel file that was later converted to a SharePoint List, whenever I try to use the same formula, it was giving errors due to having single quotation on both side of each column (i.e. Column1 changed into 'Column1') ... whenever I tried to remove the single quotation ... well the red line was all over the forrnula. Thank you!
Dear Sir,
i'm Frustrated & Exhausted in this Simple Formula.
i have cross checked this again & again. didn't understanding, where exactly i'm missing.
my SP list column name is "Status"
Filter('GRN List', Status = ComboBox1.Selected.Value)
it's still showing the error 😢
What type of column is Status? A choice column then it would be Status.Value 😀
Hi Shane - so helpful. I'm trying to build this, but with attached documents instead of people listed, so that you could have dropdowns by document type, then click on a document to see it / download it. Would this be possible?
As long as you have the data you should be able to filter it
I use to do it in Excel using Indirect Function. Below is the formula i am using. All I want is to replace "Impact Award" with dropdown1 selected text.
If(Dropdown2.Selected.Result="All Units", 'Impact Award', Filter('Impact Award', Unit = Dropdown2.Selected.Result))
So there is total 2 dropdowns, Type of project and unit selection. User should first select the type of project and then the unit name. Unit name column is there in all the lists. Do you still think its not possible without creating multiple gallery.
I am not sure. Without recreating your app I can picture this one. Sorry
Hey Shane. I am having this issue, I initialize a collection On Visible, and I also have the All added. I am even able to filter through stuff using the combo box. However, the drop down has the correct number of slots, and each does what it should, except there is no text, so you have no idea what you are clicking on. Any idea what I may have done wrong, or how to fix this?
@11:35, I tried to mimic you, but I am getting red X for the Screen, the Gallery, and the Filter box. Incompatible type, Invalid argument type, expected a different record structure- respectively are the error messages.
Sorry. Need to start at the beginning and find where you are setting the collection differently. You have a mismatch somewhere
Struggling there as well (hoping this is the crux of the climb !)
I have a gallery with employee data. In another Sharepoint list, I have data about positions. The link between Employee and Positions is position ID. How can I filter the galler with Employees who are on specific position - by position name, which is only in the Position list? Thx
I think I show some ideas in this video ua-cam.com/video/DylxsXIUyDc/v-deo.html
What happens with a table over 33K rows?? the distinct formula is not working
Distinct is not delegable 😕You will need a plan b. Learn more about delegation here ua-cam.com/video/UaBmVUQx_Fk/v-deo.html
I did it exactly the same till 22:40, but I'm getting error on the last if statement: "//This is for selected department and selected color". Power Apps is highlighting the first red and second blue in this statement.
Red: "Incompatible types for comparison. These types cannot be compared: Text, Error."
Blue: "Incompatible types for comparison. These types cannot be compared: Boolean, Error."
The only thing i did differently i called both of them "All". And this error doesn't make sense, because the first 3 if statements work properly
EDIT after 1 hour of clicking around re-typing it 3 times, this suddenly works. Probably related to the table being a bit slow to refresh/sometimes Power Apps seems to "break" for a moment. Anyway, very helpful video, thanks
Glad you got it!
Hi, I don’t know if this is possible... I am trying to create a search but essentially using drop down to filter categories. When I try to do this my column from share point doesn’t come up as an option... is it because it is a drop down that lets you select multiples? Therefor is it not possible or do you have a video that covers this? Thanks kelly
Oh wow, this answered TONS of questions I had - thank you, Shane! My one dilemma is... what if the Search box is looking for numbers, because when a numeric value is entered there, only employees with that same or greater numeric value should be found? I did hear you say, "Search function only works with text columns" ... do I need to adjust the column in Sharepoint from "Currency" to "Single line of text"?
You might have to in order to make search work
Awesome and very helpful video!! (You got another sub)
Thanks a million! 🐶
Great as always. Thank you for your job from Ukraine!!!! ))
Happy to help
Somehow the formula only allows me to use Value instead of Result and my gallery comes back empty when using the dropdown. Help?