trim or replace variable

[marial16]

Hallo,

i am setting a variable initialized as array. The value i am getting is

[

{

"EMail": "myEmail@demo.com",

"Title":"my Email",

"Name":"i:0#.f|membership|mymail@demo.com"

},

{

"EMail": "mySecondEmail@demo.com",

"Title":"my Second Email",

"Name":"i:0#.f|membership|mysecondmail@demo.com"

}

]

Is there a way i can trim the Name property so i can keep only the red highlighted value??

I only want mymail to be the Name property

[abm · Accepted solution]

Hi @marial16 

Use the replace expression

replace(string(outputs('Compose')),'i:0#.f|membership|','')

Expression I used above is

replace(string(outputs('Compose')),'i:0#.f|membership|','')

[abm]

Hi @marial16 

I have extended the flow to read the contents. Here it is

Parse JSON Schema is as follows:

{

    "type": "array",

    "items": {

        "type": "object",

        "properties": {

            "EMail": {

                "type": "string"

            },

            "Title": {

                "type": "string"

            },

            "Name": {

                "type": "string"

            }

        },

        "required": [

            "EMail",

            "Title",

            "Name"

        ]

    }

}

Here is my run result:

Above in my test I have mapped only one property (EMail) under the Apply to each loop. You can use EMail, Title or Name here.

Thanks

[KvB1]

You can also use the select action and enter an expression in the value for Email field where you use a replace function, that way you can avoid the apply to each loop and keep your flow more efficient