0

I am working on a sharepoint list where there is a field (dropdown- Yes/No) to specify if the mail is to be triggered or no. whenever a user selects "yes" and saves the item, I want an email to be triggered using microsoft flows

Can anyone please advice me how do I do this. Any assistance would be really appreciated. Thank you!

3

Please check this post from Powerusers forum. It contains what you need.

Basically, you need use the SharePoint Connector Trigger for when a SharePoint item is created or modified and then a switch-case on the column value that you want to monitor.

enter image description here

This flow will trigger every time the list is updated but no actions will be taken if the condition is not met.

Here is a Microsoft template that you start with to send email when a list is modified. You can tweak it as per your need by adding the switch-case condition.

Let me know if it helps.

| improve this answer | |
  • Thank you for your suggestion. :) Will it work if I add condition? I have a field "Mail to be sent" which is a dropdown list - Yes/No. I want the mail to be triggered if the user chooses "Yes" and if the user selects "No" then it should not send any email. I tried using condition where the dynamic field "Mail to be sent Value" is equal to "Yes" but still the condition takes as false when the user select Yes and doesn't trigger the email. – HRY May 4 at 6:58
  • It might be possible that the field is not taken in to consideration. Please check with any other field to see if there can be other problems like, the actual name of the field to bound to etc. but this is the way to send email through Power Automate. – UBK May 4 at 13:08
  • Thank you for the answer, I did not know that in the condition the value to be matched is case sensitive. That's why it was taking as false. Now, it is working. :) Thank you! – HRY May 5 at 8:37
  • Please mark this solution as answer if it has helped you. – UBK May 5 at 12:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.