Manipulate Table

[Anonymous]

Hey

me again I have a question about how I can add a collection to a table.

or how I can adjust a table

 for example a table with the main items product and brand

it contains 2 items how can I add a 3rd item to it.

Kind regards Ruben De Windt

[eka24]

You can use a collection and AddColumns:

ClearCollect(MYCollectionName,
AddColumns(YourExistingTable,"NewColumn","DataInNewColumn"))

You can then use the MYCollectionName as a new table for your DataTable or Gallery

[mdevaney]

@Anonymous 

I made a free app that has 50+ examples of how to manipulate tables.  There is a visual and code for each technique.

Check it out here:

https://powerusers.microsoft.com/t5/Community-App-Samples/Collections-Cookbook-50-Visual-Examples-amp-Code/td-p/437594

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Anonymous]

found it 😄

i did it like this:

Patch( beamer; Defaults( beamer ); {'product ': product_beamer}; {'nmbs code': nmbscode_beamer}; {merk:merk_beamer}; {groote: groote_beamer})

tnx anyway 🙂

[mdevaney · Accepted solution]

@Anonymous 

You should write it like this instead.  Your method makes 4 separate calls to the datasource API.  Mine only makes 1 call.  This means performance will be best using my way. 

Patch( beamer; Defaults( beamer ); {'product ': product_beamer; 'nmbs code': nmbscode_beamer; merk:merk_beamer; groote: groote_beamer})

Please mark as solution 😁 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."