Best way to remove the semi colon in the expertise column

Good day everyone! Please help me on this, I need to remove the semi colon every time if its the last expertise written in the expertise column (image attached) . The source of the expertise column is the function I created (image attached), I'm thinking of what to use in the assign widget. Thanks in advance!


Solution

Hello John Renz Errol del Mundo,

You can check for the below condition

1. If it is last element then you should not add the colon

If(GetEmployees.List.Length = GetEmployees.List.CurrentRowNumber+1,"",";")

 Kindly refer the below attached document for EOF

Hope this helps!

Regards,

Ellakkiya.S

 

Hi Ellakkiya!

Yes! This one works! Thank you so much, the problem is now solved.

mvp_badge
MVP

Although this works, I think the more sensible test would be to start with the CurrentRowNumber, and compare that to the Length:

If(GetEmployees.List.CurrentRowNumber < GetEmployees.List.Length - 1, ";", "")

Hi John,

You can try to use String_Join action instead of loop and assign value:



For example: (in your case you can use "; " as separator)

Hope this helps,

Khuong

Hello Khuong,

I tried to replace the loop and assign widget  by this one, but the values in expertise column disappears. Anyway, thank you for the help and answering!

Solution

Hello John Renz Errol del Mundo,

You can check for the below condition

1. If it is last element then you should not add the colon

If(GetEmployees.List.Length = GetEmployees.List.CurrentRowNumber+1,"",";")

 Kindly refer the below attached document for EOF

Hope this helps!

Regards,

Ellakkiya.S

 

Hi Ellakkiya!

Yes! This one works! Thank you so much, the problem is now solved.

mvp_badge
MVP

Although this works, I think the more sensible test would be to start with the CurrentRowNumber, and compare that to the Length:

If(GetEmployees.List.CurrentRowNumber < GetEmployees.List.Length - 1, ";", "")
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.