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,270 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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard