Hi @eka24
THIS THE MAIN GALLERY WHICH RESTARTING
Search(
AddColumns(
GroupBy(
AddColumns(
'Shipments ',
"CompanyText",
Company.Value
),
"CompanyText",
"ShipmentsByCustomer"
),
"Status",
First(Sort(ShipmentsByCustomer, Status.Value, Ascending)).Status.Value, // Modify formula here
"IDS",
First(Sort(ShipmentsByCustomer, ID, Ascending)).ID, // Modify formula here
"OrderDatesFull",
First(Sort(ShipmentsByCustomer, OrderDate, Ascending)).OrderDate, // Modify formula here
"CODFull",
Sum(
ShipmentsByCustomer,
CodAmount
),
"TotalShipmentFee",
Sum(ShipmentsByCustomer, ShippingFee),
"Company",
Descending
),
TextSearchBox1.Text,
"CompanyText"
)
AND THIS THE OTHER GALLERY
Filter('Shipments ', Company.Value = Galleryship.Selected.CompanyText)
Thanks