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()?['ColumnName']),'',triggerOutputs()?['ColumnName']) but I now get this error when triggering the flow: The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.'. Any insight as to the error and if my expression is incorrect?

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'])

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

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.

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.

Have you selected your data in the visual, when configuring the button visual? Did you also configure the flow from the Power BI interface? I am asking because of the below limitation:Create flows that you will use with the Power BI button trigger directly within the Power BI report. Avoid going directly to Power Automate to create these flows, as the trigger will not have access to the data fields necessary for creating the flow.https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-automate-visual?tabs=powerbi-service#considerations-and-limitations And you are also testing it from Power BI, correct?You can only run these Power BI flows within the context of a Power BI report. You can't start flows from the Power Automate portalhttps://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-automate-visual?tabs=powerbi-service#test-the-flow

Automate Flow adding rows to table trigger failed

11 Replies

Expiscornovus
Most 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
  Helper IV
  1 year ago
  It is a manual trigger. I tried your suggestion, still get the same error.
  - Expiscornovus
    Most 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
  Helper 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
unknown917
Helper IV
1 year ago

Allow me to better explain the situation. The columns I'm exporting inevitably will have null values at the row level. They are text columns, so I don't want to have a zero replacing the null or empty cell. I made the assumption that the flow failed because of this.
Anonymous
Not applicable
1 year ago
Hi unknown917 ,

For this error message "The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.", I would recommend removing and re-adding the trigger to help determine if the issue persists.

Best Regards,

Bof

Forum Discussion

Automate Flow adding rows to table trigger failed

11 Replies

Related content

Trigger Automation

PowerBI Trigger - Power Automate

Storage trigger event

Automated refreshes

Triggering Alert when Data is added