web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter(remove) one of ...

Power Apps

Answered

Filter(remove) one of the options in SharePoint choices available in editform datacard

(0) Share

Report

Report

Posted on by keithcortis

47

Hey,

I have a list on SharePoint, and I'm building a canvas app for it.

One of the DataCards is for Document type (Column name: Doc. Type... in URL: DocType), and has 5 options in SharePoint.

I want to remove one of the options in the Powerapps dropdown (that highlighted yellow) and only give the user the remaining 4 options, WITHOUT removing the option from Sharepoint.

I tried using the Filter formula but I am getting nowhere.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @keithcortis that is certainly possible by filtering out that specific value in the Item property of the DataCardValue (dropdown). Could you try the code below:

Filter(Choices([@'Master Agreement List'].'Doc. Type'), Value <> "MSA/ GSA/ Main Agreement")
(between quotes, the value should match the option exactly. Should I have misspelled something, please adjust.)

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
keithcortis 47 on at

Like
a
(1)

Report
Copy link

Link copied!

I think i tried this a million time..... mine didn't work, yours worked perfectly.
Thank you for the early Christmas present 😄

Join the conversation