Index function error on app launch

(0) Share

Report

Posted on by Poweruser32490

126

Get below error on app launch despite adding IsBlankorError function. May i know why?

The ThisItem.Department is a hyperlink column in sharepoint which contains URL like https://Finance. I want to extract keyword Finance here.

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

HTML Text as a tooltip

"<table style='width:100%; border: 1px solid #D6DDE0; border-collapse: collapse;'>
<tr style='background-color:#1D4674;'>
<th style='border: 1px #solid #D6DDE0;color: white;font-size:11px;font-weight:bold; padding: 4px;'>Group</th>
<th style='border: 1px solid #D6DDE0;color: white;font-size:11px;font-weight:bold;  padding: 4px;'>Status</th>
</tr><tr>
<tr><td style='border: 1px solid #D6DDE0; padding: 4px;font-size:11px;'> Department</td>
<td style='border: 1px solid #D6DDE0; padding: 4px;font-size:11px;'>" & If(
        !IsBlankOrError(ThisItem.Department),
        Index(
            Split(
                ThisItem.Department,
                "http://"
            ),
            2
        ).Value,
        "N/A"
    ) & "</td></tr>

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

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

Like
a
(0)

Report
Copy link

Link copied!

@Poweruser32490,

You’re getting that error because Index(Split(...), 2) is being evaluated in cases where Split() returns only one row — so the only valid index is 1, not 2.

New Power Fx

"<table style='width:100%; border: 1px solid #D6DDE0; border-collapse: collapse;'>

<tr style='background-color:#1D4674;'>

<th style='border: 1px solid #D6DDE0;color: white;font-size:11px;font-weight:bold; padding: 4px;'>Group</th>

<th style='border: 1px solid #D6DDE0;color: white;font-size:11px;font-weight:bold; padding: 4px;'>Status</th>

</tr>

<tr>

<td style='border: 1px solid #D6DDE0; padding: 4px;font-size:11px;'>Department</td>

<td style='border: 1px solid #D6DDE0; padding: 4px;font-size:11px;'>" &

With(

    { depurl: Coalesce(ThisItem.Department.Url, ThisItem.Department.Value, ThisItem.Department) },

    With(

        { hostPart: First(Split( Substitute(Substitute(depurl, "https://", ""), "http://", ""), "/" )).Value },

        If(IsBlank(hostPart), "N/A", hostPart)

    )

) &

"</td>

</tr>

</table>"

also there is a similar post suggestions have provided if its resolves your issue kindly mark as verified

https://community.powerplatform.com/forums/thread/details/?threadid=e388e387-dc15-f111-8341-0022482aa0e7

✅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!

@Poweruser32490,

As @MS.Ragavendar has noted, this is a duplicate of this thread, where we both have responded. Can you please continue there or mark the appropriate response if it is solved.

Was this reply helpful? Yes No
MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Poweruser32490,

A quick follow-up to see, does the suggestion worked for you or still you were looking for any other approaches or assistance.

✅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