Blank field on new form with dropdown

[JimNoredlac]

Hi

If I add new record with a classical form using NewForm(EditForm1);;Navigate(EditScreen1; ScreenTransition.None), all classical fields are empty except the dropdown based on my table with in items Distinct(TableauHeures;IADE)

The dropdown always displays the first value of the table but with a new record, I wish have a blank field.

Do I nedd to add a blank value in my table or is there any other way like in items somthing like: "" & Distinct(TableauHeures;IADE) ?

Thanks a lot for help

[v-micsh-msft · Accepted solution]

Hi,

You need to add Blank as a value inside the table.

Please consider the following steps:

1. Add the following formula under OnVisible property of the EditScreen1:

ClearCollect(Data1,{Result:""});Collect(Data1,Distinct(TableauHeures;IADE))

2. Sepcify Data1 under the Items property of the Dropdown control:

Data1

Doing it in this way should be able to have the Dropdown display blank as the default value.

Regards,

Michael