Combining Filter, group by and Concatenate in Gallery

[vaika160]

It seems like it should be simple but I cannot figure this out.
Filter RequestDate >= today()

I have a table. this table has other fields.

RequestDate   Name    Office     Field 1   Field2 ...

2021/04/22    Name1   Office1
2021/04/23      Name2   Office2

2021/04/22      Name3   Office1

2021/04/23      Name4  Office1

What I need to accomplish:

RequestDate    Name                       Office
2021/04/22     Name1 , Name3        Office1
2021/04/23     Name4                     Office1
2021/04/23     Name2                   Office2

Not sure how to do it for these fields only?
Thanks!

[WarrenBelz · Accepted solution]

Hi @vaika160 ,

The syntax is valid - I just ran it on a collection off a list here and it worked perfectly.

Check your column names are actually what you believe - go to SharePoint List Settings, select the field name and then look at the end of the string at the top.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[vaika160]

Hi @WarrenBelz ,

I have checked the names of the List and I think the problem is with column Office as it is a Choice column. At least, I hope that this is the case.

Thanks a lot for your help.

[WarrenBelz]

Hi @vaika160 ,

If Office is a Choice column, you need this

ClearCollect(  
   colReservationDay,
   AddColumns( 
      GroupBy( 
         AddColumns(
            colReservations, 
            "Office1",
            Office.Value
         ),
         "DateRequested", 
         "Office1",
         "OtherData"
      ),
      "EmployeeName", 
      Concat( 
         OtherData,
         Employee.DisplayName & "," 
      )
   )
)

[vaika160]

It works!!!

Thank you!

[Mayur-Aress]

Hi all,

I was working on a project which is based on SharePoint list and power apps, In that I want to add sub tasks against a project. I have 3 lists Project Request, Project Details and Sub Task. 

I want to store tasks related to the project in the Sub Task list for that I created one canvas application.

But when I try to combine project details and sub task in power apps, I was not able to display the records of selected project

When I click on the highlighted icon in the above image, it will navigate to the task's screen

The task screen look's like above image.

But I want to display the tasks which is allocated to perticular Project and that task will assign to that project with project ID.

First screeenshot is of Project Details list

Second is of Sub Task list

Please help me for this