Deactivate option if selected once

[ahblake]

I've made a separate post that contains an example of hiding options once selected and submitted, and also updates the definition using power query to add status emojis

A self-updating form using Power Query in Excel

I will preface this by saying that I don't believe it's an elegant method by any stretch, but it might be helpful for those who author forms in Excel and can't use the API to automatically update them. As long as your version of Excel supports Power Query with OData as a data source and your formula calculation option is automatic it will work. Self_Updating_Form.xlsx (40.7 KB) In this example query I have simply returned all values and added a column that populates with an emoji for the item …