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 III
Super User III

@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

View solution in original post

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_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,798)