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
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
Hi @marial16
I have extended the flow to read the contents. Here it is
Parse JSON Schema is as follows:
Hi @marial16
Use the replace expression
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2