Answered

Hiding multiple choices from SharePoint form

(0) Share

Report

Posted on by bf

Hello,

I have a drop down box that lists choices from a SharePoint column. For example, these are 'Not Started', 'Started', 'In Progress', 'Finished' and 'Sent'.

I want to hide 'Finished' and 'Sent' from the PowerApps form, because they are set by another application and I don't want users selecting them from the SharePoint form.

I've done a bit of a search but cannot find a solution that hides multiple items. Can anyone give me a hand?

Many thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(3)

Report
Copy link

Link copied!
Hi @bf ,
Try something like
Filter( Choices([@YourListName].YourFieldName), Value <> "Finished" && Value <> "Sent" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bf ,

Change your dropdown formula like this:
If the column is single line of text:
Filter(Distinct(Sort(SplistName,Title,Ascending),Title),Title<>"Finished" And Title<>"Sent")
If the column is choice field:
Filter(Choices(SampleList.Status),Value<>"Finished" And Value<>"Sent")

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bf ,

Which type column do you use to store these Choice options? Choice type column?

Do you want to hide the 'Finished' and 'Sent' from the Choice field ComboBox List in your SharePoint custom form?

Based on the needs that you mentioned, I agree with @WarrenBelz 's thought almost. Please try the following workaround:

Go to your Sharepoint custom form, unlock the Choice field data card, set the Items property of the ComboBox to following:

Filter( Choices('YourSPList'.ChoiceField), Value <> "Finished" && Value <> "Sent" )

or

Filter( Choices('YourSPList'.ChoiceField), Not(Value in ["Finished", "Sent"]) )

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft thank you for confirming the posts of mine and @KrishnaV - pretty much what we both said.
@bf , please tag whoever you want to continue this thread with.

Was this reply helpful? Yes No
WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bf ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bf ,

Have you taken a try with the solutions we provided above?

Please take a try with above solutions, then check if the issue is solved. If you have solved your problem, please consider go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,

Was this reply helpful? Yes No
bf 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @WarrenBelz , your solution worked.

Sorry for the delay, I only get to play with this every so often.

Is there a quick and easy way to change what's displayed depending on the logged in user? Or should I start another thread for that?

B

Was this reply helpful? Yes No
WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bf ,
The built-in functions User().FullName and User().Email can do this. As neither are delegable, you can set (whichever one you want to use) as a Variable at App OnStart
Set( vUserMail, User().Email )
and then filter against the Variable.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No