Parameter 'To' cannot be null or empty.

[4sjoel]

Hello, 

I have created a simple flow to send multiple emails once a job has reached a certain milestone. I have the flow triggered to run every hour, it will scan an excel table and email the relevant information. The issue I am having is the blank rows, it is failing on automate as there is no "to" email address so keeps failing. also further down there is an update row feature so the milestone is updated again no do data so fails every time. 

I have attached a screenshot of the flow if anybody can help? 

[mattias1172]

For the first Apply To Each, add a condition before the Send An Email action and check if the email value is/is not empty. For you "is not empty" branch, add the Send An Email action. The is empty branch can be left blank and it will skip it when there is no email. 

For the second Apply To Each, where is the data coming from that's updated in the Table? Can you expand the Update A Row action to show what dynamic content is being passed in. 

[AbdulMoiz]

Hi,

I created a flow to send bulk emails and used my various email addresses to test it. During the test, the emails with attachments were received as expected. However, the flow status remained "Running" and after a few minutes, an error message appeared. There were no issues with the flow since it successfully sent emails to multiple addresses from an Excel sheet. Despite this, the status displayed an error message instead of "Completed".

See below screen capture of Error. Pls advise me if there is anyway to get rid of this error message.