Forum Discussion

Mic1979's avatar
Mic1979
Post Partisan
1 year ago
Solved

null input parameters custom function

Dear all,   I have the following custom function:   ( Input_Table as table, Adder_Table as table,  Input_Table_Column1 as text, Input_Table_Column2 as text, Input_Table_Column3 as text, Input...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Mic1979 
    could you please provide sample of your tables?

     

ZhangKun's avatar
ZhangKun
Super User
1 year ago

If you want to pass null to Input_Table_Column4, you should modify it with the optional keyword, such as (optional a)=>...

Also, Record.Field(_, Input_Table_Column4) should be replaced with Record.Field(_, Input_Table_Column4 ?? default_value_if_null).

  • dufoq3's avatar
    dufoq3
    Community Champion
    1 year ago

    Hi Mic1979, as ZhangKun mentioned: you should use optional keyword, but keep in mind that all optional parameter have to be at the end!. BTW. indstead of Record.Field(_, Input_Table_Column4 ?? default_value_if_null) you can use Record.FieldOrDefault(_, Input_Table_Column4, default_value_if_null)

    • Mic1979's avatar
      Mic1979
      Post Partisan
      1 year ago

      Hello dufoq3 

       

      Thanks, but why when I invoke the function in this way:

      let
      Source = MergeLP_3(Total_Sales_DOLLARS_TEST, PCBA_Type_List_Price_Adder, "Region", "Project_Step", "Fail_Safe_Description", null, null, null, "Region", "Project_Step", "Fail_Safe_Description", null, null, null, "Adder")
      in
      Source

       

      I get this:

       

       

      • dufoq3's avatar
        dufoq3
        Community Champion
        1 year ago

        Because you haven't used optional keyword i.e.:

        (tbl1 as table, tbl2 as table, optional col1 as text, optional col2 as text)=>

         

        And again:

        1. optional parameters have to be defined last.
        2. my recommendation: do not use custom functions. You do not need them in 99% of tasks.