Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Require Help for Setting up reminders using SharePoint List

(1) ShareShare
ReportReport
Posted on by 20
Hi , 
 
I need some advise and help.
Background: I have use a SharePoint list and have 2 fields (Email1 and Email2) to send out to my users to remind them.
This 2 fields are not mandatory. 
I have encountered an issue when I do not have values in either of this fields, Power Automate is not able to send out the reminders.
I am using the Send an email (V3) and included the Email2 as CC which i think could be what was causing the issue.
 
Thanks in advacne 
Categories:
  • rickychua123 Profile Picture
    rickychua123 20 on at
    Require Help for Setting up reminders using SharePoint List
    Hi @trice602,
     
    Sorry, do i put it in the CC or apply to this as well:
  • trice602 Profile Picture
    trice602 11,657 on at
    Require Help for Setting up reminders using SharePoint List
    Hi,
     
    I'm using the trigger as dynamic content but the expression will work for you when you point to your Email2 dynamic content in your SharePoint list.
     
    So in the CC, you don't use Email2 directly, you input the expression:
     
    if(empty(triggerOutputs()?['body/Email2']), '', triggerOutputs()?['body/Email2'])
     
     
    So if it is blank, it includes nothing, else use the value in Email2.
     
     
    ------------------------------------------------


    If this was helpful, please like and/or mark as a verified answer to help others find this too!


    Always glad to help! 💯💯💯💯💯

    Tom 

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

     

     

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,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard