Error when reading data from a CSV File and saving it in a variable

[Wahaj11 (Wahaj)]

Hey there everyone! I am creating an automation that is going to read a csv and iterate through the entries in that csv, and for each of the entries it is going to visit a specific url in the browser and search for that entry on the webpage. I figured out a flow to do this but the problem I am facing is about something called ‘IXmlSerializable’. The photos of my flow and error have been uploaded. Any help would be appreciated, Thanks!

[Parvathy (PS Parvathy)]

Hi @Wahaj11

Try using For each row in DataTable and pass the datatable variable.

Regards

[AutomationX_by_Kiran]

Hi @Wahaj11 ,

Please Use for each row in a datatable activity

as the data is read from CSV/Excel is stored in datatable varaiable .

Happy Automation !

[mkankatala (Mahesh Kankatala)]

Hi @Wahaj11

You are using Read CSV activity which helps to read the csv file and store in a datatable. Volunteer_CRM Variable is the datatable datatype.

To iterate the each row in the datatable use the for each row in datatable instead of using the for each activity. Pass the Volunteer_CRM variable in the Datatable field.

Check the below image to know about for each row in datatable activity,

Hope it helps!!

[Parvathy (PS Parvathy)]

@Wahaj11

If you find solution for your query please mark it as solution to close the loop.

Happy Automation
Regards

[Nawazish_Ahmad]

Hi @Wahaj11

Use For Each Row in Data Table Activity

Hope it will helps you
Cheers!!