I have used above formula but it is not showing any data in it.
ClearCollect(ColMain, Gallery4.Selected.Gallery3.AllItems);
My Gallery4 is the distinct value of EmployeeEmail and in Gallery3 I am showing task details of employee By matching the email value and id. And The purpose of doing this to show the multiple task of one employee for the current week. And I want to export the gallery data into excel for that I need to store gallery data in to a collection. I have tried Multiple solutiion but it is not working. One of the formula is
ClearCollect(collTwo,Ungroup(ForAll(Gallery4.AllItems,ForAll(ThisRecord.Gallery3.AllItems,{EmployeeEmail:Gallery3.Selected.EmployeeEmailLebel,date:Gallery3.Selected.DateLebel,description:Gallery3.Selected.DescriptionLebel,priority:Gallery3.Selected.PriorityLebel,IsImportant:Gallery3.Selected.PriorityLebel,EstimatedHour:Gallery3.Selected.EstimatedhrsLebel,Status:Gallery3.Selected.StatusLebel})),"Value"));
It is showing the table but there is no data in it