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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Email daily summary of...
Power Automate
Suggested Answer

Email daily summary of modified files in SharePoint library

(0) ShareShare
ReportReport
Posted on by 415
Hello,
 
I've gotten this far in creating the flow but I don't know how to get the HTML Table into one email that has all of the content.
 
 
 
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,978 Moderator on at
     
    1. Make sure your array has Headers in it already (so when you define it add them there)
    2. Use the Create HTML Table action, with the array as the input and select that it has Headers
    3. In the Email use the Outputs(ofyour create html action) to get it into your email
     
    If you want it nicely formatted follow this.
     
     
    If this resolves your issue please mark as such and maybe a like.
     
    Cheers!
     
  • trishmalloy Profile Picture
    415 on at
    If I put the Send email action inside of the Apply to Each I'm going to be sent one email for every document modified that day. I can't access the Create HTML Table outside of the Apply to Each action.
     
     
    Append to Array and HTML Table.png
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,978 Moderator on at
     
    You Said:
     
    If I put the Send email action inside of the Apply to Each I'm going to be sent one email for every document modified that day.
     
    I can't access the Create HTML Table outside of the Apply to Each action.
     
    My response to these
     
    You shouldn't be trying to "build" an HTML table using an Array of Table Tags
    You should be storing the values you want in the table in the array
     
    1. Initialize an Array with your headers
    2. Get Data
    3. Apply to each
    4. Append each piece of data as a single line in an array, so that it matches the headers
     
    When the apply to each is all done you have an Array, that has all the "Columns and Rows in it" 
     
    Next use Create HTML Outside the loop, using the variable as the input and selecting that it has headers.
     
    If you want custom styling you can see in the first 2 what to do, its not difficult. But how you are doing it now is, I can understand, not working.
     
    P.S. I have no idea what you mean you cannot use the Create HTML outside. When you said you were using append to array, I never suspected you were putting in Table formatting.. you should have shared that initially and explained exactly what you were doing and this hehe would have been my first answer :-) to not do that.
     
    Styling an HTML Table
     
    This is a great example of building it also
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 959

#2
Valantis Profile Picture

Valantis 872

#3
Haque Profile Picture

Haque 589

Last 30 days Overall leaderboard