Adding a Filter to a Groupby for a Gallery
Hi
Hopefully I've understood this request, my suggestion: Filter the results before grouping
GroupBy(
AddColumns(
Filter( Grants, user = current user ),
ProjectText,Project.Value),
ProjectText,Data)
Alternatively, Filter the Resulting group
Filter(
GroupBy(AddColumns(Grants,ProjectText,Project.Value),ProjectText,Data),
user = current user).
Depending on the layout / Home screen you could also add a "Show My Tasks" Button / Toggle and add a IF to the filter
Something along the lines of
If "My Tasks" equal true
then Filter & Groupby xyz
else GroupBy xyz.
Hope that helps
