Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only
  • 1.  Fill copied Excel file with CSV or JSON content

    Posted May 31, 2022 04:00 AM

    i want to fill an excel template with content coming from a PowerApp.
    I have an Excel template with a formatted table and the column headers.
    When starting the workflow, i hand over a collection in JSON structure.

    So, i copy the template file and want to fill this copy with the data. But when i add the action "add row into a table", i need to define the file and table name dynamically.
    So, it cannot show the single columns of the file. It only shows a field "row".

    What structure is expected in the field "Row"?
    How can i fill a json structure into a copied excel file?

    Fabian Heil

  • 2.  RE: Fill copied Excel file with CSV or JSON content

    Top Contributor
    Posted Jun 01, 2022 12:27 AM
    Edited by Will Page Jun 01, 2022 12:30 AM
    Try specifying the template file, configuring the columns then changing the file identifier back to your dynamic content.

    If that doesn't work, you could specify the template, then after the file is populated, copy it then roll the template back to previous version using SharePoint API

    You could also try doing get file content, then populate the template, copy it then update file content using the output of the get file content from earlier.

    Remember to add a 2 minute delay after updating the excel file before copying it. There's a delay between adding rows and seeing them in the file.

    Will Page
    Technical consultant
    Christchurch, NZ