Answered

Unable to split text with semicolon

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Everyone,

I have a text column in SharePoint with content saving it as "test;testing" something like this and I want PowerAutomate to split the text based up on semicolon and run " apply to each" for each word which was split. I am not sure if I am using right steps or not.

example: 1. For a selected Item

2. Get Item

3. Compose -split(body('Get_item')?['location'], ';') --- Here I am trying to split words into two, example into test and testing

4. Apply to each - output of compose

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

rsaikrishna

3,703 Microsoft Employee on at

Like (0)

Report

Copy link

Link copied!

@Anonymous

1. For a selected Item

2. Initialize an array variable varArray and leave the blank value

3. Get Item

4. Set variable action - varArray with split(body('Get_item')?['location'], ';')

5. Apply to each - output of varArray

Expression I used to set variable:

split(variables('varInput'),';')

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Was this reply helpful? Yes No

mkumagai167 12 on at

Like (0)

Report
Copy link

Link copied!

@rsaikrishna
I'm trying to do the similar thing, but I got an error at Set Variable.

Expression is
split(body('Get_items')?['Before'],';')
Do you have any idea what I'm missing? Thank you!

Mari

Was this reply helpful? Yes No