Power Platform Community Forum Thread Details

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