I was trying to follow the tutorial listed at: https://powerapps.microsoft.com/en-us/tutorials/function-sort/
However, I was having issues with sorting a specific column by a specific value. Similar to the tutorial, I wanted to sort my listings to only those that would have an "EventDate" equal to Today().
Here is my original code:
SortByColumns(Search(Table2, TextSearchBox1.Text, "EventName", "LastName", "FirstName"), "EventDate", If(SortDescending1, Descending, Ascending))
I would like it to be something like: "EventDate", [Today()] -- Not sure if it's supposed to be ["Today"] I tried both and couldn't get it working.
Thanks for all of your help!
Hi Austinct,
I am glad to hear that you have figured out a solution.
And thanks for sharing it with us.
Anytime you have issues when using PowerApps, please feel free post your issue at here, we are always ready to help.
Best regards,
Mabel Mao
Sorry, I answered my own question. I used filter and it works properly.
The app is for an event check in. So depending on the last name they enter into the search textbox, and if the event is today, it allows them to check in.
If any one needs help, here's the code I used:
Filter(Table2, LastName = TextSearchBox1.Text, EventDate = Today())
Should I try to use Filter instead of SortByColumns?
Thank you!