You can prevent a Forms answer like “Remove access” from being written to SharePoint. You just need to explicitly replace that value with null (or an empty string) before writing to the list. Right now, your logic is checking for empty, but “Remove access” is not empty, so it still gets saved.
What’s going wrong
Microsoft Forms always returns the selected value, even if it’s only meant for branching
Your expression:
empty(...)
only handles null/blank, not specific values like "Remove access"
As a result, the list column still receives the response
Correct solution
Option 1: Replace a specific value with null (recommended)
Use this expression when mapping the SharePoint column:
if( equals(outputs('Get_response_details')?['body/r7df596b3349b4397b3ba316333d62f0a'], 'Remove Access'), null,
outputs('Get_response_details')?['body/r7df596b3349b4397b3ba316333d62f0a'])
If user selects Remove Access → nothing is written
If user selects a location → it is saved normally
Option 2: Exclude both null and “Remove Access”
If the answer can be blank or “Remove Access”:
if( or( empty(outputs('Get_response_details0a']), equals(outputs('Get_response_details')?
['body/r7df596b3349b4397b3ba316333d62f0a'], 'Remove Access') ), null, outputs('Get_response_details')?
['body/r7df596b3349b4397b3ba316333d62f0a'])
Best practice tip (important)
If a Forms question is only for branching logic:
- Do not map it directly to SharePoint
- Use it only in Conditions
- Write a cleaned/derived value to your list instead
This keeps lists readable and avoids “control answers” like Remove Access leaking into data.
✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.
