cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BenDonahue
Continued Contributor
Continued Contributor

String Interpolation Syntax in Flow

I am trying to construct some HTML to create a table to add to an email. I have changed the headers of my Excel table such that data that needs to be added in a row are differentiated by incremental numbers, so RDAudit1, RDAudit2, RDAudit3, and so on. 

 

Here is my best attempt at a string interpolation:

body('Get_a_row_3')?['concat("RDAuditQ",variables("intQCounter"))']
 
I tried using an initial Compose to create the column name, like so:
concat('RDAuditQ',variables('intQCounter'))
This produces the correct column name, RDAuditQ1.
When I plug that in, it returns null. 
 
For further debugging, I tried the vanilla code:
body('Get_a_row_3')?['RDAuditQ1']
This worked just fine.
 
In summation:
intQCounter=1
Compose_-_concat = concat('RDAuditQ',variables('intQCounter')) = RDAudit1
body('Get_a_row_3')?['outputs("Compose_-_concat")'] = null
body('Get_a_row_3')?['RDAuditQ1'] = "Yes"
 
I also tried setting a variable to the value of outputs('Compose_-_concat') and then use that variable in the final expression, but no luck:
body('Get_a_row_3')?['variables("spare")']
 
Thank you for your assistance.
1 ACCEPTED SOLUTION

Accepted Solutions
Yutao
Microsoft
Microsoft

Hi @BenDonahue ,

 

It seems you probably included an extra pair of quotes around the concat expression.

body('Get_a_row_3')?['concat("RDAuditQ",variables("intQCounter"))']

 

This expression worked for me to read the column of `RDAuditQX` from the table:

 

body('Get_a_row')?[concat('RDAuditQ', variables('intQCounter'))]

 

 

Yutao

View solution in original post

3 REPLIES 3
Yutao
Microsoft
Microsoft

Hi @BenDonahue ,

 

It seems you probably included an extra pair of quotes around the concat expression.

body('Get_a_row_3')?['concat("RDAuditQ",variables("intQCounter"))']

 

This expression worked for me to read the column of `RDAuditQX` from the table:

 

body('Get_a_row')?[concat('RDAuditQ', variables('intQCounter'))]

 

 

Yutao

View solution in original post

Erlandcrf
Microsoft
Microsoft

Hello @BenDonahue 

Thanks for bringing your questions to us. What you describe is a very specific scenario, so I will dig more based on the information provided.

I will get back to you on this same thread as soon as I have additional details to share.

 

Thanks.

BenDonahue
Continued Contributor
Continued Contributor

@Yutao ,

 

You are correct, sir. If it weren't for dumb mistakes, I'd make (almost) none at all.

 

Now I can deliver on what I promised.

 

Much thanks!

 

-Ben

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (30,784)