web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Save data from collect...

Power Apps

Unanswered

Save data from collection to a specific Excel cell

(0) Share

Report

Report

Posted on by Beyond The Platforms

188

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?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

WarrenBelz 155,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No

Join the conversation