Filter Power Apps drop downs by other fields

[Anonymous]

I have created 2 combo box "cbt name" and "customer unique name".

I want values in "customer unique name" such a way that only relevant values shows as per the selection done in CBT name.

Filter('LAT APP data',CBT Name= DataCardValue11.Selected.result).

But the above function is not working.

DataCardValue11 is the combo box for CBT name.

PLS Help.!!

[eka24]

If CBT name is a column, put it in single quotes:

Filter('LAT APP data','CBT Name'= DataCardValue11.Selected.result)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Anonymous]

single quotes also not working.

I'm confused what name should i put in.

Attaching the scrrenshot.

lat app data is sharepoint list.

[BrianS]

Combo boxes can return a table, which I believe is the issue here. If you want a single value to search on you can use .Value instead of .Result - I believe. If you are selecting multiple names of Customers that is a different issue.

[Anonymous]

Now getting error that datacardvalue11 not supported.

Attaching screenshot.

[BrianS]

If you are only trying to select one customer I would suggest using a dropdown, not a Combo box. Dropdowns only return one value and can be used with the Filter formula yo have.

[BrianS]

Looking more closely at the error, it appears that PowerApps is not picking up the control correctly. I would try saving, and exiting PowerApps. Then go back to editing. You may also need to delete that formula and re-enter it. 

However the caveat about the Dropdown vs Combo box holds. This formula will only look up the first selection in the Combo Box, I believe.

[Anonymous]

There are multiple values in CBT Name and Customer name as well.

[eka24]

Take a screenshot of the formula on the first dropdown. Also can you show a sample of your table

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[BrianS]

I would take a look at this video:

https://www.youtube.com/watch?v=pjs0ZsnJZXo