I have a SharePoint List with 6 columns with email addresses of the recipients of an automatic email that will go out with an attachment. The email will be triggered as soon as a file is dropped to the OneDrive folder by matching the file name and what's listed in the SharePoint List.
My last pain point is to write an expression that will allow the automatic emails to go out and be able to identify the BLANK cells and will send NO email if the cell is blank... Can someone help? I tried below expression and there was an error message. Please help.
concat(String(item('Apply_to_each')?['field_5']),if(equals(String(item('Apply_to_each')?['field_6']),'','',concat(';',String(item('Apply_to_each')?['field_6'])))),if(equals(String(item('Apply_to_each')?['EmialContact4']),'','',concat(';',String(item('Apply_to_each')?['EmialContact4'])))),if(equals(String(item('Apply_to_each')?['EmailContact5']),'','',concat(';',String(item('Apply_to_each')?['EmailContact5'])))))
The list columns are not multiple choice people. It was all set up as text format. These email addresses are not internal so they are manually added to the list when needed.