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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / power app form to crea...
Power Apps
Unanswered

power app form to create csv file

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

 I have created a power app form and have it set to submit when done.  It then put the data into dataverse, but I want to create a csv file from a collection on the form.  I can get all the data except the data from the dataverse, is there a good formula to get that data from the dataverse in the same step as submitting the form?

Categories:
I have the same question (0)
  • v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Sorry, I'm not very clear if you want to export the data from the dataverse or the data from collections to CSV.

    If you want to export the CSV when the form is submitted, you can try connecting Powerapps to PowerAutomate.

    Since you did not provide a data source, here I use collection to make a simple demo.

    Collection contents are as follows.

    vxiaochenmsft_0-1665567090481.png

    Create a Flow with the content shown in the picture:

    vxiaochenmsft_1-1665567128747.png

    Connect Canvas and Flow, add Button to Canvas and set as follows:

    vxiaochenmsft_2-1665567149134.png

     

     

    Collect(ExportCSVCol,{CNO:18,CNAME:"C"},{CNO:19,CNAME:"A"},{CNO:20,CNAME:"C"},{CNO:21,CNAME:"D"},{CNO:22,CNAME:"C"});
    Set(
     ExportCSVVar, 
     Concat(
    ExportCSVCol,
     CNO & "," & CNAME & Char(10)
     )
    );
    'PowerApp->Createfile'.Run(ExportCSVVar);
    

     

     

     

    After running the app, a CSV file will be created in OneDrive, which can be opened and viewed in Excel:

    vxiaochenmsft_3-1665567180327.png

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Wearsky

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks, but I have a form that submits data to dataverse and a couple columns that calculate data.  So I create a collection which has 8 other collections with it, most of the data I get from the form, textinputs, but I need to get data off the dataverse which I think are the columns that are calculated after submitted from the form.

     

    Does that make sense?

     

    Thanks for your help!

  • MechEng2013 Profile Picture
    257 on at

    Don't know that I can solve your issue, but thought i would share that I use Flow a lot for CSV and PDF outputs, mostly delivered through emails, but there are other ways to output as well.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 936

#2
Valantis Profile Picture

Valantis 604

#3
11manish Profile Picture

11manish 518

Last 30 days Overall leaderboard