How to import data from csv file to sharepoint without thrid party connectors and premium license?

(0) Share

Report

Posted on by Siyamand Rashid

366

Hello All,

if I have a csv file and want it to import it to a sharpoint list using power automate, how to do it without third pary apps and premium license?

Regards

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report
Just a few questions:

Will the CSV you are importing always have the same columns/headers?

Is this just a one-off task you're trying to do? If so:
You can save the CSV as an Excel file then import the Excel file into flow.
You can just copy/paste the data from your CSV into your List in Datasheet View.

If not a one-off task (assuming it's not), I can provide a flow tomorrow (just off to bed now) that will import the CSV and provide a JSON array without premium connectors, etc. Otherwise, someone else might provide you a solution in the meantime.

Was this reply helpful? Yes No
Siyamand Rashid 366 on at

Like (0)

Report

Thank you very much @grantjenkins for your support, let me explian what exactly im looking for
I have a finger print to record employee attendece, monthly im runing a report from it and send it to admin department but the export excel file is not well formatted, so i have the same column name ,
what I want to do is, monthly after I generate the csv file from the Finger print machine, i want to uploaded to share point folder from their I want power automate to get data from that CSV file and update the excel sheet screenshot below and send it to admin after update complete.
so each employee will have a table like below and if not possible to separate the employee name we can add another column employee name to the table.

Was this reply helpful? Yes No
OSzuliko 26 on at

Like (0)

Report

Any update on this? I also have a CSV file which i would like to not only import once but import new rows whenever this file is modified ( kept in Sharepoint), and added to a list in Sharepoint. I cnnot use any third-party connectors like Plumsail etc. or have a Premium License for Power Automate sadly. Can you help?

Was this reply helpful? Yes No
Siyamand Rashid 366 on at

Like (0)

Report

Sorry, nothing helpful yet.
I will let you know once I got something 🙂

Was this reply helpful? Yes No