I have built a flow as follows.
I have 2 different excel files with "order numbers" on both. The idea is that if Order number on sheet A matches with Order number on sheet B, it should update a column that is next to the order number to "sent" and send an email. it should only send an email if the "sent" status column is empty.
Categories: