Answered

filter a dropdown

(0) Share

Report

Posted on by PArboucher

We have seleted project 1000. Where two resources are aleady part of it (Resource a Developer, Resource 2 a facilatator).

We have 4 roles (Developer, Facilatator, Content, Project Lead)

I have a gallery to add Resource to the project. We a resource is added I would like the role dropdown not to display the role the Resource was already used.

For the first entry Resource 1 the role dropdown should be Facilatator, Content, Project Lead. (Developer was already used)

For the second entry Resource 1 the role dropdown should be Facilatator, Project Lead. (Developer & Content are already used)

For the third entry Resource 3 the role dropdown should be Facilatator, Content, Project Lead, Develper. (No roles have been used)

For the life of me I can't figure it out.

Many thanks

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

Adrian_Celis 1,652 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PArboucher
First, you need to change your Roles dropdown in your gallery into a combobox instead. We will need that later because it retains the selected value even if the choices are gone.
Lets assume your Resource Dropdown is called Dropdown1 and your Roles Combobox is called Combobox1
You have to create a collection like this first:
ClearCollect(collAvailableRoles, Table({Resource: "Resource 1",Role: "Developer"},{Resource: "Resource 1",Role: "Facilatator"},{Resource: "Resource 1",Role: "Content"},{Resource: "Resource 1",Role: "Project Lead"},{Resource: "Resource 2",Role: "Developer"},{Resource: "Resource 2",Role: "Facilatator"},{Resource: "Resource 2",Role: "Content"},{Resource: "Resource 2",Role: "Project Lead"}) )
Then on your Combobox1, change the following properties.
Items property
Filter(collAvailableRoles,Resource = Dropdown1.Selected.Value)

OnChange property
RemoveIf(collAvailableRoles,Resource = Dropdown1.Selected.Value And Role = Self.Selected.Role); If(!IsBlank(varLastRole), Collect(collAvailableRoles,{Resource:Dropdown1.Selected.Value,Role:varLastRole}) );
OnSelect property
UpdateContext({varLastRole:Self.Selected.Role});
SelectMultiple property
false

Let me know if this works.
PArboucher 36 on at

Like
a
(0)

Report
Copy link

Link copied!

hot **bleep** - it got me 98% of the there. Just need to add a delete icon to the gallery & add the "deleted" role back to the collection!
Thanks!!