Get Nth Item from the result of Split function

(0) Share

Report

Posted on by pNabin

249

Hi,

I have to get the 5th & 6th item splitted by '/' in an URL (like : "https://hello.com/sites/customer/portal/details") which is customer & portal.
I have used the split function and stored it in collection with one Column (Result).

ClearCollect(colSplittedURL,Split(TextInputURL.Text,"/"))

How can I get Nth (5th & 6th) item from collection colSplittedURL?

I know First(colSplittedURL) gives the first item and Last(colSplittedURL) gives the last item of the collection but I don't know how to get soemthing in the middle.

Thanks,

Nabin

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

CarlosFigueira Microsoft Employee on at

Like (15)

Report
Copy link

Link copied!
You can use a combination of the FirstN and Last functions to access an item at a specific index. To get the 5th element from your collection you'd use

Last(FirstN(colSplittedUrl, 5))

And similarly for the 6th element:

Last(FirstN(colSplittedUrl, 6))

Hope this helps!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

"Sameer : CKayako : Shaikh : Manish Aggarwal :"
Is it possible to split in any suggestion
Sameer
CKayako
Shaikh
Manish Aggarwal
Separately in different 4 Text-input Box

Was this reply helpful? Yes No
pNabin 249 on at

Like (1)

Report
Copy link

Link copied!
@Anonymous Could you try:
Split(StringToSplit,":")
And you can remove the last item as it is empty because of ":" at the end.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@pNabin
Thanks for Help.
but it still shows this error.

Was this reply helpful? Yes No
liridonuka 46 on at

Like (0)

Report
Copy link

Link copied!

Try:
First(Split(Label58_1.Text,":")).Value or Last(Split(Label58_1.Text,":")).Value
as it expects text value

Was this reply helpful? Yes No
IvoYanWL 8 on at

Like (0)

Report
Copy link

Link copied!

Now there's the Index function:
Index(Split(myString, delimiter), 1) - returns a row/record at index 1;
Index(Split(myString, delimiter), 1).Value - returns the value/substring of the row/record at index 1;

Was this reply helpful? Yes No