Unanswered

Left function throws error - Second argument invalid

(0) Share

Report

Posted on by Iantaylor2050

593

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
Copy link

Link copied!
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
Copy link

Link copied!

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