Share
ReportHi,
I have "My TI Number" List in SharePoint, In that I have "MyNumber" Text column and I customized with PowerApps and generated sequence number using below code.
But In SharePoint List, It is displaying like below format if I apply sorting Ascending and Descending in "MyNumber" column
How to achieve correct way in ascending and descending also, In My code any problem?. Please suggest.
Or else,
Please provide change in the below code to generate Highest to Lowest
If(SharePointForm1.Mode=FormMode.New,
"TI-"&First(Sort(AddColumns('MY TI Number List',"NewCol",
Trim(Substitute(MyNumber,"TI-",""))*1),NewCol, Descending)).NewCol+1,Parent.Default)
As of now it is displaying,
TI-1
TI-2
TI-3
TI-4
Need to change in above formula to Generate like below(Highest to Lowest)
TI-4
TI-3
TI-2
TI-1
Thanks
All responses (
Answers (
354
