Answered

Power Apps nested Gallery, Issue selecting data(SharePoint List) in childGallery dependent of parentGallery

(0) Share

Report

Posted on by DonLimpio

Hi,

I want to create a table to find/display/edit the content of a SharePoint List. The table consists of 2 nested Gallery, parent Gallery is the header and the child Gallery displays the data of the table.

I have Issues selecting a column in the SharePoint List (depending on the value of the parentGallery(header) Label) and feeding it in the Items of childGallery, childComboBox and parentComBox.

-The parent Gallery is composed of a ComboBox and a Button(consider it's a Label) displaying the column name.

DataSource for the parent Gallery is a Collection created OnStart of the App. It maps the column of the SharePoint List that I want to display and contains other info for formatting the columns, control behaviour, etc. The Items for the ComboBox come from the SharePoint List corresponding column.

-The child Gallery is composed of ComboBox in view mode. DataSource of the child Gallery is the SharePoint List filtered with the selection of the ComboBox in the parent Gallery.

What I have tried to filter the Items in childGallery, childComboBox and parentComBox:

parent Gallery: ComboBox.Items issues
- parentGallery.Items = headerCollection [OK]
  - parentComboBox.Items = ShowColums(SP_List, ThisItem.HeaderLabel) [ERROR]
  - parentComboBox.Items = childGallery.AllItems [ERROR]

child Gallery: childGallery.Items & ComboBox.Items issues
- childGallery.Items = SP_List [OK, but it's going no were]
  - childComboBox.Items =ShowColums(ThisItems, Text(parentLabel.ThisItem.Text)) [ERROR]
- childGallery.Items = ShowColums(SP_List, ThisItem.HeaderLabel) [ERROR]
  - childComboBox.Items = ShowColums(SP_List, ThisItem.HeaderLabel) [ERROR]

How can I select a column in a Collection(ThisItem, galleryControl.AllItems) and/or SharePoint List from galleryControl.ThisItem."txt value" and feed it in the Items for a Gallery and ComboBox?

Or is there another way to achieve the behaviour I'm looking for?

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@DonLimpio If I get it right you do want to reference a column dynamically. That's not possible in powerapps. Sorry 😔

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.

Was this reply helpful? Yes No
DonLimpio 67 on at

Like (0)

Report
Copy link

Link copied!

@PowerRanger referencing column dynamically would be a more elegant solution but I can work around that using a switch for the childrenGallery.Items .
I still have issues, with the parentComboBox and childenComboBox I can't figure out how to have them display the SP_List value of the corresponding column.
I used the same switch (see childrenGallery.Items) for the parentComboBox.Items
Job ComboBox show 4/5 of the available choices
ID and ParentID ComboBox show 4/4 of the SP_List line but they are empty.
I tried childrenComboBox.Items = ThisItems
I also tried to hard code it childrenComboBox.Items = Jobs.ID
ComboBox's are empty in both situation

Is there a reason why the ComboBox's are not displaying the value correctly what can be done to fix this?

Thanks for your answer

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@DonLimpio please have a look at the edit fields command in the property pane on the right side when selecting your combobox. Here you can define what fields should be shown. It could be that powerapps has selected a column with no values.

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.

Was this reply helpful? Yes No
DonLimpio 67 on at

Like (0)

Report
Copy link

Link copied!

@PowerRanger I inserted a new ComboBox and that fixed my issue. I think I initially copied the ComboBox from a Form and they were not behaving like standard one?

I don't really understand the logic/general concept behind PowerApps, It seems like every situation has an exception or a unique way of being treated. I have the feeling my learning curve is pretty linear as I don't find the way to leverage what I already know and apply it to new concepts.
Is it normal?
Do you have good resources you recommend (apart from Microsoft doc and forum) to help me figure out how to work with PowerApps and how the app creation should be approached?

Was this reply helpful? Yes No
sajidakram 104 on at

Like (0)

Report
Copy link

Link copied!

First

Was this reply helpful? Yes No
alde_zaw 13 on at

Like (0)

Report
Copy link

Link copied!

I could sort out this issue creating a gallery in a gallery, but I have next step issue not being able to link with selected data in another form or gallery. As you may see in the picture, the green pane would be a form that shows the record of selected item from the menu on orange pane.
Anyone who knows how to solve this, please help. My issue post >> Nested Gallery and SP List Connection

Thanksss ❤️

Was this reply helpful? Yes No