Searching for data in email

[ponygirl]

Hello guys, 
I have a stupid problem but I don't know what to do. I already managed to create it but I had to change it and since then, it doesn't work anymore. 
I need to look at specific data in email but I keep getting false message, even though it should be true. I had to change it because of telephone number in body of email, which ends 0 (at least i think it was triggering false). I even tried "contains" "Is equal to" but the result is still same.. do you have any idea why do I get false results and how could I change it ? Thanks in advance for any help.

[schwibach]

First thing to do:

Create a compose action for each of the conditions and see which ones return true and which ones return false...Then we'll check the ones that misfire.

[mjburley]

Perhaps you want an OR and not AND in that clause? All 5 of those conditions must be met to get a true, which is probably not what you want.

[Afflixit]

no no, and is correct, I need true only if all of them are 0.

[mjburley]

OK, I don't understand how one string can be simultaneously equal to 5 different strings.

Anyways, as @schwibach said, throw in debug Compose actions to isolate the issue.

[a_schwibach]

My guess is that the conditions access different parts of the body and then check if they match each.

With the compose actions we'll find out what's what.

[ponygirl]

Hello guys, 
I’m sorry for such a late reply, but I couldn’t work on it sooner. I did condition for each operation separately and I found where the problem is. Right now, I use contains function but the problem is in space. As you can see in the table in the email, there are two spaces between the text and 0´s. I know its stupid, but is there something I can do about this ? When I straight copy that text from the table, it doesn’t work. When I add there two spaces, it doesn’t work. But when I remove one space from the table and from the flow, and leave there just one, it works. Problem is that we can’t do anything with the format of the table. I add snips of my flow and table once more. 

[schwibach]

Off the top of my head, two solutions:

1. You could use the replace function to get out the double spaces

2. You use additional OR-conditions to look for the double-spaced items and the single-spaced items. 

[schwibach]

One third thing comes to mind.

If you have that data in tables, you could look into Power Query as a step in Power Automate to clean up the data first.

[ponygirl]

I have tried that option with replace, but unfortunately I need help. So far, I’m trying this only with the first condition (Double  0 in the email).  So far I did this flow but I’m sure I missing something. I managed to do that with the clear new flow with manual trigger without email, but when it comes to the email, it doesn’t work. I’m not sure If I transforming Double  0 to Double0 in email body. Do you guys see any problems here ? Thank you again for your time I really appreciate it. I have even tried to put "Compose" instead of "Body" in the last step, but that didn’t work either. 

[schwibach]

It seems that you are replacing the two spaces with zwero spaces, when what you want to do is replace two spaces with one space (But I can't see the exact function and what you're getting from the email body.

You might want to use the html2text action first to get proper text from the html that the email body gives you.