SharePoint List Vertical Gallery & Details Page

[FranciscoSaba]

Hello, 
I'm pretty novice with PowerApps formulas and require some help 🙂

I'm building a Conference Room List repository using the Vertical Galley function in my App. I'm linking it to our SharePoint List, all of the columns on the SharePoint List are Single Text Lines. I have the Vertical Gallery working perfectly, including a search function, but I am having trouble with 2 items:

1. I want the Vertical Gallery to use 2 ComboBox inputs to filter. Currently, the SharePoint List has columns for CountryState and Building. I would like the CountryState ComboBox to filter the Building ComboBox, and the Building ComboBox to filter the Vertical Gallery. 
   
2. In the Details page of the Selected value of the Vertical Gallery, how do I change all the DatacardValue Inputs to ComboBoxes and link the SharePoint list value information, and not affect the formula that I've created on an Add button that will create a new Conference Room list entry in my SharePoint list?
   Much appreciated if anyone can help! 

[v-qiaqi-msft · Accepted solution]

Hi @FranciscoSaba 

1). Set CountryState ComboBox Items property:

Distinct(list,CountryState)

Set Building ComboBox Items property:

Filter(list,CountryState=ComboBox_CountryState.Selected.Value)​.Building

Set the Gallery Items:

Filter(list,Building=ComboBox_Building.Selected.Building)

2). I think the Details page you mentioned is an Edit Form, I would suggest you add a new screen to make a view form to show the selected item from the Gallery, that will only show you infomation, will not affect you create or edit a record.

Add a screen and insert a DisplayForm, set the Item as:

Gallery.Selected

3). To  change all the DatacardValue Inputs to ComboBoxes, you need to delete the TextInput controls and then insert ComboBox, set its Items property as your CountryState ComboBox

Distinct(list,CountryState)​

Set its DefaultSelectedItems property as:

[ThisItem.ColumnName]

Set the Update property of this data card:

ComboBox.Selected.Value