Check items in Gallery, Select rows in ListBox

[iwonder]

Thank you for taking the time to read my question.

I have a Gallery that has pictures with a checkbox beside them and a hidden field that has a code that is associated to the picture.

The values in the Gallery are from a SharePoint list and I want to show all 6 values every time so that users can select which ones they want by checking the checkbox.

I can return the values that have been checked.

If I have a space separated list of the codes associated to the pictures, how do I check the check boxes in my Gallery.

I also have a ListBox. It's items come from another SharePoint list. I can return all the selected values from the ListBox but how do I select values in the list box based on a space separated list of values

Example:

ID	ProductCode	Signs	H-Number
1	123456	GHS07 GHS08	302_00 314_00
2	987654	GHS09	317_00

If the user Searches for ProductCode 123456 then I want to check the Gallery items equal to GHS07 and GHS08, and I want to select the rows in the ListBox equal to 302_00 and 341_00.

General info: A user can look up a ProductCode. If found I want to return the record and update the controls on my Screen to the values of the existing record. I was thinking the best way to do this is to filter for the record based on ID (I can do that part) and put the results into a Collection. Then I can make my controls equal to the values in the collection. I just can't find a post on how to add the results of a Filter to a Collection

Thanks!

[WarrenBelz]

Hi @iwonder ,

I think this is the bit you need - this will return all fields in the gallery to a collection on the records that the checkbox has been selected.

ClearCollect(
   colYourCollection,
   Filter(
      YourGalleryName.AllItems,
      YourCheckboxName.Value = true
   )
)

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.

[WarrenBelz]

Hi @iwonder ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

[iwonder]

Hi Warren,

If I'm reading your reply correctly, you're returning the items in the Gallery that the user selected. What I want to do is check items in the Gallery based on an existing record in the database.

This is how I'm getting all the checked items in my gallery (for now I'm just putting the checked items into a Notify):

Signs: " & Right(Concat(cSigns," " & PicName),Len(Concat(cSigns," " & PicName))-1)

Am I reading your reply correctly?

Thanks!

[WarrenBelz]

Hi @iwonder ,

No - I was collecting the checked items - are you saying you want them checked? What exactly is the criteria for checking them?

[iwonder]

Hi Warren,

Sorry for my late reply. I was pulled into another project.

I do want them checked.

The gallery gets it's values from a SharePoint list. I want to check the boxes based on a field in a record returned from a SQL database.

The results would look like this (space delimited)

"GHS07 GHS08 GHS09"

I need to split the string and then check each related item in the Gallery. Let's say for argument sake, the first three items in the Gallery relate to the above string.

I also need to select items in a ListBox. The values are all stored in a field, separated by a space just like the Gallery example.

Thanks!

[WarrenBelz]

@iwonder ,

You can use the Split() function to turn the string into a list, then the In Operator to look for the equivalent value in the matching gallery field.

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.

[iwonder]

Hi Warren,

I'm struggling on how to use the IN() Operator. Where do I put that? The Items of the Gallery is already set to my SharePoint list.

Thanks again for your replies and all your help. I really appreciate it.

Edit:

I always want to show all items from the SharePoint list, but just want to check and uncheck as needed (per the Split() list)

The Text for my checkbox in the Gallery is: ThisItem.PictogramName

Do I change it to ThisItem.PictogramName IN(Split(string," ") ?

[WarrenBelz · Accepted solution]

Hi @iwonder ,

Yes - that is the syntax

ThisItem.PictogramName in Split(YourStringName," ")

This will return true or false depending on where the item is in the string. If this is simply checking a box, you can put this code directly in the Default of the control as per below

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.

[WarrenBelz]

Hi @iwonder ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.