Answered

How can I send data from PowerApps to excel every time user clicks on submit?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am creating a small application where the user enters their name, DOB, and address and, upon submitting, data should be sent to excel. Every time a user clicks on submitting data should get sent and saved in excel.

I tried doing this but in my case data is getting overwritten and I am losing the older data. Can we achieve this without data getting overwritten.

Can someone help me with this?

I am not using any form or gallery.

Thanks 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Are you using a Form or Patch()? If its a form make sure its in New mode. If you are using Patch() make sure the second parameter is defaults(<<datasourcename>>)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Can I make use of power automate and achieve this?

Was this reply helpful? Yes No
Gochix 1,937 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Try Patch(Source,Defaults(Source),…)
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, but you don't need Power Automate. How are you saving the data now? Its probably just a problem with how you have it configured and are saving it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah. Currently I am using power automate and saving it. Hence it is overwriting the data.

I will try using the patch now.

But here I am not using any form or gallery. its just the plain screen. Will patch works in this scenario?

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What action are you using in Power Automate? update row or add row? If you want new rows it should be add rows.

Yes, if you are using controls on a screen then Patch will work.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Perfect!!
I will try with the patch. As Add row is a premium option

Was this reply helpful? Yes No
Verified answer

Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Adding a row to an Excel file is not a premium option. Adding a row to a dataverse table is. But patching a dataverse table is also a premium option.

Was this reply helpful? Yes No