To get the status of "cancelled" to show on your response sheet, you will need to include a branch in your Power Automate flow that handles cancelled requests.
Here is an example of how you could set this up:
- Add a "Switch" action after the "When a new response is submitted" trigger.
- In the "Switch" action, create a case for each possible status (e.g. "Approved", "Rejected", "Cancelled").
- For the "Cancelled" case, add an "Update response" action that sets the status to "Cancelled" in the response sheet.
This way, when a request is cancelled, the flow will follow the "Cancelled" case and update the response sheet with the correct status.
