Read Email from JSON object ,concatenate and assign them into one variable

[Lk]

Hi ,

I have results like below

{
  "d": {
    "results": [
      {
        "__metadata": {

     },
        "Title": "xxxxxx",
        "Email": "xxxx@xxx.com"
      },

 "__metadata": {

     },
        "Title": "xxxxxx",
        "Email": "xxxx@xxx.com"
      }

    ]
  }
}

I have above JSON am able to convert to JSON object but the problem is extract Email information from JSON and then concatenate with column need to use those Email Address to send emails at one go

Thanks in advance

[v-xida-msft · Accepted solution]

Hi @Lk,

Could you please show a bit more about the JSON object?

Do you want to extract email addresses from the JSON object?

I think there is something wrong with the JSON object that you provided, please check if you have provided a proper JSON object sample.

I assume that your JSON object data as below:

{
  "d": {
    "results": [
      {
        "__metadata": {
        "Title": "xxxxxx",
        "Email": "Test1@xxxxxx.onmicrosoft.com"
      }
      },
      {
 	"__metadata": {
        "Title": "xxxxxx",
        "Email": "Test3@xxxxxx.onmicrosoft.com"
      }
      }
    ]
  }
}

If you want to extract email address from above json object, please take a try with the following workaround:

• Add a proper trigger, here I use Flow Button trigger.
• Add a Variables-> "Initialize variable" action, Name set to EmailStrings, type set to String and Value set to empty.
• Add a "Compose" action, Inputs field set to following JSON data:

{
  "d": {
    "results": [
      {
        "__metadata": {
        "Title": "xxxxxx",
        "Email": "Test1@xxxxxx.onmicrosoft.com"
      }
      },
      {
 	"__metadata": {
        "Title": "xxxxxx",
        "Email": "Test3@xxxxxx.onmicrosoft.com"
      }
      }
    ]
  }
}

• Add a "Apply to each" action, input parameter set to following formula:

outputs('Compose')?['d']?['results']

• Within "Apply to each" action, add a "Compose 2" action, Inputs field set to following formula:

concat(item()?['__metadata']?['Email'],';',variables('EmailStrings'))

Add a "Set variable" action, Name choose EmailStrings, Value set to output of the "Compose 2" action.

• Under "Apply to each" action, add a "Compose 3" action, Inputs field set to EmailStrings variable.

Image reference:

The flow works successfully as below:

More details about using expression in flow actions, please check the following article:

Use expression in flow actions

Best regards,

Kris

[Lk]

Hi Kris,

Thank you so much for your explanation.But my data was outside _metadata.But I found out another solution by using "Append string variable" action.So I use apply to each and compose,Append string actions.In that way I acheived my goal

But big thanks to you for your idea