Expert,
I am trying to sort multiple columns, Follows my code,
'PowerApp->Compose'.Run(User().Email,
JSON(
With(
{
TheTable: Filter(
ShowColumns(
Dailyinventory,
"crf99_sno",
"crf99_materialdesc",
"crf99_materialno",
"createdon",
"crf99_bbd",
"crf99_qty",
"crf99_plant"
),LookUp(Dailyinventoryusers,email=User().Email,plant),
DateDiff(
createdon,
Today(),
Days
) = 0
And LookUp(Dailyinventoryusers,email=User().Email,plant) = crf99_plant
)
},
Sort( ShowColumns(
AddColumns(
AddColumns(
TheTable,
"plant",
crf99_plant,
"Materialno",
crf99_materialno,
"Qty",
crf99_qty,
"Created On",
Text(createdon,"[$-en-US]dd/mm/yyyy"),
"bbd",
Text(crf99_bbd,"[$-en-US]dd/mm/yyyy")
),
"Diff",
"Sap-Stock" - Qty,
"Days",
DateDiff( Text(createdon,"[$-en-US]mm/dd/yyyy"), Text(crf99_bbd,"[$-en-US]mm/dd/yyyy") )
),
"Materialno",
"Created On",
"bbd",
"Days",
"crf99_materialdesc",
"Qty"
),
crf99_materialdesc || Days
)
)
)
)
Current result is ,
Expected ,
First it group the crf99_materialdesc and second it sorts the Days
How to achieve this friends,
