Power App dropdown and SQL Server View - show description when given a code?

(0) Share

Report

Posted on by CU25081109-1

Hello

I am relatively new to Power Apps.

I want to have a dropdown in my Power Apps canvas app that shows the description of a health board given a code for that health board from ThisItem.

e.g. of view -

Code : AA Description : Ayrshire

Code : GL Description : Glasgow

...

ThisItem.BoardCode = GL, I want the dropdown to show Glasgow.

I have set my items of the dropdown to -

vwHealthBoard

with Value - boardCode

Default value to -

ThisItem.boardCode

When I run the dropdown shows the list of codes.

I tried changing the view value to boardDescription and the dropdown is empty.

So how do I change it so that the dropdown shows the description for the code?

Any help will be greatly appreciated.

Thanks

Kevin

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

NZ0090 317 on at

Like (0)

Report
Hi @KevBarrie ,

Assuming vwHealthBoard is your table name, on the Items property of your dropdown, write:
Distinct(vwHealthBoard, boardDescription)

You can leave the Default property empty.

Was this reply helpful? Yes No
CU25081109-1 49 on at

Like (0)

Report

Hi @NZ0090

I tried that. It does display the list of boards in the dropdown. But the default is blank, I want it to match with ThisItems.boardCode. i.e. if ThisItems.boardCode = GL, the default items shows Glasgow.

Thanks.

Kevin

Was this reply helpful? Yes No
NZ0090 317 on at

Like (0)

Report

Where does ThisItems.boardCode came from? A gallery? Is the dropdown inside or outside of the gallery? And if it's a gallery, do you want the default pf the dropdown to be the selected boardcode of the gallery?

Was this reply helpful? Yes No
CU25081109-1 49 on at

Like (0)

Report
I have a collection that is a table from SQL Server -

ClearCollect(collectionDetails, tbldetails)

I connect my gallery to this collection in items -
Last(FirstN(collectionDetails,recCount))

This collection has the boardCode column.

The dropdown is in this gallery.

The items of the dropdown are a view of a table in SQL Server -
vwLUTDropdownHealthBoard

This view holds the boardCode and board desc e.g.

BoardCode : "AA", BoardDescription : "Ayrshire"
BoardCode : "GL", BoardDescription : "Glasgow"

I want the dropdown to list all the BoardDescriptions and the default value to be the board description of code given.

So when ThisItem.boardCode is "GL", the dropdown shows Glasgow.

I hope that makes sense.

Was this reply helpful? Yes No