Answered

Filter pulled resource from SharePoint on combo box

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi folks, another head scratcher for you!

I'm pulling the information from a SharePoint list column and would like to filter out anything that starts with an open bracket. Is there a way to write this function into a combo box?

E.g. in the dropdown, (Diesel) should not be shown.

On the combo box, items is simply: 'Dog Profiles'.'Dog Name'

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous Use the following formula in the items property of your DropDown.
Filter(yourSPList, !StartsWith(yourColumnName,"(")).yourColumnName
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey CNT, thank you for replying.

Perfect, it did give me a delegation warning but I did a clear collect on the list and it's working perfectly now! 🙂

Thank you!
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous Glad it works! 🙂