Drop-down: Need to add "Please Select" to drop-down

Like (0) Share

Report

Posted on 1 Feb 2023 00:27:20 by MicroMarc365

101

I have a drop down pulling from a SharePoint list. The default value of the drop down is set to the first user listed in the drop down. Does anyone know how I can add "Please select" to the drop-down.

This is the data that I have under Items:

Sort(Filter('Contacts List', 'Variance Approver'.Value="MfgEng" ||'Variance Approver'.Value="QA"),Title,Ascending)

Categories:

Using Apps Using Formulas

All responses (2)

Answers (1)

MicroMarc365 101 on 01 Feb 2023 at 15:03:26

Like (0)

Report

Re: Drop-down: Need to add "Please Select" to drop-down

That worked! Thank you so much!
Verified answer

v-bofeng-msft on 01 Feb 2023 at 01:23:09

Like (1)

Report
Re: Drop-down: Need to add "Please Select" to drop-down

Hi @MicroMarc365 ,

Please try:

Ungroup( Table( {Value:Table({Title:"Please Select"})}, {Value:Sort(Filter('Contacts List', 'Variance Approver'.Value="MfgEng" ||'Variance Approver'.Value="QA"),Title,Ascending)} ), "Value" )

Best Regards,
Bof