Unanswered

Removed Selected Items from Dropdown

(0) Share

Report

Posted on by penny4

Hi. I have a form and the fields are coming from a List called "AccountDetails" inside my form I switched the "Title" to be a dropdown that is pulling from a List called "AccountDetailsTitles".

I am using the same form for New and Edit. I have it set up so I can create multiple entries to the "AccountDetails" List for a single Client. When information is added for that client and if I go to add another entry for the same client I want to hide the dropdown choices that were already selected.

This is the code on the Default of the dropdown

If(AccountDetailsForm_2.Mode = FormMode.Edit, glr_AcctDetail_HSLE_2.Selected.Title)

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
HI @penny4,

If you want to filter out the existing title from the dropdown list, I think you should set the Items property of the dropodwn as below:

If(AccountDetailsForm_2.Mode = FormMode.Edit,Filter(List,!(Title in AccountDetailsTitles.Title)),Your_Original_Items_formula)
penny4 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. I will try it out and let you know!
penny4 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I have applied the code to the Items section of my drop down If(AccountDetailsForm_2.Mode = FormMode.Edit,Filter(List,!(Title in AccountDetailsTitles.Title)),AccountDetailsTitles) and am receiving the following Warning: The columns produced by this rule are all nested tables and\or records, however the property expects at least some columns of simple values (such as text, or numbers).
I also have an error on my Update: Name isn't valid. 'Title' isn't recognized.
This is the code on the update DetailsTitleDrp_1.Selected.Title
I only get this error when adding the formula for the item