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"...]
Solved! Go to Solution.
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.
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:
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
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
@PTBBSolutions a simple "single line of text" "text type" my data source is SharePoint and the formulas in my items for the gallery is:
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.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!