Answered

Patch into separate rows from a comma separated label

(0) Share

Report

Posted on by jmauras

Hello,
I collect data that is thrown into a label which is separtated by commas.
Example: Blue, Green, Red

I have a Customer Code that I would like to assign to these (Let's say Cust1A). I would like to patch to an existing table so the table ends up looking like this:

Cust1A	Blue
Cust1A	Green
Cust1A	Red

I would appreciate any help. Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jmauras,

You could use the following code (I expect 2 text columns):

Patch( DataSource, ForAll( //Separated by comma and a space Split(Label.Text, ", "), //You can replace "CUST1A" with a dynamic value such as a variable {ColorColumn: Value, CustomerCode: "CUST1A"} ) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
jmauras 20 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LaurensM
Thank you for the quick response.
The code goes in with no errors. However the patch isn't going through to the table. Is just the word "Value" in "ColorColumn: Value" ok?
Patch(GFSCompoundSpecsStaging, ForAll( Split(CRSpecList.Text, ", "), {specifications: Value, compound_code: CmpdCodePull.Text} ) );

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jmauras,

Split() will return the split output as a table with one column named Value. Referencing Value as the specifications column value should suffice if that column expects a text input.

Although using the ForAll within your patch is preferred, we can use try an alternative for troubleshooting purposes:

ForAll( Split(CRSpecList.Text, ", "), Patch( GFSCompoundSpecsStaging, Defaults(GFSCompoundSpecsStaging), {specifications: ThisRecord.Value, compound_code: CmpdCodePull.Text} ) );

Is specifications a text column and are all required columns filled in? During my testing the initial code led to new rows being created within my datasource.

I hope this helps!

Was this reply helpful? Yes No
jmauras 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LaurensM
Those alterations worked perfectly. Just what I needed. Thank you!

0QV A-A-59588
0QV ABS
0QV AMS 3200

Was this reply helpful? Yes No