Skip to main content

Notifications

Power Automate - Building Flows
Answered

Store array as file content inside excel file

(0) ShareShare
ReportReport
Posted on by

Hi Folks,

 

I would like to store an array that I generated in flow in a new excel file inside OneDrive. It's an array with single object of string type values. What should I give in file content of create file action to achieve this?

 

rbn_nue_0-1658246543417.png

 

Expected output:

 

rbn_nue_1-1658246693261.png

 

 

Thank you.  

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Store array as file content inside excel file

    That’s exactly what I was suggesting!

    👍

  • Verified answer
    rbn_nue Profile Picture
    rbn_nue on at
    Re: Store array as file content inside excel file

    Hi @MarconettiMarco ,

     

    I was able to complete this requirement by following the below video:

     

    https://www.youtube.com/watch?v=RB_ySjhm9Sg

     

    Thank you.

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Store array as file content inside excel file

    ok @rbn_nue ,

    so you should follow these actions:

    1.Create a file with content equal null,

    2. Create an excel table : you have to specify the range and the columns names

    3. Add a row into a table: got from your array, so the system will automatically create an apply to each loop

     

    Please let me know

     

    BR,

    Marco

  • rbn_nue Profile Picture
    rbn_nue on at
    Re: Store array as file content inside excel file

    Hi @MarconettiMarco ,

     

    Yes, that would be ideal and straight forward. But due to business requirement we have to go with OneDrive to avoid dependency with an SPO site. I just want to store current data in OneDrive, so that next time the flow runs I can check if it's same item. 

     

    Thank you. 

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Store array as file content inside excel file

    Ok @rbn_nue ,

    have you ever considered to use a SharePoint list instead of the excel spreadsheet?

     

    BR,

    Marco

  • rbn_nue Profile Picture
    rbn_nue on at
    Re: Store array as file content inside excel file

    Hi @MarconettiMarco ,

     

    Add a row might work, but what I'm looking for is to create a new excel file and add this array as content.

     

    rbn_nue_0-1658292081779.png

     

  • MarconettiMarco Profile Picture
    MarconettiMarco 3,812 on at
    Re: Store array as file content inside excel file

    Hello @rbn_nue ,

    are you able to grab these values form the array and using the excel “add a row” action, add the row in your spreadsheet?

    otherwise please use the “Parse JSON” action, the From must be your array, and in the body click on “generate from sample “ and past your json structure.

    Then you should be able to grab the values and put them in the excel “add a row” action.

     

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

    BR,

    Marco

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard