Unanswered

Only add unique values to a collection through a Gallery using Collect All.Items logic

(0) Share

Report

Posted on by jeroen1290

Hi Community!

I am facing an issue related to the use of a Select All checkbox to add all items in a Gallery to my collection. The collection is based on a couple of slicers I have, and I would like this Select All checkbox to add all the current items in the Gallery to my collection.

The problem is however that the Select All box currently adds all items in the Gallery, despite the current selection already made and the items that are already present in the collection. This means that if an item is already selected or present in the collection, it is duplicated in the collection.

I would like to avoid this by building in the logic that only the items are added which arent already in the collection. Do anyone have any tips on how to achieve this? Thanks for the help in advance!

Overview

Select All OnCheck

UpdateContext({CheckCheckbox:true});ForAll(Collect(SelectedBudgetOwners,GalleryBudgetOwners.AllItems),ThisRecord)

Select All OnUncheck (this removes all items in the gallery)

Remove(SelectedBudgetOwners, GalleryBudgetOwners.AllItems); UpdateContext({CheckCheckbox:false});

CheckBox Default

CheckCheckbox

CheckBox OnCheck

Collect(SelectedBudgetOwners, ThisItem)

CheckBox OnUncheck

Remove(SelectedBudgetOwners, ThisItem)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jeroen1290 ,

Please try to add an If condition in your formula.

Sample:

UpdateContext({CheckCheckbox:true}); ForAll(GalleryBudgetOwners.AllItems) As temp, If(temp.<column name>) in SelectedBudgetOwners.<column name>,Blank(),Collect(SelectedBudgetOwners,temp))

Best Regards,

Wearsky

Was this reply helpful? Yes No
jeroen1290 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft,

Thanks for the response! However, I do not fully understand what you want me to full in. I tried the following, but the "as temp" part doesnt work as "Invalid number of arguments, received 1, expected 2".

UpdateContext({CheckCheckbox:true});
ForAll(GalleryBudgetOwners.AllItems) As temp, If(temp.CostObjectLocalBudgetOwner) in SelectedBudgetOwners.CostObjectLocalBudgetOwner,Blank(),Collect(SelectedBudgetOwners,temp))

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @jeroen1290 ,

Sorry, I typed extra parentheses.

Please try this

UpdateContext({CheckCheckbox:true}); ForAll(GalleryBudgetOwners.AllItems As temp, If(temp.<column name> in SelectedBudgetOwners.<column name>,Blank(),Collect(SelectedBudgetOwners,temp))

Best Regards,

Wearsky

Was this reply helpful? Yes No
jeroen1290 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft,

Thanks! It seems to work now. The only thing is that even though only the unique values are added when I hit add, only these are then remove when i deselect all. However, when I deselect all, I want all the variables in the galary to be remove from the collection.

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @jeroen1290 ,

Please try this in onuncheck property

ForAll(GalleryBudgetOwners.AllItems As temp, Remove(SelectedBudgetOwners, LookUp(SelectedBudgetOwners,<Column Name>=temp.<Column Name>)));UpdateContext({CheckCheckbox:false});

Best Regards,

Wearsky

Was this reply helpful? Yes No