Anyway to hide certain column values from given set

Rakesh Sharma 1 Reputation point
2022-05-04T12:30:20.49+00:00

Hi SharePoint Online experts,

Seeking guidance in implementing logic to restrict/hide “Finalised” and “Final Draft” from Status selection list. It is a choice column.
ASK: only PowerAutomate should be able to set these values and user can only be able to set other 3 from drop down in SharePoint.
198873-image.png

Options explored:

  1. Customized form
    a. Drawback, it has to be implemented in all Document Libraries (there are around 8)
    b. Bulk Edit is also required that is not supported in Customized form (https://powerusers.microsoft.com/t5/Building-Power-Apps/Can-t-Modify-Bulk-Edit-Form-in-SharePoint/td-p/714751). Probably SFX button required to cater it
  2. List Validation
    a. getting user detail is not possible in list validation to allow only service account to assign those fields https://learn.microsoft.com/en-us/answers/questions/689220/column-validation-with-username-and-date.html
  3. using the Power Automate to temporarily set the field to Allow Fill-In values and then set it back when applying it.

Any other way to hide 2 field values in choice column for users to select?

Thanks in advance!!

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,242 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Xuyan Ding - MSFT 7,561 Reputation points
    2022-05-05T09:34:52.497+00:00

    Hi @Rakesh Sharma ,

    Per my research, I found that it is possible to filter a single field with Power Apps by calling the filter function.
    Here is a similar thread for your reference: Hiding one choice in a drop down column.

    If you have any further questions, I suggest you go to the Microsoft Power Apps Community for better help.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.