Comments column with append turned on do not show in alerts

[joef]

Hi All,

I have a column for comments in an issue tracker that has append turned on.

When FLOW sends the alert the comments are always empty, is there a way to have FLOW display the comments entered into the column?

TIA,

Joe

[RobElliott]

Hi @joef, what application are you using for the issue tracker, and can you post a screenshot of your flow so we can hopefully provide a solution.

Rob
Los Gallardos

[joef]

I am using SPO...

Business is just a choice column

the 2 converted dates are modified and created 

the empty function is on Date completed column t make sure its not a completed item

[RobElliott · Accepted solution]

To check whether the date column is empty or not it is probably better to use null, for example completed is equal to {expression} null

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[joef]

I had issues with validating dates to NULL.  When I loaded a variable all null values displayed as 1/1/1900.  I always said where date < 1/1/2000 since we dont have any data older in SPO :).

Then I found the expressions and "empty not equal to True" worked, = NULL never workd for me.

My issue here is my comments column does not display any data when I have the Append turned on in the column.  It should grab the last comment when the alert goes.

Thanks for the idea 🙂

[joef]

Not sure why @v-alzhan-msft accepted this as answered.

I don't see an answer for:

The SPO column has append turned on the multi line text box.  

When FLOW sends the alert the comments are always empty, is there a way to have FLOW display the comments entered into the column?

Thanks,

Joe