Custom data card as dropdown with Default Selected Items

(0) Share

Report

Posted on by venka91

1,119

Dear All,

In my sharepoint list i have single line text column as Location.

In the form, i have customized this as "Accepted Values" and made dropdown

In this dropdown i have showing the values from another list.

This works well. However, i wanted to show 'Select' as first value in the dropdown.

Please give some ideas.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Silvester. Akakpo 783 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @venka91 ,
I think you just need to add "select" as part of the items in the other list where the dropdown values are.
And you set the dropdown default to "Select".

Was this reply helpful? Yes No
venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried with it. But that is not happening.

I have two issues here.

1. I want to display the drop down on ascending. So when i add "select" in my list, the select is sorted and not as first value in dropdown

2. If make Default property of my dropdown as 'Select' it is still the showing values from list as the item property has the formula written as Distinct(listname, location)

Was this reply helpful? Yes No
Silvester. Akakpo 783 on at

Like
a
(0)

Report
Copy link

Link copied!
Sure, try this on the DefaultSelectedItems.
LookUp(Choices([@YourList].Column),Value="SELECT")

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @venka91 ,

Firstly Items of the (I assume) Combo Box

Ungroup( Table( { DDItems: Table( {Result: "Select"} ) }, { DDItems: Sort( Distinct( listname, location ), Result ).Result } ), "DDItems" )

DefaultSelectedItems

{Result: "Select"}

or it you want to display existing record values

{Result: Coalesce(ThisItem.Location, "Select")}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

No, my control is drop-down and not combo box. I was trying to set the Default property as "Select' , but still I get values from list as the item peorperty i have the formula as distinct(list name,field name)

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@venka91 ,

Just put the same formula I posted in the Items - you can also have the Default as

Coalsece(ThisItem.location, "Select")

and it will show either Select or (if not empty) the value currently in the field.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @venka91 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No