This is my project flow,
- Read range and from EN sheet and take the range and convert into DATATABLE TO HTML and using a text file create the mail body and put the data table in the text file. Use this text file as a mail body in the SEND OUTLOOK MESSAGE ACTIVITY.
Then In sheet EN if the E2 cell is equal to the MAIL sheet MAIN Column then use the mail address depend on the E2 cell in the EN and send the mail to the respective mail address.
I create the flow and but it’s not checking the next page for the mail address and also i used if condition with empty or null expression in the last steps to check mail address for the ceratin name is empty or not.Could some please take look into the workflow and let me know where is that exact issue
please check the excel file and text file for this process.