Answered

Not all options are showing up in combo-box

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I have an app linked to a SharePoint and there's a combo-box where one can choose one or multiple departments to show everyone in those selected departments. I am using this formula for the combo-box:

Sort(Distinct('SharePoint', department), Result, Ascending)

This formula doesn't show all the departments. There are 18 different departments in the SharePoint, but the drop down only shows 8. I found another way, where I just manually inputted all the 18 departments in the items property of the combo-box, and it works perfectly. However, I want it where if a new department is added in the SharePoint, I don't have to go into the code of the app to add it and instead it just automatically loads in the PowerApps. Is there another way to do this?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous ,

Firstly, how big is your list and what do you have your Delegation limit set to? Distinct() is not Delegable and will only return values from the first number (your delegation limit) of your list records.

If you want to add a new record, you will need a separate list with one filed (you can use the Title Field) with all the Departments and on the OnSuccess of your Form

With( { wDept: LookUp( YourNewList, Title = Self.LastSubmit.Department ).Title }, If( IsBlank(wDept), Patch( YourNewList, Defaults(YourNewList), {Title: wDept} ) ) )

The Items of the Combo Box would then be

YourNewListName.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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I have more than 2,000 items in my list. I was wondering where to find the OnSuccess property on my form?

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

Like (1)

Report

Hi @Anonymous ,

Just select the form and it is in the drop-down list at the top left.

Was this reply helpful? Yes No