Hi All
I am using Power Automate to complete an electronic review process. There are two main steps to the Power Automate workflow 1) transferring all of the responses to Smartsheet triggering an automated "Update" workflow used for approvals and 2) to insert rows into a Smartsheet based on user responses from a MS Form. For example, the end user answers a question "Yes" or "No" on the MS Form and based on there answer it will generate an predetermined action item (i.e. insert a row) into Smartsheet using conditions. This part works fantastically! I have update a screenshot showing this initial workflow.
However, the issue I am having is during the Smartsheet "Update" review/approval process if a question is changed by the reviewer (e.g., change "No" to "Yes") and that answer would normally trigger an action item, it does nothing because the insert row function is based on the MS Form submission not the Smartsheet update. Smartsheet itself doesn't have a good way that I know of to perform this function automatically and I have posted in the Smartsheet Community as well to no avail. I have been playing with the Power Automate Smartsheet connections, but cant seem to figure it out using Smartsheet as the initial trigger.
Is there a good way to use Smartsheet updates to trigger the insert row function on another sheet within Power Automate? or is there a good way to update/review MS Form submissions? I am not a fan of using the approval flow for MS Forms it doesn't present the data well enough in my opinion.
