cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,646)