Answered

Submitting Form data to an excel file

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello experts,

I have designed a Form using an excel file from Onedrive. After entering the details and submitting the form it has to create a new record in a different excel file. Please let me know how to accomplish the above task.

Thank You

Categories:

Building Power Apps

All responses (6)

Answers (2)

Sort by

cds 1,001 on at

Like
a
(1)

Report
Copy link

Link copied!

Flow
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply. Can we achieve this in powerapps itself?
cds 1,001 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't think it is possible
Verified answer

v-monli-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Anonymous ,

This can be achieved by using a Patch function. First you need to add the table in the 2nd excel file to the data source of this app. Then use the 1st table as the data source of the edit form but set the OnSelect property of the submit button to something like:

Patch(Table2,Defaults(Table2),{Title:DataCardValue1.Text,Date:DataCardValue2.SelectedDate,...})

Regards,

Mona
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank You Mona.
EmanuelArcas 9 on at

Like
a
(0)

Report
Copy link

Link copied!

@Mona instead of saving the updates to another excel table is it possible to patch it to a SP list? Is the same patch syntax or is different. When I try I get on the button the error: "The specified column "x" does not exist".