cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Getting SP items and split each item's string

Hello there !

I've seen a lot of solutions for splitting string and then applying foreach, but i haven't seen the way around.

Explanations :

I'm getting ItemS from Sharepoint (depending on their departure date), and for each of them, I have a string called PassengersMails, which is like the following : "email1@XXX.com;email2.XXX.com;email3.XXX.com".

i already have a foreach on the Value of GetItems.

In it, i already have a condition on If PassengersMails is empty.

Now in the No of the condition, i would like to split the PassengersMails string to an array. For each item in this array, I want to retrieve the Passenger's Display Name (using a O365Users connection) and to store it in a new string.

 

I can't figure out how to proceed.

How to split a string from a foreach Value ?

 

Thanks a lot, have a nice day.

5 REPLIES 5
Willemijn
Resolver III
Resolver III

Hi!

 

If you have a common delimiter you could use the split expression maybe? 

I have tested it wit a variable with two e-mailadresses in it, and then an apply to each where the input is the splitted version of that variable (for you it's your string from your previous action):

image.png

 

Hope this helps, otherwise let me know I will check again 🙂

Willemijn
Resolver III
Resolver III

Hi @Anonymous !

 

Did this solve your problem, or do you need any other help? 

Otherwise could you mark the answer as solution?

 

Regards,

Willemijn

Hi @Willemijn , how do I traverse the string using built-in API's in MS Flow?

 

Apologies as I'm very new to this..

Right now, what I can do is use the first() and last() functions, but this limits me to only 2 inputs..

I want to get the values per index such as..

 

name = splitString[0];

address = splitString[1];

Hi, 

 

Do you have an example with sample data of the string you would want to split and what the expected outcome is? 

Then I can take a look.

 

Willemijn

Thank you for the quick reply..

 

I will try this first.

https://powerusers.microsoft.com/t5/Building-Flows/Accessing-Array-elements/m-p/62508#M5787

 

I think this is what I need. I'll get back when I'm stuck..

 

Thanks again!

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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,103)