Invoke PowerShell code in UiPath

[ukjtenhoven (Kees-Jan)]

Hello,

Could someone help me, I need to retrieve all the users from Windows Active Directory using a PowerShell code so that the exported file keeps being updated but it exports it as .csv .But the robot needs to read the file but because it’s a .csv the robot can’t read the file.

And I keep getting this error.

Could someone help me?

With kind regards,

@ukjtenhoven

[AshwinS2 (Ashwin S)]

Hi @ukjtenhoven

Check the file manually is the path right

Thanks
Ashwin.S

[Natapong (Natapong Raojutitam)]

@ukjtenhoven

Please check your CSV file format.

You can refer below article

The CSV file format for <file> is invalid

Weird. And you saved the file again to the new extension rather than rename the file? There was also a post on this forum with same issue and he resolved it by rebooting. haha, worth a try right? I would also make sure the file is delimitted by comma (Open in Notepad) and doesn’t have any zeroes in blank fields and few other things. You could do some research online too. Hopefully you get that figured out with UiPath. Their helpdesk is here https://uipath.zendesk.com/hc/en-us If it comes do…

[kumarD (Mitradev Das)]

Hi @ukjtenhoven
Try to change the path manually and also change the file format to other format, i mean excel etc… and then try, may be it will work.

Regards

Kumar

[ukjtenhoven (Kees-Jan)]

Yea I checked that already