Answered

Decaying Dropdown

(0) Share

Report

Posted on by TerrificTerri

205

I have a need for a "decaying dropdown". What I mean by this is....I have a list of people ready to be assigned to a project. Once they are assigned, their name is removed from the available list. I created a choice column with true false values and added them for the employee (true = available). Powerapps seem to be looking at these values just fine and I have a table that I have been able to successfully sort and filter with the true false values. Where I am stuck is how to make the value change when the selected employee is picked for deployment, and how to change the value back if for some reason the deployment does not happen. I thought of an "IF" statement on the availablity true false field, but doesn't seem like it's right. Any help and or ideas would really be appreicated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi TT,

Given your description, it sounds like you could use a gallery with a toggle added. What is the data source for your table?

Was this reply helpful? Yes No
TerrificTerri 205 on at

Like
a
(0)

Report
Copy link

Link copied!

SharePoint is the data source

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi TT,

I think this may be what you are looking for. I created this from a list of over 2000 doctors in one of my sharepoint files. That list has a column Referral analogous to your Available column that was orignally a choice column. I have a problem with patching sharepoint choice items so I changed the type to single line text before I generated the Powerapp. This did not affect the underlying data but it is now Text that is either "True" or "False". After creating a new app from the Sharepoint connector, I modified the browsegallery by adding a Toggle switch. The only changes that I made to the newly generated app related to the Toggle properties otherwise the app worked well: The Toggle properties modified were:

Default - If(Referring="True",true,false).
OnCheck- Patch(Doctors,ThisItem,{Referring:"True"})
OffCheck - Patch(Doctors,ThisItem,{Referring:"False"})
TrueText - ."Deployed"
FalseText - "Available"

I hope this example can be used for your app.

Was this reply helpful? Yes No
TerrificTerri 205 on at

Like
a
(0)

Report
Copy link

Link copied!

OMG I am trying this now and it just makes more sense than what I started with. Thank you for your time and awesome information sharing!

Was this reply helpful? Yes No