Unanswered

HTML Table Azure DevOps amending values each time

(0) Share

Report

Posted on by taylorjames

Hello all,

I'm trying to use Get Query and output the values into an HTML table to send via email as below:

The only problem is every time I send the flow and leave it after saving, the items have changed format and no longer output the information.
e.g.
item()?['System.Title']
becomes
item()?['System']?['Title']

I attempted to wrap them in a string function but the same thing happens they look like this when it next sends whether manually or via the automation.

system.title.png

Does anyone know a way to prevent this from happening?

Thanks for your help.

James

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report
Hi @taylorjames ,

Commonly speaking in our use if we want to quote a column as a dynamic content (say "title" is the column name), we will write it as

item()?['System']?['Title']

or

item()?['System/Title']

They will return the same result.

I'm wonder how's your date source outputs look like? Is "System.Title" a column name or not?

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Verified answer

taylorjames 9 on at

Like (0)

Report

Hi @v-wenjuan-msft,

Thanks for getting back to me.

I managed to ensure it stayed fixed by wrapping item()?['System.Title'] and the other dynamic content in an if(empty(),,) clause.

To answer your question:

The output from the 'Get query results' is:

Even the raw inputs into the HTML Table when it's item()?['System']?['Title'] is:
"System.Title": "Weekly / Monthly Email Updates"

Not sure why it's converting it each time or why it's inputting it correctly in the raw inputs and then not outputting it.

Thanks for your help.
Taylor 🙂

Was this reply helpful? Yes No