Unanswered

Splitting string and performing action for each?

(1) Share

Report

Posted on by Community Power Pla...

I found a question from almost a year ago about splitting a string into and array of substrings.

This was suggested as the solution by yoshihirok and v-micsh-msft:

I have since attempted to set up a flow with identical parameters and it fails, it appears to not be actually splitting the string but

passing the whole input in the compose action. Here's a shot of the error I get.

Is there some sort of formatting error with my JSON? When I set it up to just blast me an email with the output it sends me "@split('Hello #a1',' ')"

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Community Power Pla... on at

Like (2)

Report

Found the problem, JSON has to be encapsulated in " " (double quotations) to actually execute or else it'll be sent as a string.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

having the same problem - where do the double quotes go?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (2)

Report
What worked for me, and be prepared for it to change because flows seems to be changing regularly, is wrap the entire JSON command in quotes. I suspect this is because it is a Key:Value pair to be sent in a REST request to flows backend in Azure.

E.g. (Compose)
"@split('This-String-Will-Split','-')"

and (Compose 2 in applyforeach)

"@item"

But when the flow is saved and run it appears in the edit view as this (Take note that the second output is from the @item output not the first compose.):

So in my case, I was working on enabling notifications to groups in flows rather than just each user. I created a workflow in SP that uses an admin account to check against group members in a given group selected by the user creating a notification. The admin account then adds a temporary entry for each user in the group split by a comma. This is where I use the for each you see. The section in the first compose "triggerBody()?['Group_x003a_Members']?['Value']" gets the linked list I'm using and gets the 'Group_x003a_Members' field containing the list of items to split. I then send a message to each of them and voila! We now have a notification center backend to send reminders to departments and groups.

Hope this helps a little with your endeavours once you see "@split(a,b)" and "@item()" used in a real example. Flows is not quite there yet for most production systems but get your learning in now so you can be ahead of the curve. Feel free to ask me any questions, I don't know much but I'll tell you what I can.

Kind Regard,
ADMCharles.

Was this reply helpful? Yes No
Userofoffice365 6 on at

Like (2)

Report

Hi,thanks, but what if we want to make a different action for each item ?

For example I would like to copy each item in their own excel columns.

thanks !

Was this reply helpful? Yes No