Hi, and thank you for your expertise!
I have a filter that works, that includes the dropdown filters, search bar, and a reset filters button called bbAll (All Technology Resources). Again, that all works the way I want, and those functions are as such:
RecordsGallery1:
Filter(
'Academic Technology Resources',
(IsBlank(ddSkill.Selected.Value) || ddSkill.Selected.Value in Skill.Value) &&
(IsBlank(ddType.Selected.Value) || ddType.Selected.Value in Type.Value) &&
(IsBlank(ddUser.Selected.Value) || ddUser.Selected.Value in 'End User'.Value) &&
(IsBlank(SearchInput1.Text) || SearchInput1.Text in 'Resource')
)
bbAll:
// Define default filter values
Set(varDefaultFilters, {
Skill: Blank(),
'End User': Blank(),
Type: Blank()
});
// Reset all of the filter controls
Reset(ddSkill);
Reset(ddUser);
Reset(ddType);
Refresh('Academic Technology Resources');
Reset(SearchInput1)
Here's my problem... I got the bbUnder button that works as a stand-alone filter for RecordsGallery1, but I need them all to work together. I'm able to put the variable FilterUnder in RecordsGallery1 and when I press the bbUnder button, it works, but again, I need them all to work together, including the bbAll "reset" feature to get the user back to the default view.
bbUnder:
UpdateContext({FilterUnder:Filter('Academic Technology Resources','Status'.Value="Under Review")})
RecordsGallery1
bbAll
bbUnder
