Query to retrieve all the Form's submission of a Particular BP

replied on April 21, 2020

If you know the BP Instance ID or the Submission ID for a Form process, then yes, you can return the data through Workflow using the Retrieve Business Process task by selecting the Cog in the activity.

The other option is to run a report from Forms where you can export the data from there, otherwise you need a SQL query against the Forms DB if you are able to figure out the table structure

0 0

replied on April 21, 2020 • Show version history

Sorry, regarding the Workflow activity you need to select the Form process and the Fields to be retrieved for this to work. Haven't used this myself so may require some work to flush out.

0 0

replied on April 21, 2020

Thanks Steve. Client is leaning more towards the SQL query method. The current 'workaround' that they have at the moment is running a report in Forms.

0 0

Question

Question

Query to retrieve all the Form's submission of a Particular BP

Replies

Sign in to reply to this post.