cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to send an email when a list cell is modified from no to yes

Hi,

I am trying to create a stock list in SharePoint.

I have made a list with all items we stock and want an email when the 'current stock' becomes lower than the 'minimum stock.

At the moment I have a re-order column that says 'no' if there is enough stock and 'yes' if there isn't.

I am trying to use this change from 'No' to 'Yes' as the trigger for the email.

I'm sure its something simple I am missing but I can't work it out. I have attached what I have at the moment below.

Any help is appreciated.

SamCapture.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

Re: How to send an email when a list cell is modified from no to yes

I think I have worked it out.

I ignored the re-order column and set the trigger as the current stock is less than the minimum stock and it has started to work.

I had tried this before but this time I also had the compose section in so @juresti that may have worked after all.

Thanks everyone. You have been a great help.

Sam

View solution in original post

9 REPLIES 9
Highlighted
Resolver II
Resolver II

Re: How to send an email when a list cell is modified from no to yes

Hello @mr-samd 

 

Have you tried changing the condition to be

 

Reorder Startswith Y

 

I have had to do this on some of my flows.

 

Thanks

 

Bradley

Highlighted
Helper I
Helper I

Re: How to send an email when a list cell is modified from no to yes

@burgett94 I gave it a go and it doesn't seem to have made a difference. It is still not triggering

Sam

Highlighted
Super User III
Super User III

Re: How to send an email when a list cell is modified from no to yes

@mr-samd if you've used a Yes/No column in the SharePoint list then in the condition try either is equal to true or is equal to 1

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.

Highlighted
Super User III
Super User III

Re: How to send an email when a list cell is modified from no to yes

@mr-samd 

What type of column is the reorder column?

If you are still having issues, you could just compare the current stock and reorder level.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Helper I
Helper I

Re: How to send an email when a list cell is modified from no to yes

'calculated column as it automatically changes depending on the stock level. I hope this helps...

Highlighted
Responsive Resident
Responsive Resident

Re: How to send an email when a list cell is modified from no to yes

Hi, one thing I do when testing flows is compose the output of key values.

 

Try composing the value of Re-order? right above the condition.

This way you can see exactly what that value is, then you can compare it depending on what the value actually is.

Specially since the condition doesn't display values in the run log.

04.PNG

 

The Compose Action is very helpful when building flows and troubleshooting.

It always helps when you see the values that are coming through.

 

 

Highlighted
Helper I
Helper I

Re: How to send an email when a list cell is modified from no to yes

@juresti I have put this in and it hasn't seemed to make a difference. sorry

Highlighted
Helper I
Helper I

Re: How to send an email when a list cell is modified from no to yes

I think I have worked it out.

I ignored the re-order column and set the trigger as the current stock is less than the minimum stock and it has started to work.

I had tried this before but this time I also had the compose section in so @juresti that may have worked after all.

Thanks everyone. You have been a great help.

Sam

View solution in original post

Highlighted
Responsive Resident
Responsive Resident

Re: How to send an email when a list cell is modified from no to yes

Ok, great.

 

I did not realize your flow was not triggering at all previously.

 

The reason I suggested the compose is because I thought the condition was not being met.

With compose you would see actual the value coming through.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (13,728)