Answered

Patch a collection to excel and ovewrite

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi and Good Day to everyone,

I know how to patch a single record to excel file and overwrite it, but what I do not know is, how to patch a collection that have multiple item inside it and overwrite the data if it exists in the Excel file.

Any help or ideas would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

You basically do the same thing. But you add a ForAll() function at the beginning of the patch.

Good blog on this here

https://www.codesharepoint.com/sharepoint-tutorial/powerapps-forall-function-with-examples

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

Like
a
(0)

Report
Copy link

Link copied!

Hi, @Jcook

I try it but to no avail, was wondering if you could help me on this one?
I have a collection with 2 or more items, and when user click a button, it will patch/update an excel file using the collection and if any same data exist, it will overwrite it.

Was this reply helpful? Yes No
Jcook 7,783 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Yea for sure!

When you say overwrite any existing same data. Would this just be an update?

Was this reply helpful? Yes No