I have excel data with 4 rows and 3 columns. 1 column having the data Item. 2 columns have no data but i have to send column 1 data to action center from there after user enter the weight1 and weight2 data. i should update weight 1 to column2 and weight2 data to column3.
I have created the workflow, read the excel data and Inside for each row I used create form task with item is the in argument and Weight1 and weight2 is the out argument, i should get weight1 and weight2 from the Action center. I have used Wait form task inside the For each row so that i will get the weight1 and weight2 for all the items. But i am not able use the Wait form task inside the for each row. How to use the Wait form task for multiple data update.
could you attach a sample and elaborate pls?
i have a hard time relating “what is required” and “what you tried already”
SG.
You do not want a looping automation when using Action Center.
You should have a dispatcher that reads the file and creates queue items. This is the looping automation.
Then you have an actioncenter process that is just top-down, process one item and finish. This one will create the form, wait, and then update the Excel file with the data provided by the user.
In my project I should not use Dispatcher and performer and ReFramework
You cannot use REFramework for this. It will create one form task and then wait, not processing the next item until the first item is complete in action center.
The design I gave you is the correct way to handle action center.
clear now..
do you want user to fill in the W1 and W2 of all the items in a single form or you want multiple waits for each item?
I too wouldnt recommend using a looping mechanism for action center tasks.
it should be more like, user performs all actions at once and submits and then your flow to update those values should invoke.
SG.
How to invoke all the data from Action center.
For example i will read the excel data and inside the for each row i used create form task. Now i have updated all the excel data to Action center to get the weight1 and weight2 from the user for all the Items.
Now tell me how to get the all the items value after user entered from the action center . where to use Wait form task activity.
Hi @Vanitha_VS
If you need Weight1 and Weight2 for all items, don’t create a separate Form Task and Wait Form Task inside the loop.
Instead:
-
Read all Excel rows.
-
Create a single Action Center form containing all items.
-
User enters Weight1 and Weight2 for all items and submits the form once.
-
Use a single Wait For Form Task activity after creating the form.
-
After the form is completed, get all submitted values and update the Excel/data source.
This approach is better because the user completes everything in one form, and the robot waits only once instead of creating multiple tasks and waits.
Happy Automation.
Same way i have created, If i keep Wait for form task inside for each row i am getting error. I kept outside the for each row, but if i approve multiple task once, i will get only one weight1 and weight2
How to get all rows weight1 and weight2
We have both told you that you cannot do this inside a loop. Please listen to us, we know what we are talking about.
You don’t get all rows. You create an Action Center task for each row, then you have an Action Center automation that is top-down. It creates the form task (not the dispatcher) and then waits. Once the task is completed the job resumes and you have access to the data submitted by the user which you use to update the Excel file. The dispatcher loops through the rows and creates queue items for the actioncenter automation which starts one job per queue item.
can you provide workflow