Hello - hoping someone can help me -
Very simple what I'm looking to do, and that's use a dropdown menu to filter a gallery created with a Sharepoint list. Once the gallery is filtered, I want the user to select an item from the gallery and have the "Title" populate in the Data Card Value (Diversity Influencer Name is the form control). Here are the details:
Screenshot of Screen1:
Screenshot of SharePoint List/Data Source:
Screen1:
OnVisible:
ClearCollect(CollectDiv, {Value:"ALL"});
Collect(CollectDiv, Distinct('Diverse Volunteers for Interview Panels',Division.Value))
Drop Down Menu: DivisionChoices:
Items: CollectDiv.Value
Here's a screenshot of the collection:
Default: "ALL"
Please note that all 6 Values are showing up in the DivisionChoices Drop Down
Gallery:
(located in Edit Form Control)
Items: If(DivisionChoices.Selected.Value = "ALL",'Diverse Volunteers for Interview Panels', Filter('Diverse Volunteers for Interview Panels',Division.Value = DivisionChoices.Selected.Value))
OnSelect: UpdateContext({VarSelPer:ThisItem}); Reset(DataCardValue3)
DataCardValue3:
(located in Edit Form Control)
Default: VarSelPer.Title
There are two issues happening that I cannot seem to figure out:
1. The Gallery is only filtering for ALL and CROP SCIENCE. When I select PHARMACEUTICALS, CONSUMER HEALTH, ABOVE COUNTRY or ENABLING FUNCTIONS, the gallery is blank. ALL and CROP SCIENCE are the first two choices in the drop down menu.
2. The Title (should be first and last name) of the selected gallery item is not populating in DataCardValue3.
Does anyone have guidance on a potential fix?
Thanks in advance!
