Storing current queue item in PV

so if I understand this correctly, you need to iterate over a few forms (which I hope it has the same data type) and collect data from all of them, then display the data that was collected off of these forms in one interface.

If you do use one datatype, then you could create an array that contains an index for each of the forms that needs to be sent, and as Stefan said, you can create a PV counter and use that counter to save each form data in the correct index of the array I mentioned earlier, then when you want to display the data, you can just iterate over the array of form data that you have and display it how ever you see fit.

best of luck

so if I understand this correctly, you need to iterate over a few forms (which I hope it has the same data type) and collect data from all of them, then display the data that was collected off of these forms in one interface.

If you do use one datatype, then you could create an array that contains an index for each of the forms that needs to be sent, and as Stefan said, you can create a PV counter and use that counter to save each form data in the correct index of the array I mentioned earlier, then when you want to display the data, you can just iterate over the array of form data that you have and display it how ever you see fit.

best of luck

Thanks for the suggestions Stefan and Ahmad.   have an excel file with 1000 rows and 5 columns and we need to do a data entry to a system through browser. we have PV for each column and will need to save the row values (5 column) in to these PV's. 

my point still stands, you need an obj (or a CDT in this case) which has 5 attributes for your 5 columns in the excel sheet, and you need to read those columns and append them to the array of that same CDT you created earlier.

Thanks for the quick response. Question is more towards how to implement it. how do we achieve saving the queue values in PV? can java code set values on a PV or is there a low code module available to store the value? Please share examples

I'm able to access the values using currentItemQueue.functionalData() on a method written to access this data, but not sure how to store this in a PV.

we could think of 2 solutions at this point.

1. Use an Appian process to read excel and call a robot with process variables in it iteratively. From the Appian process we can pass values to the Robots parameterized variables.

2. use a queue and IRobotVariable to set the value in PV and later use this PV to fill in the UI forms with values.

If there could be any other approaches, please suggest those as well.

you can use this Excel Tool Plug-in to extract data from an excel sheet and directly get a PV containing the data in that excel sheet.

good luck.

ref: https://community.appian.com/b/appmarket/posts/excel-tools