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 12,982 Super User 2025 Season 2 on at

Like (2)

Report

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

Now, how about that!

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

Was this reply helpful? Yes No
Chriddle 8,443 Super User 2025 Season 2 on at

Like (0)

Report

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