Experts ,
I am trying to bring auto incremental serial numbers against the collection row, Following code is applied.
If(
Connection.Connected,
Collect(
test1,
Getlogo.Run(
LookUp(
Dailyusers,
email = User().Email,
route
)
)
);
LoadData(
test1,
"MyLocalData",
true
);
SaveData(
test1,
"MyLocalData"
);
---------------------------
ClearCollect(
test2,
{
priority: "",
state: " ",
sequence: "",
shortText: "",
orderNumber: "",
breakdownSymptomCode: "",
breakdownSymptomGroupCode: "",
customerCode: "",
equipmentCode: "",
orderDate: "",
adviceText: "",
center: "",
syncType: "",
routeId: "",
activityClass: "",
serviceType: "",
orderClass: "",
orderstatus: ""
}
);
LoadData(
test2,
"MyLocalData"
);
Gallery --- Items
GroupBy(test2,"orderNumber","customerCode","activityClass","orderstatus")
Inside Gallery : ThisItem.orderNumber
Inside Gallery : ThisItem.customerCode
Inside Gallery : ThisItem.orderstatus
Inside Gallery : Autoincremental Number : ThisItem.orderNumber+1
Gallery view
Below is the result, in which serial no is incorrect,
expected result ,
How to achieve this.
User | Count |
---|---|
257 | |
110 | |
97 | |
52 | |
39 |