MS Flow- How to get first 220 characters from excel sheet column when creating a new element in Sharepoint?

[viveka]

Hi,

I'm using a flow for the following senario.

When a new response is submitted by using MS Form, I create a new element in the sharepoint. Look at the attached image. But my flow was failed since the element had characters more than 255. 

 Earlier I used to solve this issue using compose. But after the new relase in last year I cannot find this compose. So I don't know how i can get first 250 charaters from excel sheet before creating the element in Sharepoint.

 Can anyone help me? 😔 

Thanks in advance

[Jcook]

Hello,

When you say you cannot find Compose, what do you mean by that?

You can find compose in the data operations actions.

Power Automate has since updated MS forms. You no longer need a apply to each loop.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[viveka]

Earlier I used following condition in my previous flows..

if(greater(length(outputs('Compose_3')),220),concat(substring(outputs('Compose_3'),0,220),'...'),outputs('Compose_3')).

According to my senario how can I get first 220 characters from excel sheet column when creating a new element in Sharepoint?