Unable to populate data in a Gallery

(0) Share

Report

Posted on by Sam70

260

Hi,

Kindly go through the attachment. In a screen there are 2 galleries. The one on the left is Gallery1 and it contains multiple rows of Items, along with a checkbox. When all or some of the checkboxes are checked and the Right Icon is clicked, all selected items are populated on the right-side gallery (Gallery2). To get the following the below formula has been used - Collect(galData, Filter(Gallery1.AllItems, Checkbox1.Value));

In Gallery2, the collection galData has been used.

Data is saved after selecting an Account Name in a SharePoint list once Gallery2 gets populated.

Problem arises, when at a later stage i select an Account, Gallery2 is still blank whereas data has already been saved.

Unable to find where i am making the mistake. Kindly help.

Regards

Categories:

General Questions

Screen.png

I have the same question (0)

All responses (3)

Answers (0)

ronaldwalcott 3,827 Super User 2025 Season 2 on at

Like (0)

Report

Unable to populate data in a Gallery

Are both galleries using collections?

When you have populated galData how do you save the items to the SharePoint list?

Are you expecting that when you select the account in the dropdown that gallery 2 will display items? How are you populating the items in galData when the account is selected? Where do you read the items from the list and populate the collection?

Was this reply helpful? Yes No
Sam70 260 on at

Like (0)

Report

Unable to populate data in a Gallery

Hi @ronaldwalcott,

let me answer your queries step wise...

1. Only Gallery2 is using collectio

2. Once Gallery2 is populated with values from galData, it is saved using -

ForAll(Gallery2.AllItems As GD,
Patch('CSI List', Defaults('CSI List'),{Title:ComboBox3.Selected.Title, Activities:GD.Label5.Text, Categories:GD.Label86.Text, Levers:GD.Label91.Text})); Label86 and Label91 are hidden in Gallery2 but their contents are needed while saving data.

3. Yes. On selecting Account (i.e. selection from ComboBox3), data from 'CSI List' should get populated in Gallery2.

4. Formula to populate items in galData - Collect(galData,Filter(Gallery1.AllItems,Checkbox1.Value));

5. To retrieve data from list, i tried using ClearCollect(galData, Filter('CSI List',Title=ComboBox3.Selected.Title)), and here i encounter an error - Incompatible type. We can't evaluate your formula because of a type error.

Using galData to populate selected items from Gallery1 to Gallery2 and once saved using the same galData to collect values from List.

Hope i am able to answer the points you raised.

Regards

Was this reply helpful? Yes No
Sam70 260 on at

Like (0)

Report

Unable to populate data in a Gallery

Hi @ronaldwalcott,

The issue is sorted. One of a column which was supposed to be of Choice type was in Text type. Change made. Thanks for responding.

Regards

Was this reply helpful? Yes No