Hello,
I have a gallery with a Combobox and I'm trying to get items (options) to display on this Combobox based on a value in "ThisItem"
I've tried many formulas without success.
-The Language field is a choice column
Expected result: ["en", "fr"...]
Thank you
Hi @hackondor
Have in mind that Distinct is not deligable - not sure if this matters to you. My last suggestion will be to save+publish the app, close it and re-open it. Sometimes the comboboxes just bug.
Let me know if this helps.
Finally found the solution from this article, thank you guys for your help:
Distinct(Filter('TDS-Generated-Master', 'TDS-Generated-ID'=ThisItem.'TDS-Generated-ID'),Language.Value)
@PTBBSolutions a simple "single line of text" "text type" my data source is SharePoint and the formulas in my items for the gallery is:
Filter('TDS-Generated-Master', Status.Value="Published")
The result is as expected but i have no result when I compare with ThisItem.TDS...
as a workaround, I added a label text and I get the value from there, but my goal is to access the value in the record because language is a choice column and I can't add ".Value" at the end of the formula to get the value
Could you please put thisitem.TDS-Generated-ID in a label control and see the output. Also insert another label and write "thisitem.TDS-Generated-ID = "[the manually copied string from your example]", and see if the result = true
When i filter by the current record like "ThisItem.'TDS-Generated-ID'" I have no error in the formulas but no result either with the message below:
Once I change to the text (hardcoded value) for my filter function like "TDS-Generated-ID'="TDSGEN-68"" I get the expected result but I can't access the value because language is a choice column so get "record", see below:
Regarding your question:
DisplayFields: ["Value"]
SearchFields: ["Value"]
Best
What is the error which you get? Or the combobox is just empty?
Please check if the Search Values and the Display Values of the combobox are referring to the correct name.