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'])))))
