Hey Tijana,
You are definitely not asking too much we love to help people in the communities. Especially people learning new things as we all started there at one point 🙂 .
The solution @v-bofeng-msft has described is a good one which I have used on many occasions whenever it was the best suited option. In this case it is certainly an option that would work for you.
I will build one now and take screenshots and pictures to show you how I add the column and make my flow work with it. If you find my pictures and instructions to be confusing let me know and I can either answer your questions on here or get on a call with you.
Step 1 for me to add a new Yes/No column to my Sharepoint List:
I usually call It EmailStatus but in this case I called it 'Has an Email already been sent?'
If you do not know how to add a Yes/No column simply do this:
Click the Add Column button and pick Yes/No -
Then it will open up the window to name the column. Give it a relevant name and then make the Default Value 'No'
Then go to the Power Automate/Flow you have and under the trigger add a condition:
add the Yes/No column in the first box, then make sure the middle box says is equal to and then in the third box add the expression false:
So far the flow is now checking to see if an email has already been sent if it has it will not proceed with the flow.
Then the rest of your flow goes inside the Yes / True part of condition on the left side. You mentioned you had a condition to check if a certain field is equal to yes you would add that here. I replicated this need for another condition on my side by adding another Yes/No Column and checking if that is equal to Yes/True:
In the true part of this condition is where you send the email. So you need to add an action to update the Item to say that an email has been sent. So add the update Item Step.
add the Item's ID:
For all the required fields you will need to add the corresponding dynamic content from the trigger:
E.g. in my case that would be title.
Then go to your new Yes/No column 'Has an email already been sent?'
and make it Yes:
So to summarise:
We first add a Yes/No Column to the List and Default it to No.
Then we go to our flow and first check if the value is equal to false
if the condition is true we continue to our next condition which was your existing one.
if that is true that means a new email can be sent. in this true we add the update Item so that the item now has a yes value to confirm an email has been sent and won't send another in the future because of the first condition.
if you have questions please reply to this or let me know if you need a call and we can work it out 🙂
take care and good luck with your flow 🙂
