How retrieve Compose output to insert into HTML table?

[BonnieStar]

I've worked on this for days and still can't seem to figure this out..  I have a flow that gets the properties from files in a SharePoint document library. I then have certain columns (metadata) inserted into an html table within an email.  For my one calculated column ("Aging (Days)"), I first use two Compose actions within an Apply to Each to remove the decimal places and trailing zeroes.  What I can't seem to figure out is how do I now collect the resulting output from the Compose to include in my html table?  When I test the flow, I can see that the output is correct, so now how do I get it in the html table?

I wish it was as simple as inserting "outputs('Composeint')" into the table....

[fchopo]

Hi @BonnieStar 

You could delete the "apply to each" action, and in the Days_Awaiting_Approval column (create HTML table) use the following expression:

int(empty(item()['Aging (Days)'],'0'))

1) Check whether 'Aging (Days)' column is null or not (if it is, then use '0').

2) Convert value to integer.

Hope it helps!

Ferran

[BonnieStar]

Unfortunately, my column "Aging (Days)" is not available to select under Dynamic Content.  Only two choices are "body" and "value."

[fchopo]

Hi @BonnieStar 

Please, write the expression using the "Expression" tab, and not in the "Dynamic content" one.

Hope it helps!

Ferran

[BonnieStar]

[BonnieStar]

I replaced ['Aging (Days)'] with ['Aging_x0020__x0028_Days_x0029_'], but then got this error:

[BonnieStar]

Here's what I currently have:

[fchopo · Accepted solution]

Sorry, I made a mistake on the expression. It should be the following:

Int(if(empty(item()? ['Aging (Days)']), '0',item()?['Aging (Days)'])

Hope it helps now.

Ferran 

[BonnieStar]

I'm blown away.  That worked!!  FINALLY!!!!!!!!!!!  Thank you infinitely!