cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joef
Level: Powered On

Comments column with append turned on do not show in alerts

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Comments column with append turned on do not show in alerts

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.

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Comments column with append turned on do not show in alerts

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
Level: Powered On

Re: Comments column with append turned on do not show in alerts

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

NoComments.jpg

Super User
Super User

Re: Comments column with append turned on do not show in alerts

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.

View solution in original post

joef
Level: Powered On

Re: Comments column with append turned on do not show in alerts

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
Level: Powered On

Re: Comments column with append turned on do not show in alerts

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,774)