Unanswered

Left function throws error - Second argument invalid

(0) Share

Report

Posted on by Iantaylor2050

531

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Chris-D 1,246 on at

Like (0)

Report
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) ) )

Was this reply helpful? Yes No
RodCha 216 on at

Like (0)

Report

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.

Was this reply helpful? Yes No