Forum Discussion

primolee's avatar
primolee
Icon for Helper V rankHelper V
6 years ago
Solved

Record.Field Error

Hello everyone,   I want to use the value in column M1 as column name and extract the value in that column.   = Table.AddColumn(#"Previous Step", "Custom", each if ([M1]=null) then [Cue Final Ke...
Need Help
  • primolee's avatar
    primolee
    6 years ago

    Somehow it is not a stable function...

     

    My solution is to add a new column with Record.FieldNames(_), then add the next new column using the above code, it will work with 2 steps...

     

    I guess you "sometimes" need to let the system get all column names in a list first, or else the system will not recognize all column names.  Sometimes you don't need it, sometimes you do.

     

    Hopefully Microsoft can look into this. 😞

primolee's avatar
primolee
Icon for Helper V rankHelper V
6 years ago

Hello v-juanli-msft ,

 

Thanks for your reply.  Unfortunately, I only need the value of the field corresponding to the same row, this is why I use Record.Field(_, [M1]), _ underscore sign instead of #"Previous Step".

 

I have found somewhat a solution just right before your reply.

 

Sometimes it works just with Record.Field(_, [M1]), sometimes I need to create a new column using Record.FieldNames(_) first then another new column with Record.Field(_,[M1]) in order to recognize all field names.  This is very strange, but anyway... (>_<)

 

Thank you for the help!

 

Best regards,

David