Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Save data from collection to a specific Excel cell

(0) ShareShare
ReportReport
Posted on by 45

Hi everyone, I have a collection of only one row and several dozen columns all valued. I would like to save this data in specific cells of an Excel file, so each cell of the collection will have to coincide with a specific cell of the Excel file. How can I do?

  • Re: Save data from collection to a specific Excel cell

    Hi @Z_BI ,

    Do you want to update the data in the set to the excel table?

    If so, you can try to update your excel table with Patch().
     
    @WarrenBelz has provided a correct direction, I just add something as below:

     

    Patch(your_excel_tabl_name, Defaults(your_excel_tabl_name), First(your_collection_name))​

     

    Make sure that the column name of your set is the same as that of your excel table.
     
  • WarrenBelz Profile Picture
    WarrenBelz 145,434 on at
    Re: Save data from collection to a specific Excel cell

    Hi @Z_BI ,

    You can save to a column (the Excel Table) in a particular record (row), but you cannot specify G8 / H11 etc if that is what you are meaning. When Excel is used, it needs to be formatted as a Table with the rows records and the columns fields in those records.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

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,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard