cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cholst
Advocate I
Advocate I

Get Value (s) from text string

We have a text string that i receive inside of Flow as listed below. This string could contain any number of @ mentions. I want to take this string and pull out each GUID, after the @[8,. I would then want to take an action on each of these GUIDs. The GUID's could be anywhere in the string as well. Is this possible? If so, any help would be very appreciated. I was able to get the 1st GUID regardless of where is was located in the text string but when it came to finding all GUID's i got lost. 

 

@[8,0CF25058-55D2-E811-8145-5065F38B02E1,"Jane Doe"] @[8,033D8C19-0EEB-E711-810E-5065F38B02E1,"John Smith"] What does this look like when the text is added to a note?

1 ACCEPTED SOLUTION

Accepted Solutions
yashag2255
Dual Super User II
Dual Super User II

Hi @cholst 

 

Assuming that you just want the GUIDs, once you have the individual split items, you can add an apply to each loop and select the array for value and in the loop, add a compose action and use the expression first(split(items('Apply_to_each'),',')). You should now get the each individual GUID. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

3 REPLIES 3
yashag2255
Dual Super User II
Dual Super User II

Hi @cholst 

 

You can use the split function to split on the @ and then get each guid. So if the entire string is in a variable called var1, intialize a variable of type array and in the value, use the expression split(variables('var1'),'@') this will give you each individual guid split on the @ as an individual item in the form of an array and you can then perform actions on each individual item. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

I got it split on the @ but still not isolating the GUIDs. My knowledge of manipulating the text is very limited.

Annotation 2020-03-07 130547.png

 

[
  "",
  "[8,033D8C19-0EEB-E711-810E-5065F38B02E1,\"Jane Doe\"] do you know if ",
  "[8,0CF25058-55D2-E811-8145-5065F38B02E1,\"John Smith\"] will have the answers i want?"
]

 

 

 
yashag2255
Dual Super User II
Dual Super User II

Hi @cholst 

 

Assuming that you just want the GUIDs, once you have the individual split items, you can add an apply to each loop and select the array for value and in the loop, add a compose action and use the expression first(split(items('Apply_to_each'),',')). You should now get the each individual GUID. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,353)