Hi,
I have a canvas app with no forms where a user selects an ID in a dropdown and the gallery is filtered, however the gallery is not selecting the items columns in the dropdowns the user uses to input.
For example, the green arrows are the currently selected HOLEID and PEGID that are both unique IDs the orange dropdown is showing the state in the dropdown correctly and in the gallery, the blue arrow is showing other data also correctly in the gallery and in the text input (its currently supposed to be blank)
The big purple arrow is used to filter the gallery, however it doesnt select the item and unless i select the gallery it will show nothing in the text input or dropdown for example see the image below.
The code is the following for each
Purple arrow dropdown (dropdown2_2) items code is : Distinct(TEMPExpCollarData, BHID).Result
the orange arrows dropdown default code is Text(CollarSelectGallery_1.Selected.State)
and orange arrows dropdown items code is [
"",
"ACT",
"NSW",
"WA",
"SA",
"QLD",
"NT",
"VIC",
"TAS"
]
the galleries item code is
SortByColumns(
Search(
Filter(
TEMPExpCollarData,
(
BHID = Dropdown2_2.Selected.Result && Status <> "TEMP" && Status = ddStatusFilter_3.Selected.Value )
),
TextSearchBox_4.Text,
"HOLEID"
),
"Created",
"Ascending"
)
I cant work out why it doesnt show the correct info in the dropdowns and text inputs when i filter the gallery by the dropdown?
Could someone help,
Cheers
