Removing extra semi colons appearing in column

[jamesfisher]

Hello!

I have a flow that capture 'one or more approver' and put their name into a 'Document Reviewed By' column in the Document Library in SharePoint. I added the semi colon in the flow as shown before but it will always show an extra one after the final name. 

Is there a way to show this without the extra semi and even better, neither of the two at the end!? 🤓

[PrasadAthalye · Accepted solution]

I see that you are updating Item inside Apply to each. You should do it outside the loop. And you can use substring expression like below...

substring(variables('approverslist'), 0, lastIndexOf(variables('approverslist') ,';'))

[jamesfisher]

Thanks so much for the reply @PrasadAthalye . I've tried to apply this but not sure if I am doing it correctly. I'm getting an error and not sure how to resolve it. Have I moved the update item correctly?

[jamesfisher]

Actually @PrasadAthalye  - I suspect you were suggesting something like this! Appears to be working! Thank you!!