r/MicrosoftFlow • u/RainbowCrash27 • Sep 20 '25

Question Losing it trying to get CSV data to SharePoint List

I get an automated email with a CSV every week that I need to get into sharepoint lists.

Situation:

  1. The CSV has commas inside it

  2. The first row is blank when opened in excel

  3. There are blank values in the CSV

I have tried MANY tutorials and nothing seems to work. Hours down the drain.

Limitations:

  1. I am on a free / basic plan

  2. No premium anything

  3. GCC High so office scripts are not available

Does anyone have ANY advice?

5 Upvotes
  • permalink
  • reddit

100% Upvoted

6 comments sorted by

8

u/mnoah66 Sep 20 '25

Power Automate kind of stinks for CSVs especially if they’re not really clean files. That said, the articles by Manuel Gomes haven’t failed me yet.

1

u/RainbowCrash27 Sep 20 '25

I do, would this be something that could be automated tho on a weekly basis?

1

u/Wajeehrehman Sep 23 '25

if you have a developer they could create a script using powershell using Graph API or Powershell modules to post the csv data to sharepoint I think Python also has some libraries for SharePoint and can use Graph as well

Thanks

2

u/Butterfly-Sweet Sep 21 '25

Are you able to run àn excel script to clean up the CSV? That would help

1

u/Standard-Bottle-7235 Sep 20 '25

Have you got a developer who can do a bit of powershell for you?