cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Proper Syntax for Filtering and Grouping a Stretch Height Gallery

Hi All,

 

I would like to filter my GroupBy function.

 

Capture 1.png

 

The Gallery I am working in is Labeled: Time Sheets

 

This is my GroupBy function:

GroupBy('Time Sheets',"First_x0020_and_x0020_Last_x0020","StaffData")

This is the Filter Funtion I want nested:

Filter(StaffData, DateFilterStart <= Start_x0020_Time, DateFilterEnd >= End_x0020_Time)

How can I combine these in one string under the Items formula? Do I need to use an if function or can they just be nested? If so I would really appriciate some help with the syntax.

 

 

 

Thanks for your help!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: Proper Syntax for Filtering and Grouping a Stretch Height Gallery

I managed to solve this one:

 

GroupBy(
    (Filter('Time Sheets', DateFilterStart <= Start_x0020_Time, DateFilterEnd >= End_x0020_Time))    
    ,"First_x0020_and_x0020_Last_x0020","StaffData")

View solution in original post

1 REPLY 1
Highlighted
Anonymous
Not applicable

Re: Proper Syntax for Filtering and Grouping a Stretch Height Gallery

I managed to solve this one:

 

GroupBy(
    (Filter('Time Sheets', DateFilterStart <= Start_x0020_Time, DateFilterEnd >= End_x0020_Time))    
    ,"First_x0020_and_x0020_Last_x0020","StaffData")

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,824)