Forum Discussion

unknown917's avatar
unknown917
Icon for Helper IV rankHelper IV
1 year ago

Automate Flow adding rows to table trigger failed

I have a flow set up to add rows to a table.  I received an error for null values when adding rows.  I attempted adding the following expression to account for nulls:   if(empty(triggerOutputs()?[...
Need Help
Tips and Tricks
Expiscornovus's avatar
Expiscornovus
Icon for Most Valuable Professional rankMost Valuable Professional
1 year ago

Hi unknown917,

 

Which trigger action are you using? Can you share a screenshot of your flow setup?

 

If this an action in the middle of flow you would normally use the item() function (in an apply to each loop) instead of a reference to the trigger action.

 

So, it might be the case that you want to use that function instead:

 

if(empty(item()?['ColumnName']),'',item()?['ColumnName'])

 

 

  • unknown917's avatar
    unknown917
    Icon for Helper IV rankHelper IV
    1 year ago

    It is a manual trigger.  I tried your suggestion, still get the same error.

     

     

    • Expiscornovus's avatar
      Expiscornovus
      Icon for Most Valuable Professional rankMost Valuable Professional
      1 year ago

      Hi unknown917,

       

      Are you using the below in the Select an output from previous steps field of the Apply to each action?

       

      triggerBody()?['entity']?['Power BI values']

       

       

      Can you also inspect the outputs of the On Power BI button clicked trigger action of your flow run to see what the structure is and if it contains any data at all?

       

      Just want to see what the names of your columns are and it it actually contains the data.

       

      • unknown917's avatar
        unknown917
        Icon for Helper IV rankHelper IV
        1 year ago

        Yes, I am using the 

        triggerBody()?['entity']?['Power BI values']

         as for the Outputs, there are none. The input does show the columns names, though.

  • unknown917's avatar
    unknown917
    Icon for Helper IV rankHelper IV
    1 year ago

    I am finding now that the function results in omitting the entire row from being added to the table.  Even if there is nothing in the column, I still need the row to populate with data from the other columns