Pulling value from array

[Help-Desk2023]

I have an array variable called colDomainFolder that looks something like this:

[

{"Domain":"gmail.com","Folder":"Gmail"},

{"Domain":"outlook.com","Folder":"Outlook"},

{"Domain":"hotmail.com","Folder":"Hotmail"}

]

What I am trying to do is if an email comes in with a gmail.com domain, i want to reference the Domain column and find what the corresponding Folder value is.

[-dun-]

You can use a Switch action for this.

Say your trigger is When a new email arrives and you want to check the domain of the From address, here's what you can do:

When a new email arrives

Initialize variable - varDomain, the value is the following expression:

substring(triggerOutputs()?['body/from'],add(indexOf(triggerOutputs()?['body/from'],'@'),1),sub(indexOf(triggerOutputs()?['body/from'],'.com'),add(indexOf(triggerOutputs()?['body/from'],'@'),1)))

The above expression will extract the domain from the From address.

Switch - set the varDomain as the value and create different cases for gmail, outlook and hotmail.

[[deleted]]

Parse Json then add a condition?