Can I know how to set the buttons onto to sort by it's status selected and the gallery to display all item by on the latest not selected or is all?? thx
My gallery item is Filter(list', 'Created By'.Email=User().Email)
it should only display the user who lock in to see their own records . Thanks.
SortByColums(Filter(list', 'Created By'.Email=User().Email),varSort,
On your button's OnClick Event:
That way if it's in ascending it will be set to descending and vice versa.
You have to set values for varSort and SortDescending1 through OnClik on buttons. and if they are choice or any complex type field you can not sort it directly, You have to use AddColumns. in the gallery code.
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.