web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Split text and create ...

Power Apps

Answered

Split text and create a collection

(0) Share

Report

Report

Posted on by HubertWiech

13

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.

Pic 2.png

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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 } ) )

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation