I am querying a spreadsheet containing the data I need. When using the editor, the dropdown shows the list, but when using the public view, it doesn't load the list and showing an empty box only.
This was working three days ago, but suddenly stopped loading the values when using the public view.
Also I already tried to recreate the component (not duplicating it) but still have the same issue.