Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Html Table grabs the t...
Power Automate - Building Flows
Unanswered

Html Table grabs the text but not the numbers in the numeric columns from an Excel table

(1) ShareShare
ReportReport
Posted on by xeniaay_work 7

Hi

 

I have a flow to read an Excel table as input and then create a Html Table and send it out by email.  The test run is always successful but the email output shows blank for the numbers in the numeric columns from the Excel table.  Those numbers are formatted as number in Excel cells.  I checked back on the test run; the Input can read the numbers in the numeric columns from the Excel table, but the Output for those numeric columns are all blank.  Then I tried to change the Format of one of the numeric columns in the "Create HTML Table" action but it still doesn't pick up the number in integer.  

 

Can anyone give me some clue on what's wrong?  Is it relating to the HTML Table formatting?  The flow can read text; just not the numbers.

 

Screenshot 1

Start of the flowStart of the flow

 

Screenshot 2 - tried to format as number in the "Create HTML table" action

Tried to format number in one of the numeric fiields but the result is the same.Tried to format number in one of the numeric fiields but the result is the same.

 

Screenshot 3 - Test run result - Outputs are blank for number columns where they should have the integers.  Inputs show the numbers in integer.

The test shows input is with the numbers for the numeric columns but the output is all blank.The test shows input is with the numbers for the numeric columns but the output is all blank.

 

Thanks!

 

Xenia

  • NsL Coder Profile Picture
    NsL Coder 469 Super User 2025 Season 1 on at
    Html Table grabs the text but not the numbers in the numeric columns from an Excel table
    I notice that in your Create HTML table action, you are using ^ as the separator character that I'm going to assume you are replacing in your output to a "space" character.
     
    This is a bug in my opinion with Power Automate, but you can use normal space in the Header side of the Create HTML table action, while you cannot type it, you can type "Resource Manager" in notepad, and copy it, then paste into the Header field, and it will have the space character you wanted.
  • xeniaay_work Profile Picture
    xeniaay_work 7 on at
    Html Table grabs the text but not the numbers in the numeric columns from an Excel table
    Hi @FLMike
     
    Thanks for your comment.  Actually I've revised the expression to the one highlighted in yellow below and it works now.
     
    Best regards
     
    Xenia
  • Michael E. Gernaey Profile Picture
    Michael E. Gernaey 43,220 Super User 2025 Season 1 on at
    Html Table grabs the text but not the numbers in the numeric columns from an Excel table
    Hi,
     
    Its a little hard for me to read your If statement, however, it looks like you are saying if its empty, then takes it value.. but the value was blank, so your true should not be using the value, you just checked was blank.
     

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

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans