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?
Hi @Z_BI ,
Do you want to update the data in the set to the excel table?
Patch(your_excel_tabl_name, Defaults(your_excel_tabl_name), First(your_collection_name))​
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