
Hi,
When building a flow in Power Automate I am downloading the details of the response from the form with the ordered goods, a list of rows from Excel (One Drive) where this information is placed and is there a function or do you have an idea how to implement this to find if the Part Number of the goods already occurred in the orders and the status column has the status "ordered"? Further I want to send an email if it is not ordered to the appropriate department to not duplicate orders (I can handle that). I've searched the forums and tried various functions, but to no avail. I would appreciate any help or ideas.
Hi @CPTNoodle ,
We can filter the records in the table with the same number as the reply and "ordered" status, and if the filter result is not empty, it means that it has been ordered and flow will send an email.
This is for your reference.
Best regards,
Rimmon