Split string on '@'

[Glenda]

Hi, 

Is there any decent way to split a string on @ ('at') in the Compose action?

What doesn't work:

• split(string,'@'), the @ gets stripped out
• split(string,"@"), the @ gets stripped out
• ... working with / is not valid

I got it working by putting the @ in a seperate variable, but I do not like that solution that much.

Any idea?

Thx, 

Glenda

[v-xida-msft · Accepted solution]

Hi @Glenda,

Could you please share a screenshot of your “Compose” action’s configuration?

The split() function splits string based on specific separator and the separator doesn’t exist in output that the function returns.

I have made a test on my side and the flow works well. My flow’s configuration as below:

 The flow works successfully as below:

Best regards,

Kris

[Glenda]

Hi Kris, 

I checked again today, seems to be working now without using the variable.

Overview of that part of my flow:

The configuration of my Compose action is as follows:

last(split(body('Parse_JSON_-_external_guest')?['DisplayName'],'@'))

Seems to be that the "Update" button on my end sometimes does not function correctly in the expression builder. Got it working by clearing the expression completely and pasting it in again as the string defined above, it worked. Today is a better day... 🙂

Thanks!

Glenda

[Guru2]

worked for me.

Thanks