Unanswered

Collect two tables into one collection

(1) Share

Report

Posted on by N1loCan

Hello there!
Im trying to collect 2 identical tables (from excel) into one single collection, but it seams that they are considerated two different tables.
Here is the error and the two tables

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report
Hi

Use the table directly instead of collection:

ClearCollect( _FinalTable; Table1; Table2 )

Please click Does this answer your question 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 a Like.

Thanks,

ANB

Was this reply helpful? Yes No
N1loCan 62 on at

Like (0)

Report

Still the same

Was this reply helpful? Yes No
Suggested answer

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Please follow this artcile:

https://michelcarlo.com/2021/04/28/power-apps-merge-tables-collections-and-get-distinct-records-without-using-collect/

Please click Does this answer your question 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 a Like.

Thanks,

ANB

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

Like (0)

Report
Hi N1loCan

FirstlyANB was correct in the first response. Also you need to paste your entire code in Text (some is hidden in the image) as the error may be elsewhere. Assuming the two tables PlanilhaImobilizados and PlanilhaVendidosImobilizados are identical in structure (same field names and types) try this (get rid of the rest of the code - just use this). Excel is a terrible data source at the best of times, so may need a little assistance.
With( { _Plan1: PlanilhaImobilizados; _Plan2: PlanilhaVendidosImobilizados }; ClearCollect( _FinalTable; _Plan1; _Plan2 ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No