Unanswered

Search in excel colomn and send email after

(0) Share

Report

Posted on by ELYATIM

I'm trying to create a flow that searches for a specific word in an email. then with a condition, compare the value with an excel column, and send an email if the value is in the column.
I managed to isolate the value in the email, but it's like the flow doesn't identify the value in the condition!
do you have an idea please

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

v-yetonggu-msft on at

Like (0)

Report

Hi @ELYATIM ,

How many words are you looking up? What words do you need to look up?

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
ELYATIM 10 on at

Like (0)

Report

actualy it s just one word, i used substring to retreive it. then i want to compare it with excel colomn. but when i ran the flow, it seems that he dont recognize it !
the flow stops here

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on at

Like (0)

Report
Hi @ELYATIM ，

Please check this test:

My Outlook Email:

My Excel Table:

My Flow Overall Preview:

My Flow Configuration Parameters:

item()?['EMAIL']

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
ELYATIM 10 on at

Like (0)

Report

thank you for your reply, it run but blocking at some point ( see picture below )
also im wondering if the value in email is not in excel, what the flow will do ?

i dont know why , it give me two 'apply for each !! after i run the flow

Was this reply helpful? Yes No
ELYATIM 10 on at

Like (0)

Report

thank you for you reply,
i found where's the error, it was lenght of the value i searched. it count a space plus of the value so the condition didn't work

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Hi @ELYATIM ，

Did the flow run successfully? If you want to use dynamic content in the email body, use the property in the Filter array instead of clicking on the dynamic content in the list rows present in a table so that you don't loop twice.

Please use this expression in Email Body:

item()?{'Property']

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No