I have to set a text input with the information obtained from a database query array. How could I implement it?
The text input must contain all the array information inside it.
Thanks!
Looks like you need to use the join formatter.
How would you join this:
I need to get the text value from each item.
This is how I can get the first item:
productos.valueArray[0].valueObject.detalle.text
And the rest of the items?
So you need to join value from first index of valueArray in each row of parent array producto?
Also, is producto here the query?
Yes, though producto isn’t the array
valueArray in the example given retrieves me each text from detalle’s first [0] text index. But I need all valueArray indexes (7 in this example)
If I use the join operator like this: queryObtenerComprobanteIA.data.FormRecognizer.data.analyzeResult.documentResults[0].fields.productos.valueArray.join('-')" I get the image below and I need to get the data inside each of those [object Object]
I’ve tried setting the join operator like this: queryObtenerComprobanteIA.data.FormRecognizer.data.analyzeResult.documentResults[0].fields.productos.valueArray.join('-').valueObject.detalle.text (adding the .valueObject.detalle.text at the end of it) but of course it won’t work
Solved:
I used flow and created a repeated action where each item was added to a client side array.
Then used the join parameter to set the input value separated by ’ - '.
Thank you!!
2 Likes