trigger when email arrives (Inquiry) then match with excel cell and reply with the full row

(0) Share

Report

Posted on by reembkrey

Hello Everyone

I want to create a flow to send a response for all received inquiries that match the inquiry in an excel sheet ex.

Inquiry	Response
working Hours	8:00 AM-5:00 PM
registration requirement	ID, Passport

the problem is when I tested the flow it sends an email with all the information in the excel sheet, not the specific row that was supposed to be filtered

ex. when I receive an email containing working hours reply with a response column that beside working hours

check the flow below

Thank you in advance

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

reembkrey 9 on at

Like (0)

Report
Copy link

Link copied!

@abm

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @reembkrey

1.Apply to each should iterate through the results returned by the Filter array.
2.Use the expression item()?['ColumnName'] in body.

Best Regards,
Levi

Was this reply helpful? Yes No
reembkrey 9 on at

Like (0)

Report
Copy link

Link copied!

My filter wasn't working that's why it was giving me the whole excel, I deleted the signature and everything from the email I want to send except the body I want it to compare then I tried again
tried this below this one is not working item()?['ColumnName']

now I am trying to figure out how to extract only Inquiry text in the email without any plain text line signature and so I may use AI builder in this

Thank you

Was this reply helpful? Yes No