Split text and create a collection

[HubertWiech]

I need a user to add several rows in a SharePoint list though a Power app.

In the first textbox they enter the Project number (example:19212-1) (1 value)

In the second textbox the copy a text with a separator (example: YV-111;YV-112;YV-113).

I want to split the text and create a collection with the values:

Projektnumer:                                Elementnamn:

19212-1                                          YV-111

19212-1                                          YV-112

19212-1                                          YV-113

And then save the Collection to the SharePoint list.

Thanks for your help.

[StalinPonnusamy]

Hi @HubertWiech 

We need to split the element field and use the Patch command to create multiple

ForAll(
    Split(
        ElementInput.Text,
        ","
    ),
    Patch(
        'EK-YV',
        Defaults('EK-YV'),
        {
            Projektnummer:ProjectNumberInput.Text,
            Elementnamn: Result
        }
    )
)

[eka24 · Accepted solution]

You can follow these steps:

To create the Collection, Insert a button and OnSelect:

ClearCollect(colSplited,{Projektnumer: TextInput1.Text, Elementnamn: Split(TextInput2.Text,";")});

ClearCollect(colSplited2,Ungroup(colSplited,"Elementnamn"))

To Patch to the Datasource, Insert Another button with OnSelect:

ForAll(colSplited2,
Patch(Datasource, Defaults(Datasource),
{Column1: Elementnamn, Column2: Projektnumer} ) )

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel