Virtual Incremental Column no - Canvas Ap

[AVTS]

Team,

I have the formula with groupby concept. In this i would like to add virtual incremental number instea of from table,

Below is my codings,

Test1.Run(User().Email,
JSON(With( {TheTable:
Filter(ShowColumns(Dailyinventory,"crf99_sno","crf99_materialdesc","crf99_materialno","createdon","crf99_bbd","crf99_qty"),DateDiff(createdon, Today(),Days) =0)},
ShowColumns(AddColumns(GroupBy(TheTable,"crf99_materialdesc","NewGroup"),
"Materialno",First(NewGroup).crf99_materialno,
"Qty",Sum(NewGroup,crf99_qty),

"Created On",Last(NewGroup).createdon,
"bbd",Last(NewGroup).crf99_bbd,
"Sap-Stock",LookUp(sapstock,material=First(NewGroup).crf99_materialno ,unrestrictedStock)),

"Created On","bbd","crf99_materialdesc","Materialno","Qty","Sap-Stock"))))

Below is my current result,

Exepect result, Show virtual column  in first row "Sno"

[CNT · Accepted solution]

@AVTS Try this,

Test1.Run(User().Email, 
  JSON(With(
      {TheTable: 
	    ShowColumns(
			AddColumns(
			  GroupBy(
				Filter(
					ShowColumns(
					  Dailyinventory, "crf99_sno", "crf99_materialdesc", 
					  "crf99_materialno", "createdon", 
					  "crf99_bbd", "crf99_qty"
					), 
					DateDiff(createdon,Today(),Days) = 0
				), "crf99_materialdesc", "NewGroup"
			  ), 
			  "Materialno", 
			  First(NewGroup).crf99_materialno, 
			  "Qty", 
			  Sum(NewGroup, crf99_qty), 
			  "Created On", 
			  Last(NewGroup).createdon, 
			  "bbd", 
			  Last(NewGroup).crf99_bbd, 
			  "Sap-Stock", 
			  LookUp(
				sapstock, 
				material = First(NewGroup).crf99_materialno, 
				unrestrictedStock
			  )
			), 
			"Created On", 
			"bbd", 
			"crf99_materialdesc", 
			"Materialno", 
			"Qty", 
			"Sap-Stock"
		)
	  },
	  ForAll(Sequence(CountRows(TheTable)), 
		Patch(Last(FirstN(TheTable, Value)),{Sno : Value}))
    )
  )
)

[CNT]

@AVTS Hope the solution worked!

Please remember to give a 👍 and accept the solution as it will help others in the future.

[AVTS]

Yes . It worked. Thank you .

[CNT]

@AVTS Glad to help!

Please remember to give a 👍 and accept the solution as it will help others in the future.