cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
viveka
Frequent Visitor

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

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

 

5.PNG

 

 

 

 

2 REPLIES 2
Jcook
Super User
Super User

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

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





viveka
Frequent Visitor

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?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,274)