Answered

Populate Drop Down Menu based on query

(0) Share

Report

Posted on by vicariduarte

I´m working in an App to register users interest in some courses. This app store data in a List with the fields NAME and COURSE.

We have actually just five courses, so, the user select it in a DropDownMenu (Course 1, Course 2 etc).

I want that if the course has 40 subscrites, it not appears in the dropdown menu.

Does anyone have some suggestion?

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@vicariduarte ,

What are the Items of the drop-down?
vicariduarte 6 on at

Like
a
(0)

Report
Copy link

Link copied!

The Courses (Course 1, Course 2, Course 3 etc).
But, if that course has more than 40 subscribers, it not appear in the drop-down.
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@vicariduarte ,

What is the actual (exact) Items code? There is no 40 item limit, so I am not sure where that is coming from.
vicariduarte 6 on at

Like
a
(0)

Report
Copy link

Link copied!

The 40 limit is not a MS List limit. Its a business rule. I can´t accept new subscribers if that course if full (40 students).
So, for example, I have 5 courses (1, 2, 3, 4 and 5). It will appear in the combobox just the courses that has not 40 subscribers yet.
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@vicariduarte ,

So I am clear, you want to exclude the course from the drop-down if there are 40 subscribers? It would be easy to give a warning (and not allow selection) , but dynamically removing it would be quite complex.
vicariduarte 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, exactly. Can be a simples warning or not allow selection. How can I do it? My difficult is in obtain from the List a somatory of all subscribers for each course.

Actually I´m using a GroupBy Function, that give me the sum of subscribers, then i make a new Collection just with the register with less than 40. So i take this collection and fill the drop-down. But again, this is not so efficient, I´m sure that there is a better solution.
Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @vicariduarte ,

On the OnChange of the drop-down, something like this

If( CountRows( Filter( YourListName, YourCourseFieldName = Self.Selected.Value ) )>40, Notify("This course is full - you cannot select it",Error); Reset(Self) )

I assume you have a Choices field for the courses, otherwise .Value may be different.

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.