collect or clearcollect multile selected items from gallery for further update

(0) Share

Report

Posted on by Dulat

102

I have gallery with checkbox to select items from gallery.

1. I was thinking to use Collect or ClearCollect to get items from the gallery.

When I make ClearCollect(Gallery.Selected), it returns collection with first row, regardless of if no checkboxes or other than first row are selected with checkbox.

When I make ClearCollect(Gallery.AllItems), it returns collection, but my checkbox record is unclear to me. (Default value for checkbox is false)

Can someone help me with this?

Plans to use collection.

2. to update Status column to "delete" for this collection.

3. to update rows in data source from step1 by new status from step2.

If you can help me with this, also very appreciated.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Dulat ,

You want to update the status for the records for which the checkbox selected is true? If yes please use the below code.
ForAll( Gallery1.AllItems, Patch( 'Course list', ThisRecord, { Status: If( Checkbox2.Value = true, "Approved", "Declined" ) } ) )

Thanks,

Was this reply helpful? Yes No
Dulat 102 on at

Like (0)

Report
Copy link

Link copied!

Hi @SanmeshG Thanks for reply!

I am new in powerapps.
Could you please advise what are 'Course List' and ThisRecord mean in this context?
Is it column and datasource?
Thanks!

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Dulat ,

'Course List' is my SharePoint List in this case and ThisRecord is the current record that is running (or is being used) in that context.

Was this reply helpful? Yes No
Dulat 102 on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot!

Was this reply helpful? Yes No
Dulat 102 on at

Like (0)

Report
Copy link

Link copied!

Hi @SanmeshG

In this code, anything not selected by checkbox goes to Else condition, so labelled accordingly.
Is there any way to do similar thing but only for selected items. unselected should remain same.

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Dulat ,

If you want to patch only the selected record and not all then you can use the patch function.
Pacth(Datasource,Gallery1.Selected,{columnName:"sampleText"})
ForAll should be used only if you have changes made in multiple records and you want to patch them.
Hope this helps.

Was this reply helpful? Yes No
Verified answer

Dulat 102 on at

Like (0)

Report
Copy link

Link copied!

Thanks @SanmeshG
I found this video, where Shane is doing exactly what I was looking for.
Select multiple records in a gallery and Patch with the PowerApps ForAll function - YouTube

Was this reply helpful? Yes No