Not able to get UNIQUE values in dropdown, where data is coming from external API

Hi All
I am trying to achieve UNIQUE values in dropdown, where source of data is an external API (like Google Sheets, etc).
and I want the dropdown to only display unique values irrespective of repetition in the source data.

You problably need to set your Data type as “Text” (I guess actually it’s set to the API Type), select the text field from the Get data API value and use :unique value

Thanks @Jici for your response. Much appreciated.

I did few changes and it worked !!

Thank you once again.

1 Like