Answered

Remove ending comma from concatenated emails

(0) Share

Report

Posted on by theisogunro

272

I a trying to use an http request to send emails to a group but I can't figure out how to remove the extra comma on the end. Here's how I created it.

I grab the users from the group and Parse the JSON. The d.results looks like this @{body('Send_an_HTTP_request_to_SharePoint_3')?['d']?['results']}

I then loop through the body and grab the appended emails and store it in the varGovEmail

I then use it in my email

but I get an error because of the last ",".

How can I remove that last comma? Thanks!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Mister_Shaik 1,008 on at

Like (1)

Report
Hi @theisogunro ,

You can use a slice expression on the variable to remove the last comma,
slice(variables('varGovEmail'),0,sub(length(variables('varGovEmail')),1))

I'm basically slicing the string from index 0 to string length-1. Use this expression in the "Send an HTTP action.." and replace the variable with this expression in To property. I've also tested it in a flow, works perfectly!

Hope this helps 🙂

Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
theisogunro 272 on at

Like (1)

Report

That worked! The last comma was removed but I get null. I will accept your solution and post the new problem. Thank you!

Was this reply helpful? Yes No