Power Platform Community Forum Thread Details

I have a drop down that is populated from a Sharepoint list called "Interface".

items = Distinct(Interface,Story)

This works fine, but there is always a blank value added to the list. I want to fix that problem, like this:

items = RemoveIf(Distinct(Interface,Story),IsBlank(Story))

When I try this, I get the following intellisense error: "This function can only be used in Action rules".

What am I doing wrong?

Categories:

Building Power Apps

Its better to create an entry of Un-Selected in the list, then set the Default value of the SharePoint field to "Un-Selected".

Then in the AllowedValues Control the default will be "Un-Selected" when a new person creates a new item.

This assumes, the the form has a field like 'Interface' of single line of text from a SharePoint List.

And the lookup pulls data from another list which has a 'Story' entry of "Un-Selected".

Work for me and can be implemented anywhere even lists with unique values.

The problem is that the Not! or Distinct(Filter,XXX),XX) is not supported with the connector or service, or the column doesn't support the code, or the code is not delegatable.

There fore the simple approach I find works well be cause it is supported and deals with Simple Fields.

Community site session details

Populating Drop Down Items with Filtered Collection

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates