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.
9,607 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.
508 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,798 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Echo Du_MSFT 17,116 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.