Answered

Substring outputs - first characters

(0) Share

Report

Posted on by NA-24101339-0

Hi. (noob alert)

I'm working on a flow moving data from a Microsoft Form via Excel to Planner Tasks.

One challenge is that the form does not have a specific "Title" field. I want to fill the title of the task with the first 30 characters from available dynamic content.

When using this expression: substring(outputs('description'),0,30)

I get the firt 30 characters as the title. But in the case there was less than 30 characters available the flow does not work.

How does a working expression look like?
I'd like to populate the "Title" field in Planner with any text available, but not more than 30 characters

Categories:

Process Advisor

All responses (3)

Answers (1)

Chriddle 7,371 on at

Like (0)

Report

Substring outputs - first characters

Check function slice()

If endIndex isn't specified or greater than the string length, search up to the end of the string.
NA-24101339-0 4 on at

Like (1)

Report

Substring outputs - first characters

Now, how about that!

Silky and buttery smooth. Thank you so much, David MA.
Verified answer

David_MA 9,039 on at

Like (2)

Report

Substring outputs - first characters

Try using this expression instead: if(lessOrEquals(length(outputs('description')), 29), outputs('description'), substring(outputs('description'), 0, 30))