cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bscramling
Level: Powered On

ConCat Table Value and Text

Hi all,

 

I have a SharePoint List with columns of (SubPart_1, SubPart_1_Qty, SubPart_1_Desc,...) repeating until (SubPart_15, SubPart_15_Qty, SubPart_15_Desc).

 

I have a collection called "SubNumbers" with one column called 'SubNo' with the values 1 - 15.

 

I am trying to make one ForAll() statement that will create another collection of the SubPart information. Here is what I tried...

ForAll(
    SubNumbers,
    If(
        !IsBlank(
            Concat(SubNumbers,"SubPartNo_" & SubNo)) && sld_QtyRemoved.Value > 0,
        Collect(
            SubPartQtyChanged,
            {
                PartNo: Concat(SubNumbers,"SubPartNo_" & SubNo),
                //PartNo: SubPartNo_1,
                PartDescription: Concat(SubNumbers,"SubPartNo_" & SubNo & "_Desc"),
                QtyOnHand: LookUp('[dbo].[InvUnControlled]',PartNo = Concat(SubNumbers,"SubPartNo_" & SubNo)
).QtyOnHand - Value(Concat(SubNumbers,"SubPartNo_" & SubNo &"_Qty")) } ) ) )

The results are...

 

PartNo = SubPartNo_1SubPartNo_2SubPartNo_3SubPartNo_4SubPartNo_5...
PartDescription = SubPartNo_1_DescSubPartNo_2_DescSubPartNo_3_DescSubPartNo_4_DescSubPartNo_5_Desc...
QtyOnHand = 0

 

Is there a way to use Concat or Concatenate so the result is evaluated as a column name and not straight text?

 

Any help would be appreciated.