I need a little help nesting these two gallery items formulas. I'm still working on familiarizing myself with the syntax...
If(Toggle1.Value, Filter('Engagement Form', 'Created By'.DisplayName = gvCurrentUserName), 'Engagement Form')
SortByColumns(Filter('Engagement Form', StartsWith(Activity_Name, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))
Thanks in advance!
-Jake
You've done it again, thanks Jeff!
-Jake
I think this might be what you are looking for:
SortByColumns( Filter( If(Toggle1.Value, Filter('Engagement Form', 'Created By'.DisplayName = gvCurrentUserName), 'Engagement Form'), StartsWith(Activity_Name, TextSearchBox1.Text) ), "Title", If(SortDescending1, Descending, Ascending) )