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 / Hi , i wanted to displ...
Power Automate
Answered

Hi , i wanted to display a table inside email in my flow but a have a field satus1, satus2 field with value open completed , i wanted to show fields in table only when their value is completed

(0) ShareShare
ReportReport
Posted on by 127

, Hi , i wanted to display a table inside email in my flow but a have a field name satus1, satus2 with value open, completed , i wanted to show fields in table only when their value is completed,

is their any way

Categories:
  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @Ali123 

     

    Could you share how data looks like ?

  • SimnaJ Profile Picture
    205 on at

    you can use the "Create HTML table" action to create an HTML table from your data and then use the "Create HTML" action to convert the HTML table into an HTML formatted string. You can then insert this HTML formatted string into the body of your email using the "Send an email" action.

    Regarding your second question, you can use the "Filter array" action to filter out the rows where the "status" field does not have the value "completed". Then you can use the "Create HTML table" action to create an HTML table from the filtered data and insert it into the email body using the "Create HTML" and "Send an email" actions.

     

  • Ali123 Profile Picture
    127 on at

    but how to create array with sharepoint fields satatus1 and satutus2 and filter it

     

  • Ali123 Profile Picture
    127 on at

    data is sharepoint list with fields like satutus1 and satutus2 dropdwon fields

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @Ali123 

     

    To confirm, you want the items where satutus1 is completed or satutus2 is completed , am i right ?

  • Ali123 Profile Picture
    127 on at

    i wanted a html table to send it in email from sharepoint list with fields as status1 and status2 as shown below

    table 
    fieldvalue
    Status1completed
    status2open

     

    i wanted to show table like below,

    table 
    fieldvalue
    Status1completed
  • Ali123 Profile Picture
    127 on at

    can you show one sample from sharepoint list field

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @Ali123 

     

    Does you data looks like this ?

     

    Nived_Nambiar_0-1681491541692.png

     

     

  • Ali123 Profile Picture
    127 on at

    That's correct 

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    I am little confused how the table in email should look like if the list has two items in it ?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 389

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard