Power Platform Community Forum Thread Details

I have this bit of code as the text for a label. It gives me a "The third argument to the 'Find' function must be less than or equal to the length of the second argument". I was getting this error until the label was populated. Once it was populated the error went away and I could submit the form. It was functioning for 390 records. Now, I always get the error and can't submit any new records. Any ideas what is happening?

Substitute(
    Left(
        Mid(
            TXT_LinkDestination.Text, 
            Find("/", TXT_LinkDestination.Text, Find("//", TXT_LinkDestination.Text) + 2) + 1, 
            Len(TXT_LinkDestination.Text)
        ), 
        Len(
            Mid(
                TXT_LinkDestination.Text, 
                Find("/", TXT_LinkDestination.Text, Find("//", TXT_LinkDestination.Text) + 2) + 1, 
                Len(TXT_LinkDestination.Text)
            )
        ) - If(
            Right(
                Mid(
                    TXT_LinkDestination.Text, 
                    Find("/", TXT_LinkDestination.Text, Find("//", TXT_LinkDestination.Text) + 2) + 1, 
                    Len(TXT_LinkDestination.Text)
                ), 
                1
            ) = "/", 
            1, 
            0
        )
    ), 
    "/", 
    ":"
)

Categories:

Building Power Apps

Hi futr_vision

Sort of hurts my brain looking at it and the logic seems a bit over complicated, however to answer your question and save a heap of typing

With(
    {
        _Mid: Mid(
            TXT_LinkDestination.Text,
            Find(
                "/",
                TXT_LinkDestination.Text,
                Find(
                    "//",
                    TXT_LinkDestination.Text
                ) + 2
            ) + 1,
            Len(TXT_LinkDestination.Text)
        )
    },
    If(
        Len(TXT_LinkDestination.Text) > 0,
        Substitute(
            Left(
                _Mid,
                Len(_Mid) - If(
                    Right(
                        _Mid,
                        1
                    ) = "/",
                    1,
                    0
                )
            ),
            "/",
            ":"
        ),
        ""
    )
)

Please click 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 giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee