Help with arguments and grabbing data from my datatable

I am currently working on the practice for Exercise_Input_Output_Activities, and I want to grab data from my other work flow called searchforcurrentinvoice.xaml my argument in_InvoiceNumber isn’t inputting the numbers in the browser. I figure that there has to be something assigned to Invoice number, I am thinking of adding a read range workbook into this workflow for searchforcurrentinvoice.xaml and then assigning the column “Invoice number” to a variable which is “in_InvoiceNumber”. Would this work? Can someone explain? Thank you.

Ahhh, I just figured it out. Thank you. I had to add a value to the invoked workflow out in the main.xaml workflow. This allowed the file to run it on the main.xaml

Hi @xspunky

Yes, your approach will work.

Use Read Range Workbook to read the Excel file.

Assign the “Invoice Number” column value to a variable.

Pass this variable to in_InvoiceNumber in searchforcurrentinvoice.xaml.

Ensure in_InvoiceNumber is correctly mapped as an In Argument.

Invoke searchforcurrentinvoice.xaml and pass the variable as input.

Check if the browser activity is correctly using in_InvoiceNumber.

Happy Automation

Hi @xspunky,

Please follow steps as mentioned by @prashant1603765.

Additionally, you can have a log message after assigning Invoice number to a variable to check what value is coming in that variable.

Then inside searchforcurrentinvoice.xaml also, have log message as first activity to print the value of your in_invoicenumber to check its value.

This would help you identify the root cause. It can be that value itself is not getting assigned to a variable or may be its getting assigned but not being passed.

Please ensure when you are invoking workflow - searchforcurrentinvoice.xaml, you are editing its arguments and assigning your invoice number variable to your in_invoicenumber argument there.

Hope this helps.

Regards
Sonali

1 Like