How to AddColumns() to this

(0) Share

Report

Posted on by martinav

3,347

I'm not getting this to work. Whats the deal?

Distinct(
 ForAll(Split((ThisItem.SN_List_FFName),",").Value As varWO,
 With({varWOForAll: cmp_SN_Text_Functions.WO_SearchBySN_Exact(varWO.Value).WorkOrderOB},
 If(IsBlank(varWOForAll),"NoWO",varWOForAll))),
 Value)

This results in a list ["1234-2","4321-2","2142-3"]

I want to make this into this:

[{WorkorderOB:"1234-2",WorkOrder:1234,LineNumber:2},

{WorkorderOB:"4321-2",WorkOrder:4321,LineNumber:2},

{WorkorderOB:"2142-3",WorkOrder:2142,LineNumber:3}]

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
you have some custom functions in there i thnk? so i cant exactly mimic your setup, but using the data RETURNED, this will sepearate it into the format you wanted, so should be able to reverse engineer this

ClearCollect(testMe, ForAll( Split("1234-2,4321-2,2142-3",",") As stepGuide, {WorkorderOB:stepGuide.Value, WorkOrder:First(Split(stepGuide.Value,"-")).Value, LineNumber:Last(Split(stepGuide.Value,"-")).Value} ))