Answered

Adding Power App Collection Data to Excel Online

(0) Share

Report

Posted on by Puneeth656

Hi,

I have Power App and Let me know how to send the Data in collection of my app to excel online through patch function.
whenever User Submits data it should always go to excel in new rows.

I have attached Excel Table and Collection Data also. Collection Name is "FinalData" and Excel table name is "DataTable".

I have used below Method But its adding only one row of Data in collection. Its not adding all the rows in the collection to excel

Collect(
FinalData,
{
EmployeeID: EmployeeID.Text,
Date: Date.SelectedDate,
Activity: Activity.Text,
OrderNo: OrderNo.Text,
Type: Type.Text,
Description: Description.Text,
Quantity: Quantity.Text,
Hours:Hours.Text,
Status:Status.Text
}
);

Patch(
DataTable,
FinalData
);

Notify("Data sent successfully", NotificationType.Success)

Please help me out on thisMy Excel TableMy collection In app

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Puneeth656 If the columns in the Excel table and the collection match you can do a bulk add/update using the patch function, Patch(excelTable, FinalData)

Please remember to give a 👍 and accept my solution as it will help others in the future.
ArunkumarRA 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Instead of Saving the data to collection and exporting it to excel, You can directly push the data directly into the excel file by using Patch function

Patch{excel file, defaults(excel file),{column : input field})
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Puneeth656 ,

Since there are differences in the table and collection columns, you'd better use ForAll and Patch functions OnSelect of a Button control to achieve your need:

ForAll( FinalData As FD, Patch( ExcelTableConnection, Defaults(ExcelTableConnection), { 'Employee ID': FD.EmployeeID, Date:FD.Date, Activity:FD.Activity, 'Order No':FD.OrderNo, .... } ) )

Best regards,
Puneeth656 11 on at

Like
a
(0)

Report
Copy link

Link copied!

I have below method But is only adding one row data in collection and not adding all the rows to excel

Collect(
FinalData,
{
EmployeeID: EmployeeID.Text,
Date: Date.SelectedDate,
Activity: Activity.Text,
OrderNo: OrderNo.Text,
Type: Type.Text,
Description: Description.Text,
Quantity: Quantity.Text,
Hours:Hours.Text,
Status:Status.Text
}
);
Patch(
DataTable,
FinalData
);
Notify("Data sent successfully", NotificationType.Success)