Unanswered

Syntax for button that displays hidden records

(0) Share

Report

Posted on by alygator Microsoft Employee

Hello, I am building an app that a gallery of records, some of which will be hidden depending on a value in a column in a Sharepoint list. That part is working great (please see below and image attached), however I need to add on functionality that will enable the user to unhide any hidden records by clicking a button, and to have the button toggle off/on if the user clicks again and again. Could you help me get the syntax? Thank you so much

SortByColumns(
Filter(mydatasource,
StartsWith(Title, TextSearchBox1.Text) &&
MatchStatus.Value = "Available"
),
"DATA",
If(SortDescending1, Ascending, Descending)
)

Categories:

Building Power Apps

powerapp_q_01.png

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @alygator ,

On your button put

UpdateContext({varShow:!varShow})

then your Filter

SortByColumns( Filter( mydatasource, StartsWith( Title, TextSearchBox1.Text ) && (varShow || MatchStatus.Value = "Available") ), "DATA", If( SortDescending1, Ascending, Descending ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
alygator Microsoft Employee on at

Like (0)

Report
Thank you Warren, it looks like I need to tweak something - could you be so kind as to take a look? I attached screenshots.
I added the following to Button_View_all and changed "AutoDisableOnSelect" to "false" so the user could toggle the button.
UpdateContext({varShow:!varShow})

I also added the following to BrowseGallery1, however the message is "There is an error in this formula."
SortByColumns(Filter([@'M365 Executive Engagement Tracker'], StartsWith(Title, TextSearchBox1.Text) && (varShow || MatchStatus.Value = "Available")), "DATA", If(SortDescending1, Descending, Ascending)

view_all_button2.png

powerapp_q_02.png

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report
Hi @alygator ,

You are missing a closing bracket, but if this is not the issue, try it the "long" way

SortByColumns( Filter( [@'M365 Executive Engagement Tracker'], StartsWith(Title,TextSearchBox1.Text) && If( varShow, true, MatchStatus.Value = "Available" ) ), "DATA", If( SortDescending1, Descending, Ascending ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
alygator Microsoft Employee on at

Like (0)

Report

Thank you Warren! It works nicely (with the change of "DATA" to "Title"). Very cool

Was this reply helpful? Yes No