Hi @v-bofeng-msft
Thanks for code but i am having hard time to use it with my exiting gallery item property code can you help please, here is my
Sort(
AddColumns(
GroupBy(
AddColumns(
If(
FilterGalStatus_2.Selected.Value <> "All" && !IsBlank(searchQuery1),/*Case1*/
Filter(
colChecks,
Status.Value = FilterGalStatus_2.Selected.Value || searchQuery1 in amount || searchQuery1 in Invoice_x0020_Number || searchQuery1 in Date_x0020_due || searchQuery1 in Business_x0020_Name || searchQuery1 in Month_x0020_and_x0020_Year
),
FilterGalStatus_2.Selected.Value = "All" && !IsBlank(searchQuery1),/*Case2*/
Filter(
colChecks,
searchQuery1 in Status.Value || searchQuery1 in Invoice_x0020_Number || searchQuery1 in amount || searchQuery1 in Business_x0020_Name || searchQuery1 in Month_x0020_and_x0020_Year
),
FilterGalStatus_2.Selected.Value = "All" && IsBlank(searchQuery1),/*Case3*/
colChecks,
FilterGalStatus_2.Selected.Value <> "All" && IsBlank(searchQuery1),/*Case4*/
Filter(
colChecks,
FilterGalStatus_2.Selected.Value
)
),
"Comppanyvalue",
Business_x0020_Name
),
"Comppanyvalue",
"NewGroup"
),
"Status",
First(
Sort(
NewGroup,
Status.Value,
Descending
)
).Status.Value,
"Comments",
First(
Sort(
NewGroup,
Note,
Descending
)
).note,
"Modified",
First(
Sort(
NewGroup,
Modified,
Descending
)
).Modified,
"PhoneNum",
First(
Sort(
NewGroup,
Title,
Descending
).Title
),
"Collect",
First(
Sort(
NewGroup,
Month_x0020_and_x0020_Year,
Descending
).Month_x0020_and_x0020_Year
),
"CHECKDUE",
First(
Sort(
NewGroup,
Date_x0020_due,
Descending
)
).Date_x0020_due,
"Pending Invoices",
CountRows(NewGroup),
"Invoice",
First(
Sort(
NewGroup,
Invoice_x0020_Number,
Descending
)
).Invoice_x0020_Number,
"TotalBalance",
Sum(
NewGroup,
amount
),
"SumShippingFee",
Sum(
NewGroup,
amount
),
"InvoiceCreated",
First(
Sort(
NewGroup,
Created,
Descending
)
).Created
),
CHECKDUE,
Descending
)
