Unanswered

how to .. pending.. approved.. send.. sort.. button?? how to in the gallery.. thx

(0) Share

Report

Posted on by bbsin

1,994

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.

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Gallery code:
SortByColums(Filter(list', 'Created By'.Email=User().Email),varSort,
If(
SortDescending1,
Descending,
Ascending
)
)
On your button's OnClick Event:
UpdateContext({varSort :"ColumName"});
UpdateContext({SortDescending1:!SortDescending1});

That way if it's in ascending it will be set to descending and vice versa.
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @zmansuri

Thanks , but did I missed something???
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

@zmansuri

Not too sure .. I just want to sort by ID. will it work??
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

SortByColums(Filter(list', 'Created By'.Email=User().Email),ID,Ascending)
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

@zmansuri

Thanks but it's not working
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

@zmansuri

Did I miss something??

The status column choice are

Thanks