PowerFx Left/Right not working on string

(0) Share

Report

Posted on by NeonThunder

Hi there,

I have a date in this format, 20220824

I am trying to convert to a date like 24-08-2022. I can't format as a date as its not valid, so I was trying to split it into dd, MM, yyyy so I can then concat with '-' to get 24-08-2022.

Split doesn't seem to let me choose the amount of characters to count.

Left and right I get the error

Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template function 'left' is not defined or not valid.'.

I am trying

Left('20220823',4)

Left(20220823,4)

Is there a better way of doing this please?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,476 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @NeonThunder,

Below is a list of all the string functions available:

https://docs.microsoft.com/en-gb/azure/logic-apps/workflow-definition-language-functions-reference#string-functions

In your setup I would use the substring function.

substring('<text>', <startIndex>, <length>)

Try:

substring('20220823',0,4)

Was this reply helpful? Yes No
NeonThunder 76 on at

Like (0)

Report
Copy link

Link copied!

Thanks 🙂

Was this reply helpful? Yes No