Power Platform Community Forum Thread Details

Hi! 😉

I have an Excel Sheet with data from Project Online. The data contains Project id, Project Managers mails (PM) and a coloum that can be either 1 og 0 depending on what the PM has entered in Project Online (PO), regarding a question they are given.

I want to make the flow to: Send the PM a mail if the row of the new created unique project contains 1 in the coloum with 1 and 0.

The mail can only be send out one time pr. unique project id, since the PM can have mulitple projects - This is in order not to spam them, since it just is a kindly reminder, to answer the question they are given in PO.

Ps. the Excel Sheet is one I have Exported from PowerBI, so it is not live. I just made a not working flow as shown in the pic. below.

If you have a better work around method, please inlight me!