I have a SharePoint online list that will be populated with data from a Form (MS Forms) via Power Automate. I have some choice (single select, multi-select and yes/no) fields in the form, but before I build my list and import Flows I want to make sure I'm not getting myself into a dead end.
For example, I know that I can't reference a choice field in a lookup in SharePoint. So, if I want to do any lookups, I need the data to be imported as a single line of text, or create a calculated field in the background (which is a bit of a pain).
I also know that if I want the field to be editable once it's in the list, I won't be able to retain that structured data integrity if I use a text field instead of a choice field, so if users are going to be editing the data, it's important that it's a choice column in SharePoint.
Are there other "gotchas" that I should keep in mind, especially in terms of either conditional formatting (JSON) or being used as a trigger in a Power Automate flow?