Create UiPath form to upload excel data into Orchestrator queue

Help Studio
, ,
1

Hi All,
I want to create a UiPath form to upload an excel data into Orchestrator queue. Is is possible to do? Kindly help.

2

Hi @reetmehta - UiPath Forms are specifically made for Attended Automation. So,there is no method to directly upload the excel data to Queue. Instead, you can use UiPath Apps for your requirement.

Other way, you can get the input data from the user through UiPath Forms, use the same data to load to Queue using the existing activities. (Add Queue Item)

3

Hi

Let me give u a outline of the workflow to achieve this

Hope this will help you

  1. Open UiPath Studio and create a new project.
  2. In the project panel, right-click on the “Main.xaml” file and select “Open in Form Designer”.
  3. In the Form Designer, create a form with a file upload field and a submit button. You can customize the form as per your requirements.
  4. Drag and drop the “Excel Application Scope” activity from the activities panel to the workflow.
  5. In the properties panel, specify the path of the Excel file to be uploaded.
  6. Drag and drop the “Read Range” activity inside the “Excel Application Scope” activity.
  7. In the properties panel, specify the sheet name and the range from which you want to read the data.
  8. Create a new variable of type DataTable to store the data read from the Excel file.
  9. Drag and drop the “For Each Row” activity outside the “Excel Application Scope” activity.
  10. In the properties panel, specify the DataTable variable created in step 8.
  11. Drag and drop the “Add Queue Item” activity inside the “For Each Row” activity.
  12. In the properties panel, specify the Queue name, Priority, and any other relevant information. You can use the data from each row of the DataTable to populate these values.
  13. Drag and drop the “Message Box” activity outside the “For Each Row” activity.
  14. In the properties panel, enter a message to display indicating the completion of the task.
  15. Save the workflow and close the Form Designer.
  16. Publish the process to Orchestrator.
  17. Run the process from Orchestrator and test the form by uploading an Excel file and submitting it.

Cheers @reetmehta

5

Hi @Palaniyappan ,
Thanx, will try and let you know.

1 Like
6

@Palaniyappan I am not getting the file upload option in Form designer.

image
image699Ă—491 34.3 KB

image
image157Ă—631 14.1 KB