Unanswered

Dropdown default value selection from table, but also option for blanks.

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I have the following issue. I have a page with 10 dropdown fields. All populated with: [@PowerBIIntegration].Data.Name
Data is comming from Power BI as you can see

I've set AllowEmptySelection as true. So they can select blanks if wanted.

Now i would like to have the 1st dropdown a default value of the 1st item in the [@PowerBIIntegration].Data.Name table, and the 2nd the 2nd in the [@PowerBIIntegration].Data.Name table etc. But still be able to set them blank.

Im not sure if this is possible, because when i try to set a default value "test" it doesnt do anything. Can anyone help me with this? is it even possible to achieve what i want?

Thankyou.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

eka24 20,923 on at

Like (0)

Report

If you want the Default then set AllowEmptySelection as false.

If that doesn't do the trick, then add:
You can the sort: Sort([@PowerBIIntegration].Data.Name,Name)
------------

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I want a default value of one of the rows in the table. Like the first drop down has 1st value, 2nd drop down has 2nd value as default.

But i also do not want to lose the option to set it to blank, if wanted.

Also sorting the items is not what i need.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Hi@EricHulshof,
Based on the issue that you mentioned, do you want to set the default value and allow empty selection within a Dropdown?
I have a test on my side, please take a try as below.
Set the AllowEmptySelection property as:

true

Set the Items property of the Dropdown as:

[@PowerBIIntegration].Data.Name

Set the Default property of the first DropDown:

First([@PowerBIIntegration].Data.Name).Value /The first Dropdown Last(FirstN([@PowerBIIntegration].Data.Name,2)).Value /The second Dropdown Last(FirstN([@PowerBIIntegration].Data.Name,3)).Value /The third Dropdown … Last(FirstN([@PowerBIIntegration].Data.Name,10)).Value /The tenth Dropdown

Note: If you want to set the default value of each Dropdown, you just need to set the Default property of each Dropdown as the above. Make sure that you should make the data type matched as a Text value. To solve this, you need to add “.Value” behind the Last().
You can check the attachment for reference.
Best Regards,
Qi

Was this reply helpful? Yes No