Sort/Group List by string values

Lists-Logic
1

Hi Forum

I am looking to sort/group the list in the GetItemAtIndex list into a sublist by the UniqueItems list - please see attached.

I am hoping to get the following solution:

0
LT-CM-1
LT-CM-2
1
FN-CSB-1
FN-CSB-2
2
SW-BN-1
SW-BN-2

I have tried string.Contains but cannot get my head around the logic to achieve this.
Any help would be greatly appreciated.
Many thanks

grouping%20question
grouping question.JPG1331×814 151 KB

2

If your index is always 1 item long you can do something like this:

image
image.png897×412 30 KB

3

Hi Jonathan

Many thanks for this! I was looking at the GroupByKey. Sadly the last value will increase to 2 or more. Any thoughts?

Thank you very much again.

Regards
Tim

4

Sorry, 2 or more digits at the end I mean.

5

Hi Jonathan

Using your approach I think I have got it. See attached, using the string length and GroupByKey seems to have done it.

Many thanks again for your help.
Tim

grouping%20question2
grouping question2.JPG1399×872 169 KB

6

Perhaps this helps?

Capture
Capture.png1996×522 52.4 KB

7

Hi 3Pinter

This works a treat! Thank you so much. Just followed it below.

grouping%20question3
grouping question3.JPG1493×732 152 KB

Thank you again for everyone’s help.

Cheers
Tim

9

Hi erfajo

This is brilliant, very nice, thank you.

grouping%20question4
grouping question4.JPG1468×842 161 KB

Thank you for the excellent solutions.
Cheers
Tim

11

Thanks again erfajo. This looks great - wish I was at Python level, but still at OOTB!

Thanks again
Tim