Power Automate - Create Report - WHERE Clause based on field

ModernElectric

I am at a point that I am stuck and cannot figure out the syntax. I am sure it is really simple, but I am not seeing it.

Power Automate - Create Report - Feature WHERE clause:

Need to tell the tool to only create a report when the field warehouse_complete = 'COMPLETE' 

I have this form as a part of an in-box setting, so multiple crew members update the form and only needs to be printed/PDF creation after the warehouse pulls the inventory and updates the QTY issued. 

Thank You

TylerGraham2

https://learn.microsoft.com/en-us/connectors/arcgis/#create-report

It is SQL syntax for the where clauses, I'm not a SQL expert by any stretch of the imagination but that looks like a valid query.  That being said, my understanding of the Create report action is that with the query it may try to create a report for all records that match warehouse_complete = 'COMPLETE' rather than create a single report. 

It looks like you're passing a feature object id dynamically already.  If that is coming from When a Survey Response is Submitted Trigger and you only want it to create a report when warehouse_complete='Complete' for just the submitted response, you should add a True/False condition and put the create report and related steps in the true column.  I think it is a better workflow, and rather than trying to run the action and possibly getting an error in the action if there isn't a match, you check beforehand using the condition and direct the flow's actions based on the true/false condition check.  e.g. If warehouse_complete=complete is true, run create report and the other steps.  If warehouse_complete=complete is false, run other steps, like send a message that the inventory has been updated but isn't completed yet.