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 Automate
Answered

csv file creation

(1) ShareShare
ReportReport
Posted on by 16
create excel file using one click button using powerapps using datasource csv
Categories:
I have the same question (0)
  • Suggested answer
    Riyaz_riz11 Profile Picture
    4,204 Super User 2026 Season 1 on at
    Hi,
     
    Create a Power Automate flow
     
    Use the PowerApps (V2) trigger.
     
    Add inputs if you need to pass data from Power Apps.
     
    Get the CSV data
     
    Use Get file content if the CSV is stored in SharePoint or OneDrive location or retrieve data from your data source.
     
    Based on sharepoint list or Datvaerse use action
     
    List Rows if required add filter
     
    Select to restrict columns
     
    Use Create file to create a new csv file with a unique name (for example, Report_20260607.xlsx).
     
    Using Create file action
     
    Return the file link
     
    Use Create sharing link (OneDrive or SharePoint).

    Use Respond to a PowerApp or flow to send the download URL back to Power Apps.
     
    Call the flow from a button in Power Apps
     
    Add a button and set its OnSelect property:
     
    Set(varFileLink, ExportExcelFlow.Run().filelink);
    Launch(varFileLink);

    When the user clicks the button, the flow creates the Excel file and opens the download link automatically.

    For reference: https://www.matthewdevaney.com/create-an-excel-file-and-add-rows-using-power-automate/?utm_source=chatgpt.com
     
    If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
    Regards,
    Riyaz
  • Suggested answer
    Haque Profile Picture
    3,653 on at
    Hi @CU03051719-0,
     

    To create an Excel file with one click in Power Apps using a CSV file as a data source, you can follow this general approach:

    1. Prepare the CSV Data Source
      • Store your CSV file in a location accessible to Power Automate, such as OneDrive or SharePoint.
    2. Build a Power Automate Flow
      • Create a flow triggered by Power Apps (button press).
      • The flow reads the CSV file content from OneDrive/SharePoint.
      • Parse the CSV content into a table format (using a CSV parsing action or custom logic).
      • Create an Excel file dynamically (using Excel Online connector) or update an existing Excel template with the parsed data.
      • Save the Excel file to OneDrive or SharePoint.
      • Return the file link or content back to Power Apps.
    3. Connect Power Apps to the Flow
      • Add a button in Power Apps that calls the Power Automate flow.
      • Pass any parameters if needed (e.g., file path).
      • Display or provide the generated Excel file link to the user for download.
     
     

    I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard