web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / CSV export and import ...
Power Apps
Answered

CSV export and import with powerapps Canvas apps

(0) ShareShare
ReportReport
Posted on by 34

Is it possible to export and import CSV with the PowerApps canvas app?
I'm using SQL server.

Categories:
I have the same question (0)
  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @Misawa The best option would be to set up a Data Flow,

    CNT_1-1621402599992.png

    CNT_0-1621402566080.png

  • Misawa Profile Picture
    34 on at

    Thank you for the fast reply.
    I'll try.

  • Misawa Profile Picture
    34 on at

    I tried, but I didn't understand.
    Please tell me the specific method.

  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @Misawa Do you want to import CSV to Dataverse (in Power Apps) OR CSV to SQL Server?

  • Misawa Profile Picture
    34 on at

    Import into SQL Server.

  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @Misawa If you want to import a CSV to Dataverse, you can use the Built-in DataFlows. But to import from CSV to SQL Server, there is no direct way in PowerApps. You'll have the read the data in and then patch them to your SQL Server. A more direct way to go would be to use SSMS. Please check this article, https://www.sqlshack.com/importing-and-working-with-csv-files-in-sql-server/

  • Verified answer
    Misawa Profile Picture
    34 on at

    >there is no direct way in PowerApps.

    I understand. I appreciate it.

  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @Misawa Glad to help!

     

    Please remember to give a 👍 and accept the solution as it will help others in the future.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard