Answered

Filter for ComboBox items (options) and display choice column value

(0) Share

Report

Posted on by hackondor

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

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

PTBBSolutions 691 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
hackondor 37 on at

Like (0)

Report
Copy link

Link copied!

Hi @PTBBSolutions

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

Was this reply helpful? Yes No
PTBBSolutions 691 on at

Like (0)

Report
Copy link

Link copied!

@hackondor

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

Was this reply helpful? Yes No
hackondor 37 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
PTBBSolutions 691 on at

Like (0)

Report
Copy link

Link copied!

Hi @hackondor

What is the data type of thisitem.TDS-Generated-ID coming from the source?

Was this reply helpful? Yes No
hackondor 37 on at

Like (0)

Report
Copy link

Link copied!

@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")

Was this reply helpful? Yes No
Verified answer

hackondor 37 on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
PTBBSolutions 691 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No