Index function error

(2) Share

Report

Posted on by Poweruser32490

126

I receive an error while launching the app. The error is related to Index function.

The second argument to the 'Index' function must be between 1 and 2, the lower and upper bounds of the table. The upper bound may be reduced due to the non-delegation limit

Here the department is a hyperlink column with values like http://abc.com. May i know what is the issue here?

Gallery Label Text Property

!IsBlankOrError(ThisItem.Department),
    Index(
        Split(
            ThisItem.Department,
            "http://"
        ),
        2
    ).Value,"N/A"
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Poweruser32490,

Firstly, you are missing the If() argument off the front - this works fine for me on a test list
If( !IsBlankOrError(ThisItem.Department), Index( Split( ThisItem.Department, "http://" ), 2 ).Value, "N/A" )

You could also do this
If( !IsBlankOrError(ThisItem.Department), Right( ThisItem.Department, Len(ThisItem.Department) - 7 ), "N/A" )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Poweruser32490, You are getting that Index out-of-bounds error because the Split() is not always returning 2 rows.

With(

    { url: ThisItem.Department },

    If(

        IsBlank(url),

        "N/A",

        If(

            StartsWith(url, "https://"),

            Mid(url, 9, Len(url) - 8),

            If(

                StartsWith(url, "http://"),

                Mid(url, 8, Len(url) - 7),

                url

            )

        )

    )

)

In-addition to the @WarrenBelz there might be some cases the URL might come as https as well so extended the code compatible for both versions without split.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

HI @Poweruser32490,

@MS.Ragavendar is correct on the analysis here (if there is no second part of the split in any of the sample data, you are describing an invalid reference)- either use @MS.Ragavendar's solution or the second one I posted.

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Poweruser32490,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No