Answered

How to copy Table A to Table B in powerapps

(0) Share

Report

Posted on by UberBera

I have a question if you could help me.. if I have two tables with the same structure (same columns), what is the best way to patch all my records from Table A to Table B? I'm not talking about galleries, but Excel tables as database..

I got how to make it, but it's taking too much time.

RemoveIf(Table B; true);;

ForAll( Table A;

Patch( Table B;

{ Column 1 in Table A = Column 1 in Table B

Column 2 in Table A = Column 2 in Table B

(...)

}

)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report
Hi @UberBera ,

You could do this

ClearCollect(colA,TableA); Collect(TableB,colA)

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.

Was this reply helpful? Yes No
UberBera 4 on at

Like (0)

Report

Hi @WarrenBelz !
Thanks for your help. But, if I do what you are suggesting, my table B in Excel won't be updated, right? I'm going to create a Collection inside PowerApps, but my original Table B in Excel won't be changed..

I need to copy Table A to Table B, but I need my Excel database gets this data.

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

@UberBera ,

Your table in Excel should be updated - Collect can also be used for adding all the records from a collection as new records in a data source providing all the fields match.

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.

Was this reply helpful? Yes No