json - Set string variable to dynamic list column value gives error: Input parameter of operation Set Variable contains invalid

Simplest of actions.... Had a string type variable Initialized then Set to a string with a bunch of html tags and with dynamic list column value inserted in between.

Flow gives the error upon save "The input parameter(s) of operation 'Set_Email_Body_variable' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Set_Email_Body_variable'."

Tried with

string(outputs('Get_item')?['body/ReferenceNo'])

doesn't budge. will appreciate some quick pointers! Thanks!

Simplest of actions.... Had a string type variable Initialized then Set to a string with a bunch of html tags and with dynamic list column value inserted in between.

Flow gives the error upon save "The input parameter(s) of operation 'Set_Email_Body_variable' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Set_Email_Body_variable'."

Tried with

string(outputs('Get_item')?['body/ReferenceNo'])

doesn't budge. will appreciate some quick pointers! Thanks!

• json
• sharepoint
• power-automate
• powerapps
• power-automate-desktop

Share Improve this question Follow asked Jan 30 at 18:02 akg1421akg1421 551414 bronze badges 4

• did you try copying the same in a compose (which accepts numerous datatypes) and add it's output to email body – Laviza Falak Naz Commented Jan 31 at 7:23
• @LavizaFalakNaz compose produces same error. Can you please reproduce some of this to check at your end.. will really appreciate help – akg1421 Commented Jan 31 at 9:39
• I cannot reproduce without the inputs. Please share both inputs (email body and the reference number value) – Laviza Falak Naz Commented Jan 31 at 12:56
• @LavizaFalakNaz Laviza It got resolved by storing parts of HTML in different string variables then combining them with Compose using Concat with respective dynamic column values. HTML is any simple html body, your could try the <table> and Reference no was numeric. – akg1421 Commented Feb 3 at 5:36

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

Resolved by combining parts of HTML by storing them in different string variables > Initialize Variable Action

These variables then combined in Compose along with respective dynamic column values using Concat

concat(variablehtml1, SPCol1, variablehtml2, SPCol2)