Need Help in Level 3 Assignment 1. Assign faulted

[sgshreya95 (Shreya)]

WIList=TransactionData.Select(“Type=‘WI5’ AND Status=‘Open’”) is faulted again and again.

Can anyone please help me out in this?

Please share your email so that I can send my workflow.

Thanks in advance.

[supermanPunch (Arpan)]

@sgshreya95 Can you tell us What kind of Error it shows?

[sgshreya95 (Shreya)]

It simply shows Assign faulted.

Please have a look.

Main.xaml (54.0 KB)

[lakshman (Ganta lakshman)]

@sgshreya95

Before this assign activity try to print the below using Message Box or Writeline activity and check once.

TransactionData.Rows.Count

If it gives any error then TransactionData does not contain any rows and it not scraped data properly.

[sgshreya95 (Shreya)]

Yes, now the Message box is faulted.

[lakshman (Ganta lakshman)]

@sgshreya95

That means TransactionData does not contain any data. Check once whether it is scraped data properly or not.

[sgshreya95 (Shreya)]

Yes it is scraping data properly. I have used Write Range activity to get the scraped data in an excel sheet and it looks fine.

[lakshman (Ganta lakshman)]

@sgshreya95

Then check arguments and it’s directions properly.

[sgshreya95 (Shreya)]

I have rechecked the arguments but not sure what is causing the issue.
Could you please look into my workflow that I have attached above and guide me where I am going wrong?

[lakshman (Ganta lakshman)]

@sgshreya95

Could you please show me screenshot of in which workflow are you scraping data and its arguments section.

[sgshreya95 (Shreya)]

[lakshman (Ganta lakshman)]

@sgshreya95

Did you store output of data scraping activity in dt_Workitems arguments or not ?

And also did you pass this data to TransactionData or not?

If not then go to Edit arguments of that Invoke Workflow activity and pass output to TransactionData variable.

[sgshreya95 (Shreya)]

It is working now. Thank you

Now stuck with another piece

[sgshreya95 (Shreya)]

Can anyone please help me out in this?