Answered

Create filtered dropdown for SharePoint List

(0) Share

Report

Posted on by trandallvermont

I'm running into an issue creating a dropdown field for a SharePoint form. Here is some example data:

When a new item is entered, I would like to set the Hub Site field to be a dropdown that lists only the sites where the Hub Site Status is Hub Site. I can't seem to get the right formula.

The closest answer I found online was using this formula where IsHubSiteLookup is a calculated field that shows the title when Hub Site Status is Hub Site.

Filter('AHS SharePoint Sites', IsHubSiteLookup<>"").Title

This results in a dropdown menu with blank options (although this list is roughly as long as I would expect if the hub sites were showing).

Anyone doing something similar find a way to make it work?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

mdevaney 29,989 Moderator on at

Like (0)

Report
@trandallvermont
Please remove the calculated column from SharePoint. You don't need it.

Then create a dropdown and use this code in the Items field. My assumption is 'Hub Site Status' is a single line text field.

Filter('AHS SharePoint Sites', 'Hub Site Status'="Hub Site").Title

Now the dropdown will only show relevant results.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @trandallvermont ,
Something like
Filter( 'ABS SharePoint Sites', 'Hub Site Status' = YourHubStateStatusdd.Selected.'Hub Site Status' ).Title

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report
Hi @trandallvermont ,

According to the issue that you mentioned, please make sure that you have set the "Title" column as Display column value in your "Hub Site" Dropdown box/ComboBox.

Actually, I think it is not necessary to add a Calculated field in your SP List to achieve your needs, simple Filter function could achieve your needs. Please consider take a try wit the following workaround:

Set the Items property of the "Hub Site" Dropdown box/ComboBox to following:

Distinct( Filter('AHS SharePoint Sites', 'Hub Site Status'.Value = "Hub Site"), Title )

Then set the "Result" column as Display column value in your "Hub Site" Dropdown box/ComboBox.

Then set the Update property of the "Hub Site" field data card to following:

HubSiteDropdownBox.Selected.Result

Note: I assume that the 'Hub Site' column is a Text type column in your SP List, and the 'Hub Site Status' column is a Choice type column in your SP List.

Best regards,

Was this reply helpful? Yes No