Overwrite entire columns of table with gallery items

(0) Share

Report

Posted on by karimabdelrazek

294

Hi,

I have gallery that contains two columns, one for process steps, and the other is their sequence numbers. I'd like to overwrite the entire columns of an existing table (same structure), with the entire contents of this gallery. How can I do that?

I'm only using CDS and no external lists (e.g. SP, etc.). I'm looking for a solution that does not require using external data sources. Many thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Overwrite gives an indication of replacing the data in the Gallery. To get the structure of the Table use ClearCollect;
ClearCollect (ColOverwrite, Datasource);
Clear (ColOverwrite)

That gives an empty structure. Now what do you want to put into the Table structure
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
karimabdelrazek 294 on at

Like (0)

Report
Copy link

Link copied!

@eka24 . Sorry if the message wasn't clear. I want to take all the items in the gallery, and write it into an existing CDS entity/ table that contains data.

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

You can Patch the Gallery or the Collection using following;
Gallery:
ForAll(Gallery1.AllItems, Patch(
Datasource,
Defaults(Datasource),
{Column1: Title},
{Column2: Category}))

For a collection;
ForAll(Collection1,
Patch(Datasource, Defaults(Datasource), {Column1: Title,
Column2: Category}))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
karimabdelrazek 294 on at

Like (0)

Report
Copy link

Link copied!

@eka24 . The formula you gave partially works. It writes all the data to the correct columns in my entity, but instead of overwriting, it's adding them as records. Is there a way to overwrite the data in the entity?

Was this reply helpful? Yes No
karimabdelrazek 294 on at

Like (0)

Report
Copy link

Link copied!

@eka I've found the answer. I removed all the values from that entity using the "Remove" function, and re-wrote all the values from gallery into it.
Thanks for your help!

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @karimabdelrazek :
Is your problem solved? Do you still need help?
If you have found a solution, could you mark it as a solution so that more people can see it.
Best Regards,
Bof

Was this reply helpful? Yes No