Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Integer field from DevOps not returning in email HTML table

I am working on a simple flow to generate a report once a week, with items still stuck in a triage query in DevOps, and send an email out to requesters reminding them that their request is stuck with the triage mgr's comments on why it is stuck (usually missing data, etc).

In the DevOps template, there is an integer field used as a counter, that defaults to 3 when a new item is created. At the end of my workflow, that counter will be reduced by 1 every week. When it reaches "0", i will cancel the work item, and it will remove itself from the query. 

My plan is to send the email with the query results every Monday to those requesters who created the Work item. The integer will be expressed with a header about how many weeks they have left to fix the ticket before it is cancelled.


The flow is formed like this: 



The Compose expression is the standard for generating a table with borders: 

replace(body('Create_HTML_table'),'<table>','<table border="1">')
When I test the flow up to sending the email, all the fields show up except for the integer field:
Any ideas on how i need to shape it differently for that field to appear in the table in email of body?
Thanks folks.
Community Support
Community Support

Re: Integer field from DevOps not returning in email HTML table

Hi @gmellis1 ,


I assume that the field “Weeks to clear up before canceled” is a custom field of type integer.


I’ve tried to reproduce this issue by adding a custom integer field “Weeks”, however, when I run the query using action Get query results, the custom field won’t appear.


Could you share more details on this part?



PS: when sharing images with us, please remove/hide your personal info, including email address, organization name, etc for security purpose. Thanks for your understanding.


Best regards,




Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (8,542)