I have an Excel file that contains various Form Controls, such as buttons, checkboxes, and drop-down lists. I need to read the values and states of these Form Controls programmatically using either Power Automate or Office Scripts in an online environment. However, I am unsure about the proper way to access and retrieve the information from these controls. I would like to know the specific steps or methods required to read the Form Control values using these tools.

I tried searching for documentation and examples related to reading Form Controls using Power Automate and Office Scripts, but I couldn’t find any clear or comprehensive solutions. I expected to find a straightforward way to access the Form Controls and retrieve their values, similar to how I would do it using VBA in a desktop environment. However, the online tools seem to have different approaches, and I am unsure about the correct syntax or methods to use. I would appreciate any guidance or code samples that demonstrate how to read Form Controls effectively using either Power Automate or Office Scripts in an online Excel environment.