Power Automate - Create Report - WHERE Clause based on field
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
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.
