Skip to main content

Notifications

Community site session details

Community site session details

Session Id : GpVMjDTPh0imrEx4D5ZeMz
Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 31 Oct 2022 11:25:20 by 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

  • Siyamand Rashid Profile Picture
    366 on 24 Jan 2023 at 12:22:36
    Re: How to import data from csv file to sharepoint without thrid party connectors and premium license?

    Sorry, nothing helpful yet.

    I will let you know once I got something 🙂

  • OSzuliko Profile Picture
    26 on 16 Dec 2022 at 19:14:02
    Re: How to import data from csv file to sharepoint without thrid party connectors and premium license?

    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?

  • Siyamand Rashid Profile Picture
    366 on 01 Nov 2022 at 05:42:47
    Re: How to import data from csv file to sharepoint without thrid party connectors and premium license?

    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.

    SiyamandRashid_0-1667281283717.png

     

  • grantjenkins Profile Picture
    11,059 Super User 2025 Season 1 on 31 Oct 2022 at 14:07:12
    Re: How to import data from csv file to sharepoint without thrid party connectors and premium license?

    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:

    1. You can save the CSV as an Excel file then import the Excel file into flow.
    2. 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 97

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 82 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard
Loading started