Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

String Expression to send email

(0) ShareShare
ReportReport
Posted on by 31

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

  • Zitallis Profile Picture
    Zitallis 31 on at
    Re: String Expression to send email

    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.

     

    Zitallis_5-1681163012453.png

     

     

    Zitallis_0-1681162692937.pngZitallis_1-1681162710736.pngZitallis_2-1681162734163.pngZitallis_3-1681162800161.pngZitallis_4-1681162951976.png

     

     

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: String Expression to send email

    @Zitallis ,

     

    Can you post a screenshot of your flow?

    Are the columns multi choice people fields?

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard