Power Automate

Split a Sharepoint Item into a new row when item contains a semicolon

(0) Share

Report

Posted on by AH-29101912-0

I am trying to create a flow that will do the following

-> When an item is created on a Sharepoint List

-> Get items from "Column A" and "Column B"

-> If text in column A OR Column B contains a ';'

-> Split text and create a new item

I have tried multiple flows; however, I keep getting stuck when setting a variable, getting this error: The variable 'SplitResults' of type 'Array' cannot be initialized or updated with value of type 'String'. The variable 'SplitResults' only supports values of types 'Array'.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

What do you have in Set variable action. Are you using a split expression?

Was this reply helpful? Yes No
Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report
I am not fully understanding your create an item part, but I can show you how to split the values and create an array so you can use it to create the items. Your flow will look like this, and you will need to repeat these actions for both columns.

This is the expression in the condition: contains(outputs('Get_item')?['body/Explanation'],';') and you would replace it with the expression for your column.

To set the array variable, you would use an expression like split(outputs('Get_item')?['body/Explanation'],';').

Then just replace the Compose Create Item action with a Create item action and use the current item if you want to use it for creating the item:

Your expressions will be more like this createArray(split(triggerOutputs()?['body/Explanation'], ';')) based on your trigger. I used a Get item action just to demonstrate this.

Was this reply helpful? Yes No