Unanswered

Drop down menu.....minus one option

(0) Share

Report

Posted on by EuniceG11

Hi,

I have a dropdown option in a form that is pulling from a choices column in a SharePoint list. I want the users to see all the available options except one. Is there an easy way to do this without having to manually type in all the options. Can I change the following formula in some way to not show one of the options:

Choices([@'PMO Portfolio Monthly Updates'].'Work Title')

Thank you in advance!

Eunice

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @EuniceG11 ,

Could you try:

Filter(Choices([@'PMO Portfolio Monthly Updates'].'Work Title'), Value <> "Something")

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
EuniceG11 50 on at

Like (0)

Report
Copy link

Link copied!

I tried that but am getting a red line under the comma.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@EuniceG11 - that's not the expression I gave you...

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Just checked this post as I needed the same problem to be solved but in dataverse and with help of previous suggestion I have found an answer to this one... You probably don't need it anymore but I'll leave it here:

Filter(Choices([ListName].ColumnName), Value <> ChoicesName.ValueToBeExcluded)

Was this reply helpful? Yes No