Left function throws error - Second argument invalid

Like (0) Share

Report

Posted on 22 Nov 2023 11:56:01 by Iantaylor2050

494

I am using powerapps gallery with SharePoint as the backend. I have multiselect people picker column which i am showing in gallery label. Below is the code for the same.

With(
 {
 wString: Concat(
 ThisItem.Team_Members.DisplayName,
 DisplayName & ", "
 )
 },
 Left(
 wString,
 Len(wString) - 2
 )
)

It was working fine for a while. However recently i noticed a weird error in app runtime. May i know what is the issue here?

Categories:

General Questions

All responses (2)

Answers (0)

RodCha 216 on 22 Nov 2023 at 12:18:47

Like (0)

Report

Re: Left function throws error - Second argument invalid

If you are using the 'Formula' in the 'Label' control for your gallery, you can try:

With({name: ThisItem.DisplayName}, name & ", " & Left(name, Len(name) - 2))

But, I'm not sure if this the place that you are trying to use it.
Chris-D 1,246 on 22 Nov 2023 at 12:06:35

Like (0)

Report
Re: Left function throws error - Second argument invalid

This could happen if the second argument was negative. If ThisItem.Team_Members.DisplayName is blank then your second argument will be -2. Looks like you're using a gallery and this can happen before the gallery items have loaded.

Try this:
With( { wString: Concat( ThisItem.Team_Members.DisplayName, DisplayName & ", " ) }, Left( wString, // Use max to ensure value cannot be negative Max( 0, Len(wString) - 2) ) )