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!