web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Single mail when perfo...
Power Automate
Unanswered

Single mail when performing one or more changes on a column

(0) ShareShare
ReportReport
Posted on by 3

Good morning everyone,

I have a flow that every day checks a column of a sharepoint called "DataAppuntamento" and if the date is less than or equal to the variable "DataChiusura" and the status is equal "Aperto" changes the value of another sharepoint column called "StatoApp" The flow works correctly but I would like that if it performs a change of state it sends an email to say that changes have been made.


I tried by inserting send mail after update element but rightly it sends me an email for each status change it makes, instead I would like a single email if it makes one or a hundred status changes.

 

How can I do?

 

Thank you all.

 

flussoPowerAutomate.png

Categories:
I have the same question (0)
  • ScottShearer Profile Picture
    25,278 Most Valuable Professional on at

    @dottorni 

    I suggest the following:

    1. Use a filter query so that only records that meet your condition are returned
      1. You won't need your condition
      2. Here is a link for more info on creating OData filter queries
    2. Add a Create an HTML table action
      1. Create the HTML table from the output of your Get items action
    3. Send a single email and include the HTML table

    image.png

    Let me know if you need more help.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 291 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 238 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 109 Super User 2026 Season 1

Last 30 days Overall leaderboard