Hi Community.
I have a problem,
When I add data into a dropdown list it default starts with the first value in the column.
I have seen different solutions when using sharepoint as datasource, but I use SQL tables as source.
Br. Tore
Solved! Go to Solution.
@ToreG ,
You could add your SQL table to a collection then create a blank row in order to default on e.g.
ClearCollect(colExample, {Field: ""}); Collect(colExample, <yourSQLtable>)
Then on your dropdown, set the items to colExample and the default to "1" to select the blank record.
Hi @ToreG
Hej Yashag2255.
But if the default value is set to "" and the dropdown is still showing the first value in the column.
I have column A with 20 values, and i dont want it to show any values before the user pick one from the dropdown.
Hi @ToreG
Hi @ToreG
If you want to use the DropDown control rather than the ComboBox control, a possible workaround would be to use a SQL View. In the View, you would UNION a row with an empty string to provide your blank option. Post back here if you need more details.
@ToreG ,
You could add your SQL table to a collection then create a blank row in order to default on e.g.
ClearCollect(colExample, {Field: ""}); Collect(colExample, <yourSQLtable>)
Then on your dropdown, set the items to colExample and the default to "1" to select the blank record.
Thanks Ajennings1.
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
277 | |
235 | |
83 | |
37 | |
36 |
User | Count |
---|---|
357 | |
241 | |
125 | |
72 | |
50 |