Answered

Unique Dropdown Selection Based on SharePoint List

(0) Share

Report

Posted on by Applications

Hello all!

I'm trying to get a unique list of phone numbers from a SharePoint list, and if you assign a phone number, it wont be available in the dropdown anymore.

Here is my current formula within the form:

Filter('New Arrivals', 'Name (Title)' = "Vacant")

So it needs to reference the other names in the list that are titled "Vacant" and then when a number is assigned, it pulls it off of the dropdown.

Any thoughts?

Categories:

General Questions

Using Apps Using Formulas

All responses (3)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report
Re: Unique Dropdown Selection Based on SharePoint List

Hi @Applications ,

I did a sample for you.

Filter(ForAll(LIST261.PhoneNumber As A,If(Not(A.PhoneNumber in Concat(Filter(LIST262,!IsBlank(phoneNumber)),Text(phoneNumber),";")),A.PhoneNumber)),!IsBlank(Value)

Hope it can help you.

Best Regards,

Wearsky
Applications on at

Like (0)

Report

Re: Unique Dropdown Selection Based on SharePoint List

When I use this one it lists all of the phone numbers, not just the ones for "Vacant", including the ones that have already been used
@Drrickryp
Drrickryp 30,490 on at

Like (0)

Report
Re: Unique Dropdown Selection Based on SharePoint List

@Applications

Items for dropdown:

Filter('New Arrivals', 'Name (Title)'<> "Vacant")