cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vinoth1_
Helper IV
Helper IV

How to send an email when a particular column in sharepoint is updated with a date&time value?

Hi All,

 

I am trying to create a flow to send email, when a particular column in the sharepoint list "Apstripinat" gets updated by datetime value.

 

i was thinking of using a condition when Apstripinat column contains a value or Apstripinat column is not blank. but getting errors and dint work. so i am stuck here.

 

any help is highly appreciated.

Thanks in advance.

 

flow.JPG

 

 

4 REPLIES 4
efialttes
Super User
Super User

Hi!

I would try 'is not equal to' operator, or even better, wrap column dynamic content inside empty() WDL function:

 

Add the following expression to the left side of your condition rule:

empty(triggerBody()?['Apstripinat'])

Add the following expression to the right side of your condition rule:

false

Operator: is equal to

 

If you are not familiar with expressions, please follow these steps to add them:

https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



v-bacao-msft
Community Support
Community Support

 

Hi @Vinoth1_ ,

 

What is the type of Apstripinat field?

 

You can try to replace dose not contain with is not equal to.

 

Then set the right parameter of Condition to blank.

 

Please take a try again and feel free to let us know if you have any questions.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-bacao-msft ,

 

"What is the type of Apstripinat field?"

 

it is a date field.

 

 

 

Hi @Vinoth1_  were the suggestions above able to help you with your issue?

 

Feel free to let us know if you have any questions.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,532)