Power Platform Community Forum Thread Details

Hello everyone! I want to know if there is a way to send emails in Outlook when an Excel cell is updated.

To be specific: I use a checkbox and I need an email to be sent when it changes from FALSE to TRUE. My Excel file has more than 7,000 rows and may continue to grow.

Categories:

Building flows

Using flows

Hello @CD-27011439-0

You really have 2 options.

1. Create a flow that gets called via HTTP, and then create some VBA script code that when you CheckThebox it will trigger the flow from VBA

2. You could use when an item is added or modified, and then add a condition check if your Checkbox cell is equal to true (meaning checked).

You will need a premium license for the first option and some additional authentication configuration.

At this point I am certain ChatGPT or CoPilot or any other AI can write the code for you on the VBA side its been done 109000000000 times before lol

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey