Unanswered

Dropdown function returning the wrong column

(0) Share

Report

Posted on by vinidegrandi

I am trying to create this simple dropdown that will display the citys in which the company has clients in. I used a SortByColumns function and specified what I want to display with "i9_name" but it keeps returning the "createdby_type" column with a bunch of "systemuser". What exactly am I doing wrong here?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Bilakanti 1,226 on at

Like (1)

Report

@vinidegrandi - Please check the display fields property and add the column that you need to be shown.

Was this reply helpful? Yes No
vinidegrandi 67 on at

Like (0)

Report

@Bilakanti you mean the DisplayMode property? What exactly am I supposed to write in it?

Was this reply helpful? Yes No
vinidegrandi 67 on at

Like (0)

Report

Oh, nevermind. I understand what you meant now. The issue now is its telling me it reached the limit of items it can display.

Was this reply helpful? Yes No
Bilakanti 1,226 on at

Like (0)

Report

@vinidegrandi - In my case i added a combobox and by default it came with"bk_employeeid" column as part of displayfields, and I want to show "bk_employeeaddress" column to be shown in the dropdown, so I just added"bk_employeeaddress" column in the first item and it worked like a charm. Hope that should resolve your issue.

Was this reply helpful? Yes No
vinidegrandi 67 on at

Like (0)

Report

Yes, I realized I had a regular dropbox and not a ComboBox. It did "work" but it is basically showing me every city ever instead of the ones on the table.

Was this reply helpful? Yes No
Bilakanti 1,226 on at

Like (0)

Report

@vinidegrandi "i9_name" is a lookup column pointing to another table? If you want unique city names then you can use Distinct function to retrieve only unique city names.

Was this reply helpful? Yes No
vinidegrandi 67 on at

Like (0)

Report

It is not. Inside this column there is only a handful of cities but its returning me every city on the planet haha

Was this reply helpful? Yes No
Bilakanti 1,226 on at

Like (0)

Report

@vinidegrandi Can you please share what is your items property and what is the data in the table.

Was this reply helpful? Yes No
vinidegrandi 67 on at

Like (0)

Report

My items property is the picture I've shown, and the table is right under it, but here it is in more detail:

Was this reply helpful? Yes No
Bilakanti 1,226 on at

Like (0)

Report

@vinidegrandi - As per your screenshot, I am sure it will show only the data from that table. Just to cross check, I would suggest you to count the rows in dropdown and count the rows in table whether both of them are matching or not.

Was this reply helpful? Yes No