Hello there !
I've seen a lot of solutions for splitting string and then applying foreach, but i haven't seen the way around.
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.
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 🙂
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;
address = splitString;
Thank you for the quick reply..
I will try this first.
I think this is what I need. I'll get back when I'm stuck..
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021
Fill out a quick form to claim your user group badge now!