Virtual Incremental Column no - Canvas Ap

(0) Share

Report

Posted on by AVTS

538

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"

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AVTS Hope the solution worked!

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

Like
a
(0)

Report
Copy link

Link copied!

Yes . It worked. Thank you .
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AVTS Glad to help!

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