Hello, as a workaround for not having a bespoke method for reading data from Excel or a SharePoint List in a public form, I am using a Dropdown field linked to Excel. The worksheet has a single column of JSON-encoded strings, from which I create an array of objects in the form.
Right now, I can build this array if I wait a bit of time (5 seconds or so) for the dropdown list to populate after form loads, then the data is usually there... But the duration would be highly non-deterministic, I imagine.
Is there a way to synchronously force a dropdown field to refresh its data so that I can be sure the data exists before trying to construct my object array?
Thank you in advance for any assistance.
Edit: or alternatively and better, to register an asynchronous callback function to be called when the data is filled?
Edit 2: I "solved" this by writing an interval function that repeats a check every half second until the data is loaded... It would still be nice to know if there was any other method.