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

(1) Share

Report

Posted on by xeniaay_work

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 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.

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.

Thanks!

Xenia

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
xeniaay_work 7 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
NsL Coder 475 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No