I have a drop down in my power apps and the items are the months column from SharePoint. How do I sort the month record chronologically?
Right now, what I did is:
Sort(Distinct(Filter('SP LIST', Dept = varDept, Year = RecordedYear.Selected.Result), Month),Result,Descending)
But it sort the month alphabetically like this:
Any idea for this?
Solved! Go to Solution.
Thank you everyone!
I have tried @PowerAddict suggestions but I got the attached warning. I am not sure whether I write it wrongly or what. I filter the sharepoint list and then after that I filter the collections.
For now, the solution I wanted is from @Eelman . I understand that date column will be very helpful but in my case, I do not require exact date so that is why I did not put date column.
Thank you for your help. Have a nice day ahead!
Hi @PowerAddict ,
Yeah I encounter that warning before but I am still not sure what it is. Your post really help me to understand! However, I have 2 questions,
1. To confirm, does this means that if you set the limit to 10, they will only search up until 10 data for that particular column is it?
For example, I have a record of year 2020 and the recorded months are Jan-Dec. However, Since the limit is 10, I can only see up until Oct, is it?
2. Is the limit set is applicable for each column or the sum of all records that I have? I have record of year from 2000-2020. When I set the limit to 10, am I able to find the record for 2020 and retrieve the months?
Okay, now I understand. So since I only want to search for months (which the max it would be 12), I think it is okay for me to use this method. But I will reconsider this for other things that might have a lot of records. Thanks!!
Nice article mate, thanks for the share. I rarely, if ever, use Search() but gave it a try on my test SP List and straight up got a delegation warning on a simple text field. Search mustn't work for SP?
I will keep the AddColumns tip in mind though. Thanks!
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.