cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mr-samd
Helper II
Helper II

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

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
burgett94
Resolver II
Resolver II

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

Best regards,

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

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

Sam

RobElliott
Super User
Super User

@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.

ScottShearer
Super User
Super User

@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

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

juresti
Continued Contributor
Continued Contributor

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.

 

 

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

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

juresti
Continued Contributor
Continued Contributor

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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (1,685)