web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : I+3oroNELm5so5xxqCAILc
Power Automate - Building Flows
Unanswered

Different column tag options per set of different folders

Like (0) ShareShare
ReportReport
Posted on 22 Dec 2020 11:22:50 by

Hello, 

Does anyone know if it's possible to set different column tags depending on which folder document is being uploaded to?

The only similar thing I was able to achieve was to create a Term set, but it doesn't solve the problem completely as someone can still pick a root Term as a tag, instead of using a root Term only as a reference for its tags.

Veingro_0-1608635921512.png

I have the same question (0)
  • Community Power Platform Member Profile Picture
    on 23 Dec 2020 at 14:05:05
    Re: Different column tag options per set of different folders

    @Expiscornovus Hi, me again. 😉 Let's say I want to go with the column default value setting, but- the folders are not there yet. They will be created automatically triggered by adding a list item. At this point I can't configure this setting as I can only see one location- which is my library in general. 

    Veingro_0-1608732184854.png

     

  • Community Power Platform Member Profile Picture
    on 23 Dec 2020 at 09:29:50
    Re: Different column tag options per set of different folders

    Thank you. Looks tough, but I will give it a try. 

  • Expiscornovus Profile Picture
    32,205 Most Valuable Professional on 22 Dec 2020 at 16:05:21
    Re: Different column tag options per set of different folders

    Hi @Anonymous,

     

    Thanks for clarifying your requirements.

     

    As far as I am aware this is not possible from a SharePoint interface perspective. You are associating the whole term set to one specific column. So, it's also possible for the end user to select items from that whole term set. That won't be filtered.

     

    An alternative solution would be the creation of an SPFx control to interact with that term set and pre filter it by using code: https://pnp.github.io/sp-dev-fx-property-controls/controls/PropertyFieldEnterpriseTermPicker/

     

     

  • Community Power Platform Member Profile Picture
    on 22 Dec 2020 at 15:27:01
    Re: Different column tag options per set of different folders

    Hello @Expiscornovus and thank you, however I don't want to automatically apply values to documents based on folder name, I want to create options of values for this particular folder and different values for different folders.

     

    So document uploaded in folder A can have options : 1-5
    in folder B: 6-9, 

    but all 1-9 option have to be within one column. 

  • Expiscornovus Profile Picture
    32,205 Most Valuable Professional on 22 Dec 2020 at 14:17:49
    Re: Different column tag options per set of different folders

    Hi @Anonymous,

     

    If you want to automatically apply the correct term value based on a folder you can just used the Column default value settings of a SharePoint library. You won't need to create a Power Automate flow for this.

     

    1. Setup your specific folders and create your metadata column (in my example CustomMetadata).

    2. Go to Library Settings > Column default value settings

    columndefaultvaluesettings.png

    3. Set up the default term value per folder (in my example FolderA with term value Microsoft Teams)

    defaultvalueperfolder.png

    4. Test it by uploading and creating a couple of files, it should inherit the value from the folder

    testingexample_metadata.png

     

    Hope this helps a bit?

  • Community Power Platform Member Profile Picture
    on 22 Dec 2020 at 13:59:28
    Re: Different column tag options per set of different folders

    @annajhaveri Hi Anna, do you have any idea if it's possible or maybe can you suggest a different solution, please?

    🙂

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading started
Loading complete