Unanswered

Adding a Blank Value to Distinct Dropdown (or other Options)

(0) Share

Report

Posted on by RJF61

1,265

I have a gallery where I have added a filter pane. Ultimately, I want to set the Items for the gallery so that I display based on the various choices selected in the drop downs. Currently, the dropdowns are based on...Distinct(SPList,fieldname).

Is there a way to add a blank value at the beginning of each dropdown list?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

M_Ali_SZ365 1,110 on at

Like (3)

Report
Hi @RJF61
To add a blank value to the list of distinct values for a dropdown in PowerApps, you can use the following formula:
Table({fieldname: Blank()}, Distinct(SPList, fieldname))

his creates a table with a single blank row and then appends the distinct list from your SPList. You should replace fieldname with the actual field name you're using for your dropdown.
For the dropdown control, set the Items property to this formula. This way, the first option in the dropdown will be a blank value, followed by the distinct values from your SharePoint list.
Please accept this solution if it resolves the issue. ✅
Best regards,
Muhammad Ali

2 people found this reply helpful.

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report

Hello @M_Ali_SZ365 Thanks for the response. Unfortunately, I am receiving an error with the formula provided.

Table({GrpDropdown:Blank()},Distinct(ShortFormII,Group))

Cannot use a non-record value in this context.
The function 'Table' has some invalid arguments.

Was this reply helpful? Yes No
Verified answer

Hassan_SZ_365 542 on at

Like (1)

Report
Hi @RJF61 ,
To add a blank value at the beginning of a dropdown list that uses the Distinct function in PowerApps, you can use the Concatenate function along with a collection that includes a blank option. Here's a simplified method:
Create a collection with a blank value and the distinct values from your SharePoint list field.

ClearCollect( colDropdownOptions, [{fieldname: Blank()}], Distinct(SPList, fieldname) );
Set the Items property of the dropdown to this new collection:
colDropdownOptions

Now your dropdown will have a blank option at the beginning, followed by the distinct values from the SharePoint list field.
Best Regards,
Hassan Raza

Was this reply helpful? Yes No
M_Ali_SZ365 1,110 on at

Like (0)

Report
Hi @RJF61 ,
To add a blank value to a dropdown list in PowerApps, use the Concatenate function with Blank() like this:
Concatenate( Blank(), Distinct(SPList, fieldname) )
Replace "SPList" with your SharePoint list name and "fieldname" with the dropdown's field name. Set the dropdown's Items property to this formula for a blank option followed by distinct values.
Please accept this solution if it resolves the issue. ✅
Best regards,
Muhammad Ali

1 people found this reply helpful.

Was this reply helpful? Yes No
Spamrancher 345 on at

Like (0)

Report

This works but be aware that it will be subject to delegation, so you will only get the distinct values of the first 500 - 2000 records, depending on your settings.

Was this reply helpful? Yes No