Using IF formula after email body split not working

[Fernanda]

Hello!!

I am trying to obtain certain data from an email body and convert them into different acronyms.

So far, I was able to extract the info I needed with a split formula, and identifying each parameter

split(outputs('Html_a_texto_Cuerpo_email')?['body'],outputs('Tecla_Enter'))

This is the result I need.

This, so far, works perfectly.

But, and here is my main issue, is that I need to turn that result into an acronym.

For example: Aguas A S.A. has to be turned into ARA, Aguas Al into ADA, and so on.

I was using an if formula, adding an equals: 

if(equals(outputs('Empresa'),'Aguas A S.A.'),'ARA','OTHER')

Note: OTHER is supposed to be another formula comparing Aguas Al into ADA and so on, but tried to test the logic first.

And here, no matter what I do, I keep getting OTHER as result, when it is supposed to be a true result and show ARA.

Tried initialiazing a variable as string, using " character... but nothing.

Can you help me please?

Thank you in advance!!

[v-liwei-msft · Accepted solution]

Hi @Fernanda ,

Your compose "Empresa" returns an array instead of a string.

You can use the join function to convert the result into a string and compare it:

if(equals(join(outputs('Compose'),','),'Aguas A S.A.'),'ARA','OTHER')

 I have made test for your reference:

Best Regards,

Levi

[Fernanda]

brilliant!!

thank you so much!!!

I had also tried with a initializing a variable thinking it could have convert the array into a string. This totally fixed my issue.

Thank you so so so much!!!