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 Platform Community / Forums / Power Automate / Flow Fails when Commen...
Power Automate
Answered

Flow Fails when Comments Field in Manual Trigger is NULL

(0) ShareShare
ReportReport
Posted on by

I'm sure this is something simple but I cannot figure it out. I am taking input from a manual trigger and populating a SharePoint list after some manipulation in Excel. If  the Comments field has text it works fine, but errors out on Create Item when the Comments field is NULL. Is there a way around this?

 

Issue with NULL Value.jpgFlow Error.jpg

 

Categories:
I have the same question (0)
  • RezaDorrani Profile Picture
    12,145 on at

    Hi @animartis 

     

    Looks like some of the trigger properties were updated

    Remove the Comments and checkoincheckout dynamic content and re-map them

     

    Regards,

    Reza Dorrani

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • animartis Profile Picture
    on at

    I deleted both the Check In/Out and Comments, saved, exited, re-opened Flow and added them back. Same issue.

  • RezaDorrani Profile Picture
    12,145 on at

    @animartis 

     

    share screenshot of create item action (I want to see all the properties)

  • animartis Profile Picture
    on at

    @RezaDorraniI expanded both the manual trigger and Create Item in my original post. Is that what you need?

  • RezaDorrani Profile Picture
    12,145 on at

    Hi @animartis 

     

    Fill only title field and see if it works

    then start filling one by one and then figure out which column is causing the issue

    it might be related to a type mismatch between sharepoint column and the value u r providing

  • animartis Profile Picture
    on at

    Thanks @RezaDorrani 

     

    I definitely know that it is the Comments field because I previously had that field mandatory in the manual trigger and it worked fine. It is only when I make the field optional that it errors out. I definitely believe it is related to a NULL value being passed, but I'm not sure how overcome that. I've verified that the SharePoint column is set to not required and is a text field as well. Hope that helps and thanks for the assistance!

  • RezaDorrani Profile Picture
    12,145 on at

    Hi @animartis 

     

    add a compose action before the create item action

    for the compose action set its value as the comments dynamic content

     

    run flow and check value in case of no comment provided

     

  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hey @animartis 

     

    This is a known issue with optional input types in manually triggered (or any other trigger that has any manual inputs and those are passed as null) in Flow. 

     

    Please take a look at the screenshot below: 

    Err1.PNG

     

    Err2.PNG

    You can proabably use this and replicate in your flow too. The manual trigger has a Comment input that is optional. I am trying to initialize a variable with that input and if there is no value passed while triggering the flow, this is bound to fail. And then I am setting an action to run only if that initialize action fails and adding any consecutive steps. At the end remember to add the terminate action with status succeeded or else the flow will register as failed. 

     

    And if there are inputs passed in the comments while triggering the flow, the normal path can be followed. 

     

    Hope this Helps!

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

  • ScottShearer Profile Picture
    25,280 Most Valuable Professional on at

    @animartis 

    I haven't  tested this yet, but try using the coalesce function.

     

     

  • animartis Profile Picture
    on at

    @yashag2255 

     

    I might be doing something wrong, but it is not failing at the initialization of the variable, instead it fails at the Create Item. Would this still work?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 58

#2
David_MA Profile Picture

David_MA 53 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 36 Most Valuable Professional

Last 30 days Overall leaderboard