web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Email not sending

(1) ShareShare
ReportReport
Posted on by 22
Thanks in advance for the help! 
 
I'm fairly new to Power Automate. I am trying to make a flow where the following happens. 
 
  1.  A list is edited/updated 
  2.  only alert users on certain fields
  3.  send email
The flow works when one of the "Or" conditions aren't met. But when one of them is met, it fails. I am coming behind someone else trying to figure this out. So I don't know if it's setup the correct way. Error message is attached on one of the photos.
 
Here is the email code: <p class="editor-paragraph">The following has been modified for @{concat('<a href="', triggerBody()?['{Link}'], '">', triggerBody()?['Title'], '</a>')}<br><br>BORROWER(S): @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/Borrower_x0028_s_x0029_'], triggerBody()?['Borrower_x0028_s_x0029_'], '')}<br><br>GUARANTOR(S): @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/Guarantor_x0028_s_x0029_'], triggerBody()?['Guarantor_x0028_s_x0029_'], '')}<br><br>PROPOSED FEE: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/PROPOSEDFEE'], triggerBody()?['PROPOSEDFEE'], '')}<br><br>PROPOSED RATE: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/PROPOSEDRATE'], triggerBody()?['PROPOSEDRATE'], '')}<br><br>LOAN AMOUNT: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/field_3'], triggerBody()?['field_3'], '')}<br><br>NEW MONEY: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/NEWMONEY'], triggerBody()?['NEWMONEY'], '')}<br><br>PROPOSED PURPOSE CODE: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/PROPOSEDPURPOSECODE'], triggerBody()?['PROPOSEDPURPOSECODE'], '')}<br><br>PROPOSED TERM: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/PROPOSEDTERM'], triggerBody()?['PROPOSEDTERM'], '')}<br><br>PROPOSED AMORTIZATION: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/AMORTIZATION'], triggerBody()?['AMORTIZATION'], '')}<br><br>APPROVAL AUTHORITY: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/field_15'], triggerBody()?['field_15'], '')}<br><br>APPROVAL RECEIVED: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/field_9'], triggerBody()?['field_9'], '')}<br><br>MEETING NOTES: @{if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/MEETINGNOTES'], triggerBody()?['MEETINGNOTES'], '')}</p>
Screenshot 2026-02-25 142616.png
Screenshot 2026-02-25 142523.png
Screenshot 2026-02-25 142039.png
I have the same question (0)
  • Suggested answer
    Pstork1 Profile Picture
    69,556 Most Valuable Professional on at
    There error isn't something wrong with the condition. Its the IF() functions in the body of the email. When you issue the Get Changes it only returns the columns that were changed.  So when you reference columns that haven't changed you get a Null value.  That's why some of the IF() statements are failing.  The fix is to put each value used in the IF() inside a Coalesce() function so you can provide a False value when they are Null.  Here's the documentation on Coalesce.  Blank, Coalesce, IsBlank, and IsEmpty functions - Power Platform | Microsoft Learn

    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

    Paul Papanek Stork, MVP
    Blog: https://www.dontpapanic.com/blog
     
     
  • Suggested answer
    Haque Profile Picture
    3,653 on at
    Dear @, Greetings from Haque! My apologies if this response doesn't bring you the right solution. 
     
    First thing first,  let's analysis the error: "The template language function 'if' expects its first parameter to be of type boolean. The provided value is of type 'Null'."
     
     
    Probably the potential problem in the Power Automate flow is that a condition or expression is trying to evaluate a value that is null where a boolean (true or false) is expected!
     
     
    Let's be very careful for Null values in condition checks: A field that needs a condition check must not be missing or null, particularly in your case the condition fails because it expects a boolean where as it is Null.
     
    Safe guardif(equals(coalesce(triggerBody()?['FieldYouAreComparing'], 'false'), 'true'), decision-1, decision-2)
    To be more proactive, we can add null check before condition applied. So in this case we can add a step or expression to check if the field is null or empty, and handle that case.
     
    I am suspecting one more area in action "Get changes for an item or a file": The error screenshot shows multiple conditions checking if a field "is equal to true" but the field might be null. You need to ensure these fields exist and are not null before comparing.
     
     
    Though null check is your main safety-net, shouldn't we be vigilant in  "Send an email (V2)" action?
    The inputs use an if expression that fails because the condition is null. Please review the expressions in that action and wrap the condition with null-safe checks.
     
     

    I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!
     

    If you have one mintue:
    This is Shahidul Haque, I am pretty sure I have spent times on this issue to address the close resolution. To bring up a resolution for the betterment of the community users, these are the possible things I probably did:
    1. Read the issue carefully.
    2. Investigated and did RnD.
    3. Looked for a close match to see if the issue was previously posted or not.
    4. Took help from AI if my storehouse of knowledge failed.
    5. Spent time on taking screenshots (if it is/was needed).
    6. Revised the content before final posting.
    7. Finally, if it was a priority, I overthrew my personal task to provide a correct solution! 
     
    Why did I bring up these things? Everyone does these, right? Now let's change the lens. If you were me, what would you expect? A simple like
     
     
    😀
     
     
  • EH-25061946-0 Profile Picture
    22 on at
    @Pstork1 so write it like this?: 
     
    coalesce( if(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/Guarantor_x0028_s_x0029_'], triggerBody()?['Guarantor_x0028_s_x0029_'], ''), '')
  • Verified answer
    Pstork1 Profile Picture
    69,556 Most Valuable Professional on at
    The Coalesce just goes around the value inside the IF.  So something more like this.
     
     if(coalesce(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged/Guarantor_x0028_s_x0029_'],false), triggerBody()?['Guarantor_x0028_s_x0029_'], '')
     

    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

    Paul Papanek Stork, MVP
    Blog: https://www.dontpapanic.com/blog
     

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard