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.
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):
Hope this helps, otherwise let me know I will check again 🙂
Hi @Gaëlle !
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!
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
42 | |
37 | |
36 | |
23 |
User | Count |
---|---|
42 | |
39 | |
30 | |
28 | |
28 |