Answered

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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