Is There An Automatic Yes or No Rule Depending On Metadata?

Jones, Quentin 21 Reputation points
2021-06-25T13:39:52.067+00:00

I want to know if it's possible to have an automatic metadata rule that can be incorporated in a SharePoint Document Library and/or folder.

For example let's say I have a 'Choice' column and a 'Yes or No' column. Can it be possible if a user chooses a certain tag from the choice column that it would then automatically select Yes or No in a different column?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,685 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
583 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,941 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Echo Du_MSFT 17,161 Reputation points
    2021-06-28T06:21:08.807+00:00

    Hello @Jones, Quentin ,

    We recommend that you use Choice column instead of Yes/No column. And, you can meet your needs through Microsoft Flow.

    Please following steps:

    1.Go to the list, click on Integrate >> Power Automate >> Create a flow

    109656-1.png

    2.Create Microsoft Flow:

    a.Add the "When an item is created" trigger

    b.Add the "Get item" action

    c.Add "Condition" action : Choice Value contains hp

    d.If yes: add the "Update item" action

    e.If no: add the "Update item" action

    109781-2.png

    3.Save and Test this flow

    4.When you create a new item in the list, it will automatically trigger flow to run.

    109783-create-item1.gif

    Thanks,
    Echo Du

    ==================================

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.