MS Flow- How to get first 220 characters from excel sheet column when creating a new element in Sharepoint?
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.