I Configured a Drop-down to show a column in my SharePoint list, however, when going to preview and Testing it shows “No-Options” even though there is text in the column. I checked the below -
- Re-Built connection separately.
- Checked data type in SharePoint Column (Matches other working columns - Text).
- Re-built the drop-down as a Data Lookup (The data lookup shows the text is there).
The only difference between this column and others is that there is more text separated by commas than the other columns. Tried increasing the size of the Dropdown to see if it was a “Character” issue. Nothing shows up even for the short text (e.g. 4-5 Characters long).