Azure Logic App slice string from SQL database to email

Question

I have a super simple logic app workflow that triggers when a new row is added to a SQL Server Database and sends an email from a pre-specified address to another pre-specified address with variables from the row that was added.

I am having difficulty figuring out how to slice a string from the SQL data... One of the variables is called "invoiceDate" and I am able to refer to it in the logic app code view as "@{triggerBody()?['invoiceDate']} but an unable to perform slicing functions to it. I only want the first 9 characters of that variable to populate in the email and the slice function does not treat it like a variable.

solved with @{slice(triggerBody()?['invoiceDate'],0,10)}

rpr
– rpr

2022-12-15 01:21:59 +00:00
Commented Dec 15, 2022 at 1:21 — rpr
– rpr, Commented Dec 15, 2022 at 1:21

Skin · Accepted Answer · 2022-12-15 00:04:53Z

0

You need to use the substring expression.

https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#substring

This is a basic example ...

The expression in the second step is ...

substring(variables('String'), 0, 9)

It's getting the first 9 characters of the String variable.

Result

answered Dec 15, 2022 at 0:04

Skin

11.7k3 gold badges16 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rpr Over a year ago

Solved with different solutions, slicing the variable directly... @{slice(triggerBody()?['invoiceDate'],0,10)}

Collectives™ on Stack Overflow

Azure Logic App slice string from SQL database to email

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related