Hi all
I am new to nintex workflow cloud. I would like to use values from a specific google sheet to populate a dropdown. I use the data lookup control but when using google sheet connector I can only look up the list of sheets in the google drive rather than the content inside the sheets.
Is there any way I can achieve this?
Thanks.
+8
Hi @yikl,
Unfortunately, there's no way to achieve it natively within the form even by creating an Xtension based on Google Sheets API to get range of values. The response is on format of multi-dimensional array which is not supported in Nintex form not yet. That should be possible with the feature "Form extensibility" coming soon. Now the only way is to implement a payload/middleware to transform that response to Json response format with non-multi-directional array.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.