cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dlprentice
Resolver II
Resolver II

Only get the first 7 characters of a string?

As part of a flow I am matching to see if part of a string is contained in another. I can usually count on the first 7 characters doing the job.

 

How do I a string regardless of length and only use the first 7 characters of it?

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

As long as the string will always be longer than 7 characters you can use the following to get the first 7 characters.

 

substring(string,0,7)

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

2 REPLIES 2
Pstork1
Dual Super User III
Dual Super User III

As long as the string will always be longer than 7 characters you can use the following to get the first 7 characters.

 

substring(string,0,7)

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

ManishJain
Solution Sage
Solution Sage

Hi @dlprentice ,

 

You can use substring function available in flow. Put the expression as substring('your parameter',0,7) to get the required string.

 

Thanks

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,623)