Unanswered

Create row items from a gallery using checkbox

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have created a gallery with a checkbox for each items in the gallery list.

The idea is that the checkbox is used to select the items (it can be multiple!).
Once selected there will be a button to duplicate the selected items. Also, I am using dataverse as my datasource.

Below is a snippet of my code,

ClearCollect(RecordsToCopy, DropColumns(BudgetMonthRecord.'Forecast Items',"_ownerid_value","createdby","modifiedby"));
Clear(NewRecords);

// collect new records into collections
Collect(NewRecords, RecordsToCopy);
Patch('Forecast Items', NewRecords);

Concurrent(
 Clear(NewRecords),
);

I wanted to create a collection for only the selected item. Would appreciate the help for this!
Thanks.

- Mia

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Ashwin7104 671 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @Anonymous ,

Please use below code to filter selected item from gallery. Please note that schema in collection and Dataverse table should be identical in terms of column names.

// collect selected records in gallery into collections ClearCollect(collectionName, Filter(Gallery.AllItems,Checkbox.Value = true)) //Use Patch / Collect to create items Patch('Forecast Items', NewRecords);
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Ashwin7104 ,

I tried your solution, and this would be use in the onSelect property of the button, yes?
Unfortunately the item is not created and I am not sure what went wrong for this?

// collect selected records in gallery into collections ClearCollect(RecordsToCopy, Filter(ForecastGallery.AllItems, Checkbox1.Value = true)); Clear(NewRecords); // collect new records into collections Collect(NewRecords, RecordsToCopy); // create the new records in batch Patch('Forecast Items', NewRecords);
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You can try below formula if it helps your requirement.

ForAll(Filter(ForecastGallery.AllItems,Checkbox1.Value = true), Patch('Forecast Items'),Defaults('Forecast Items'),{ColumnName: ThisRecord.CollectionColumnName,.....})

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.