Need Help adding to a Collection

(0) Share

Report

Posted on by dbro

194

I'm working on an app that is close but I can't figure this last part out:

1.) getting data from my SP list by ID and extracting a column value:

Set(varMaterials, LookUp(
WriteUps,
ID = 37
).materialCollection);

## the raw data from the SP List item column looks like this: CU|234|2.34;NI|211|12.3; ##

2.) On button press I'm getting this data and adding it to a collection. It's adding it in the proper way except for three of the columns (for which I'm splitting data) is getting added as a table inside of my collection. I just want it to appear as plain text.

Code:

Set(varSplitItems,Split(varMaterials,";"));ForAll(varSplitItems,If(!IsBlank(Value),Collect(materialCollection,{Material:First(Split(ThisRecord.Value,"|")),Price:Last(Split(ThisRecord.Value,"|")),Weight:Index(Split(ThisRecord.Value,"|"),2),semiColonVal:";",showEdit: true })));

Can someone help me identify what I'm doing wrong? Thanks!

Categories:

General Questions

materialCollectio...

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 151,883 Most Valuable Professional on at

Like (0)

Report
Re: Need Help adding to a Collection

Hi @dbro ,

Try this for all the code

With( { wMat: Split( LookUp( WriteUps, ID = 37 ).materialCollection, ";" ) }, ForAll( Filter( wMat, !IsBlank(Value) ) As aMat, Collect( materialCollection, { Material: First( Split( aMat.Value, "|" ) ).Value, Price: Last( Split( aMat.Value, "|" ) ).Value, Weight: Index( Split( ThisRecord.Value, "|" ), 2 ).Value, semiColonVal: ";", showEdit: true } ) ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
dbro 194 on at

Like (0)

Report

Re: Need Help adding to a Collection

Thanks for the quick Reply @WarrenBelz . I'll give this a whirl tomorrow and report back.

Was this reply helpful? Yes No
dbro 194 on at

Like (0)

Report

Re: Need Help adding to a Collection

Awesome. TYVM. Worked perfectly.

Was this reply helpful? Yes No