Hi all, I'm new in powerautomate. I would like to create a flow wich starts when I received an email.
This flow check the objects and generated an automatic answer with an excel attachment made a query in an excel on onedrive.
For example, I have an excel in oneDrive with two columns:
| ID | COD |
| A1 | X01 |
A1 | X02 |
| A1 | X03 |
| A2 | X01 |
| A2 | X07 |
If I send an email and sign in the object X07, I want to received a table like this:
| ID | COD |
| A2 | X07 |
if I send an email and sign in the object X01, X02. I would like to received only ID=A1 because it contains both X01, X02.
| ID | COD |
| A1 | X01 |
A1 | X02 |
Someone know how can I do this?
Thank you so much

Report
All responses (
Answers (