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:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

David_MA 13,491 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
NA-24101339-0 4 on at

Like (1)

Report
Copy link

Link copied!

Now, how about that!

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

Was this reply helpful? Yes No
Chriddle 8,525 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Check function slice()

If endIndex isn't specified or greater than the string length, search up to the end of the string.

Was this reply helpful? Yes No