Power Automate

Unanswered

Re-arrange the data by Alphabetical

(0) Share

Report

Posted on by ilu989

164

Hi Everyone,

I have Original data string as below, is it possible to re-arrange(ascending) and accord to the specific item?

The specific @item()[11] is my target ascending item, the final data after ascending will become as After ascending.

Original data:

[

"ABC",

"KS",

"DND",

"",

"CE",

43117,

43152,

"CL",

"T124",

"CLi",

"CV",

364139,

364139,

"6D",

"",

"CK",

"",

43312,

"CJ"

[

"RK",

"GCE",

"DOD",

"",

"CE",

43267,

43203,

"POL",

"W123",

"CKOn",

"CMV",

345139,

364139,

"I453K",

"",

"1CPKS",

"",

43770,

"DIEKNSI"

[

"RNK",

"KKMA",

"OUPDA",

"",

"AE",

43667,

43603,

"CPO",

"ISOM",

"LOIN",

"CVOPNS",

404139,

364139,

"6M",

"",

"21",

"",

43670,

"LOJN"

]

After ascending:

[

"RK",

"GCE",

"DOD",

"",

"CE",

43267,

43203,

"POL",

"W123",

"CKOn",

"CMV",

345139,

364139,

"I453K",

"",

"1CPKS",

"",

43770,

"DIEKNSI"

[

"ABC",

"KS",

"DND",

"",

"CE",

43117,

43152,

"CL",

"T124",

"CLi",

"CV",

364139,

364139,

"6D",

"",

"CK",

"",

43312,

"CJ"

[

"RNK",

"KKMA",

"OUPDA",

"",

"AE",

43667,

43603,

"CPO",

"ISOM",

"LOIN",

"CVOPNS",

404139,

364139,

"6M",

"",

"21",

"",

43670,

"LOJN"

]

Regards,

ilu989

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ilu989 ,

You may need to sort the numbers first, and then sort the array elements. Currently, Flow has no direct action to achieve this requirement.

Best Regards,

Was this reply helpful? Yes No
ilu989 164 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bacao-msft ,

Thanks for your tips, I found Liu's Blog might help on this:
http://johnliu.net/blog/2018/12/how-to-implement-sort-with-microsoft-flow-in-3-actions-within-a-loop
But, my situation is the numbers are not unique, sometimes have the repeat number display in different elements, so Liu method can't suite in my case, do you have a more specify method can teach me? Thank you very much.

Regards,
ilu989

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ilu989 ,

If number is not unique, I'm afraid it's impossible to sort. Because we need it as a key column to sort and extract the elements contained in the array.

Best Regards,

Was this reply helpful? Yes No