The ungroup feature is so good! I've been struggling with the Power Up Program final app assignment and this has helped a LOT, thank you, Shane.
@ShanesCows
11 ай бұрын
Happy to help 😊
@JennyJenn831
Жыл бұрын
Every. Single. Time. You make me smarter! SortbyColumns, not just Sort. THANK YOU!
@ShanesCows
Жыл бұрын
Glad to help Jennifer. 🤩
@jaymarhonda
3 жыл бұрын
You Sir have blessed me with your videos!!! I am grateful for you help on several matters concerning Powerapps. I am new to this platform but it is so exciting!!!
@ShanesCows
3 жыл бұрын
Great to hear!
@erikparmlind6745
3 жыл бұрын
The Ungroup suggestion was useful for me. I have wanted to Sort a list of Companies but to still keep our company at the top. The Ungroup combined with Table function can achieve this.
@ShanesCows
3 жыл бұрын
Cool🐶
@AndreasMake
3 жыл бұрын
As usual, time well invested watching your videos Shane, keep em coming!
@ShanesCows
3 жыл бұрын
Much appreciated!
@MrsLaubie
3 жыл бұрын
Thank you so much for this video - the UnGroup tip at the end is fantastic. I've been struggling for weeks how to show "All" when filtering. Now I need to figure out how to do that with 2 dropdowns and 1 text search fiel at the same time ;-)
@ShanesCows
3 жыл бұрын
Glad it was helpful!
@akthar3
2 жыл бұрын
This is an amazing video! all 13 and half minutes are brilliant. Explanation for newly produced "Result" column (from distinct function) used by the SortByColumns() function in the dropdown box is excellent!
@allanclarke7265
3 жыл бұрын
Time well spent watching this. Managed to get mine to work after a few attempts. Great tutorial :)
@ShanesCows
3 жыл бұрын
Great to hear!
@TheKalipolis
3 жыл бұрын
This is exactly what I needed! I am asking my boss to authorize me to get your training. Crossing fingers and toes!
@user-tt3rn9me7w
3 жыл бұрын
God bless you health Shane!
@ShanesCows
3 жыл бұрын
Thanks 🙏
@vfsgizmo7471
3 жыл бұрын
Always very timely; I was working on something similar this week.
@ShanesCows
3 жыл бұрын
Awesome
@NKBobcat
3 жыл бұрын
All is great! Thanks Ed! And as always, thank you Shane.
@ShanesCows
3 жыл бұрын
My pleasure!
@ScottBendigo
3 жыл бұрын
Excellent! Exactly what I was looking for. That light on your ear is aliens shooting a laser beam trying to suck out all your genius smarts. Need that aluminum cap :)
@ShanesCows
3 жыл бұрын
😂 👽🛸😱
@sharepointtips9330
3 жыл бұрын
Ed didn't invent it.😂.That same formula was explicitly used in "Beginning PowerApps" book by Tim Leung page 184.I am glad you you made a video about it.Very informative!
@ShanesCows
3 жыл бұрын
Interesting. I have never seen the book. 😊
@josecarlosbenitezmeyer645
3 ай бұрын
Amazing, you have help me countless times. If I have a a table with various names and points in a column how can I get the distinct names with its values ?
@rashidkhalid2010
3 жыл бұрын
Wish it had worked for me using Dataverse table as source that has ~8,000 rows. Any suggestions?
@chrisholben6180
6 күн бұрын
You king
@ShanesCows
6 күн бұрын
🫅Glad to help!
@SA-kt3wt
3 жыл бұрын
Hi Shane I'm having trouble with an exceptionally basic task using filter and OR. I have a table with 5 columns. I want to sort my gallery using a dropdown for 2 of these columns (employee and department). I want to either filter by employee, or department, or both. I'm using Filter(table, employee=dropdownbox1.selected.employee). This works fine to filter employees. If I add "...selected.employee, OR(department=dropbox2.selected.department) it is then only filtering on the "employee" dropbox WITH the option in the department dropbox. Driving me mad!
@darrylalva
2 жыл бұрын
Hey Shane, Thank you for the video. I do see when you used distinct the value of Janitorial is repeating, I am facing the same issue with my data set. How did you go about resolving that? Thank you again
@ShanesCows
2 жыл бұрын
I think Janitorial was repeating because I had different spellings or spacing. If they are truly the same Distinct shouldn't repeat.
@jray1429
3 жыл бұрын
Thank you! Great work
@ShanesCows
3 жыл бұрын
You are welcome 🤗
@RobFahndrich1
3 жыл бұрын
Thanks Shane!
@ShanesCows
3 жыл бұрын
Hope it helps. 😀
@altino91255268
3 жыл бұрын
Shane, how are you? You could make videos about using groupby with ungroup + AddColumns.
@ShanesCows
3 жыл бұрын
Hope this helps. kzitem.info/news/bejne/rnqer56DaWqmYKw
@ParkerLearnsStuff
8 ай бұрын
Awesome video! Question, After I apply the drop down to my filter, it only filters the data that has already been called,(So only the original 2000 items get filtered). I'd like to apply the drop down filter to then get a new call to the data source so it now delegates that information and I can see more results that actually meet my filter but are being cut out because I'm exceeding the 2000 maximum on the initial call.
@optimisesocialmedia
3 жыл бұрын
Great video Shane. Is it possible to use Distinct within a Gallery? For example, i have a table that shows clients and interactions with clients. Interactions are dated. In the gallery i only want to show the latest interaction. I have used sorting and filtering of the gallery, but it still shows multiple interactions with the same client, it should just show the latest. Any ideas?
@user-ft2yd5rq6p
Жыл бұрын
Great work sir. Today is the 24th day since I started using PowerApps. I am learning and creating an app through which a team reports the number of items they sell daily. Each team member's monthly sales target is benchmarked at 45. I am currently stuck since my 19th day trying to figure out how to calculate each team member's 'rank' in their performance reports screen. I would easily use the RANK.EQ function in Excel but I don't know how to go about it in PowerApps. Please help me out sir.
@li_renschannel3084
Жыл бұрын
For some reason, I'm unable to get distinct values of dataverse table records in a combobox within a form. Any idea or videos to replicate this issue. Showing only blank combobox
@GutoRos
2 жыл бұрын
Awesome video tutorial, as usual! Thank you for all the knowledge you are sharing here on this incredible tool that is powerapps. I have a challenge here in my job to build an app and I’m learning by doing it. Most of the roadblocks I’m facing are regarded delegations, since my data source is like 10k+ rows (sharepoint list, soon to be dataverse tables). Does anyone knows how can I have that distinct values dropdown using a large dataset such as the one I have? I cannot see all the distinct values in my dropdown.
@booter654
2 жыл бұрын
In the same boat, right now. What's the workaround?
@kumnegerholdings
Жыл бұрын
Thanks a lit Shane. This was helpful. Question: Is there a workaround for Distinct to resolve the delegation issue? I have a large set of data in SharePoint that I need to grab distinct values for. Thanks
@ShanesCows
Жыл бұрын
There is not. Sorry
@DavidAdediran
Жыл бұрын
90% of the time we don't need distinct. Usually a column that is used to filter the rest of the data set should be a Choice or LookUp field. In any case, Choices(DataSource.Column) should give you all the options for your dropdown. For other filter situations like Age, Salary etc. a range can be used instead.
@m0zeh
Жыл бұрын
Distinct(Choices is delegable. Not documented by Microsoft yet!
@DataisKing
Жыл бұрын
Hey Shane, I'm trying to display a column in a collection that shows a count of the number of occurances that an item appears in another column in the collection. Fruit Number of Occurances Apple 1 Orange 1 Lemon 1 Apple 2 Orange 2 How can I created this column?
@ShanesCows
Жыл бұрын
Use the GroupBy function. kzitem.info/news/bejne/rnqer56DaWqmYKw
@rodcris304
3 жыл бұрын
Nice, thank you sir
@ShanesCows
3 жыл бұрын
Most welcome
@TheToni2123
3 жыл бұрын
thx for QTT. I love ist👍
@ShanesCows
3 жыл бұрын
Thank you for the feedback. 😀
@TracyOsimowicz
Жыл бұрын
Great video. But do you know a workaround for Distinct if I need to get the unique values from 3000+ row data source?
@ShanesCows
Жыл бұрын
Not that I know of 😔
@m0zeh
Жыл бұрын
This formula works for me Clients = Distinct(Choices([@'New Proposals'].Customer),Value); Customer is a lookup column in a SharePoint List called new proposals. I get > 2000 items
@kb1902
2 жыл бұрын
Thanks Shane, super useful. I was trying for a while to find the right solution & 'All' works. I'm stuck with using distinction plus a 'search box'. Any ideas on how I can combine it?
@mtamitolanga
Жыл бұрын
Thank you for the video Shane. In my case I have a dropdown pulling data from a sharepoint list "Business Event Lookup" with columns Title, IsActive (Yes/No), SortOrder (number). This formula is not pulling the data, what could be wrong? Sort(Distinct('Business Event Lookup',Title && IsActive = true ), SortOrder) . Thanks
@ShanesCows
Жыл бұрын
Distinct isn't to filter. So you should have Distinct(filter(logic for IsActive), ColumnToDistinctON)
@mtamitolanga
Жыл бұрын
@@ShanesCows thank you that work 👍🏾
@gerfer6261
3 жыл бұрын
Santa is coming to town👍
@ShanesCows
3 жыл бұрын
🎅 🎄
@masgitz
3 жыл бұрын
Shane if you filter to reduce gallery down below 500, if your results include items from row 10,000 for example will a non delegable function work correctly with the filtered results? 🤔
@ShanesCows
3 жыл бұрын
Yes, you are thinking the right way. Do some testing but you are on the right track.
@bethmahoney3069
2 жыл бұрын
Great Video - I have learned tons from watching all your videos! I'm wondering if there is a viable alternative for using the Distinct function. The Distinct function is causing me a ton of grief as I have other galleries that source a gallery using Distinct and I am not able to source the other columns. But I absolutely have to have the functionality that the Distinct provides. Any advice would be greatly appreciated. Thanks so much.
@altino91255268
3 жыл бұрын
Hi Shane, Could you make a video teaching how to access gallery items with forAll?
@ShanesCows
3 жыл бұрын
I think this video will help kzitem.info/news/bejne/ka6QmpqDg5R9qaA
@altino91255268
3 жыл бұрын
@@ShanesCows Thanks Shane!
@sarahtaafe1335
3 жыл бұрын
Shane, Thank you for your videos - they are very helpful. I am working with a SharePoint list that have columns that have data type that are choices or a lookup column. I am having trouble getting any formula to work. Is this because the data type of my columns are not strictly text
@leonelbraga5427
3 жыл бұрын
Dear Shane! I have a 50000 itens sharepoint list. How can i use distinct with this amount of data?
@sashaholladay6310
3 жыл бұрын
How can I sort by one column, yet only see the distinct of another. I have a column for Month and Year which is user freindly, but to sort them correctly I have an identifier that shows the numeric YYYYMM. I want a drop down that shows it like April (2020), but I want it sorted by 202004.
@bearchronicles008
3 жыл бұрын
Hi would you create a tutorial on how to modify my Power App to display my list as a horizontal list. I would like my list to include a calculated field. This field will be based on the values of a specific field. For example, IF [DocType] = 'Agenda' then count total number of 'agenda' divided by total number of unique 'Projects'. The goal is to determine the % of Projects using Agendas considering every Project should have only one agenda document upload to SharePoint Online. The resulting view should have a list of DocTypes with a % value.
@ShanesCows
3 жыл бұрын
I will have to think about this. One tip Sum function will let you calculate the column you want :)
@rivernet62
3 жыл бұрын
Shane, I'm using a OneDrive excel spreadsheet and am not seeing any of the delegation features you show with SharePoint lists. There's no double underlines, no yellow exclamation points, just... failure :( I am trying to filter by date, use Last(), etc, but the only way I can get more than 500 records is to increase the Advanced option. I'm guessing Excel doesn't support any delegation at all? Do you have tips for this situation?
@ShanesCows
3 жыл бұрын
Correct Mark. Best advice? Do not use Excel as a datasource. SharePoint is a better datasource. I need to do a video about this.
@rivernet62
3 жыл бұрын
@@ShanesCows I was afraid you’d say that :(. Thank you muchly for your work & happy new year!
@vishaljhaveri7565
Жыл бұрын
I wanted a dropdown having all the distinct values from a specific column in SharePoint List. Number of records are 40k+ more added each day. Can you just let me know how can I show distinct values without any delegation issue? @Shane Young
@ShanesCows
Жыл бұрын
Not possible, sorry.
@vishaljhaveri7565
Жыл бұрын
@@ShanesCows Thanks for replying man.
@DavidAdediran
Жыл бұрын
@@vishaljhaveri7565 What is the Column type? And can users add any value to it or must they choose from a predefined set of values?
@murthyariga4689
2 жыл бұрын
@Shane Young, thanks a lot your videos, they helps me to learn new things every day. I needed small help. How can I achieve this for multiple drop downs. I am using the below for single drop down and it is working fine. But, I would like to work on multiple drop downs, how can I achieve it ? please help me. "For Drop Down" Ungroup( Table( {Mytables: Table({Result: "All"})}, {Mytables: SortByColumns(Distinct(Channels_Asset_List_Mobiles,Owner),"Result")} ), "Mytables" ) "For the Data Gallery" If(Dropdown1.Selected.Result = "All", Channels_Asset_List_Mobiles, Filter(Channels_Asset_List_Mobiles, Owner = Dropdown1.Selected.Result))
@ShanesCows
2 жыл бұрын
If(Dropdown1.Selected.Result = "All" And Dropdown2.Selected.Result = "Chewy" , ... the key is you can do And to check two conditions in the If or the Filter
@mrnimbus2556
10 ай бұрын
Its not working
@edvardpotapenko
2 жыл бұрын
No delegation renders it completely useless, I'm sick and tired of this Microsoft products that don't work after some count threshold.
@RLycas
2 жыл бұрын
Hello, nice video indeed but may ask a thing? why distinct or filter never works for me? ^__^""" I have a sp list with users, mail,car names, car license plates etc etc, I need a drop down box that shows to the user only the car assigned to him so for example is something like Filter(SPListCars, CarUserColumn = Office365Users.MyProfile().Mail) where CarUserColumn in the sp list is a mail this doesn't works an doesn't works neither Filter(SPListCars, CarUserColumn in Office365Users.MyProfile().Mail) . Furthermore to select the place where the car is I've used Distinct(SPListCars, place) and place is a single text field, it shows nothing... low code hell no! I'm going crazy to perform the most simple data query
@ShanesCows
2 жыл бұрын
Diego here is a video I did on filtering based on the logged in user. kzitem.info/news/bejne/joyXp3iKjYKKoJw Is CarUserColumn a People column in SharePoint? Then the syntax would be Filter(SPListCars, CarUserColumn.Email = User().Email)
Пікірлер: 88