cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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: 

Capture.PNG

 

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:
Capture2.PNG
 
Any ideas on how i need to shape it differently for that field to appear in the table in email of body?
 
Thanks folks.
 
1 REPLY 1
Highlighted
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?

1.PNG

 

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,

Mabel

 

 

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

Announcements
firstImage

Now Live: Power Virtual Agents Community!

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

firstImage

New & Improved Power Automate Community Cookbook

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

thirdimage

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)