I have a site structure to organize project sites on SharePoint Online.

Site Collection = Business unit (Eg. "Europe")
      -- Site = Country (Eg. "Norway")
          -- Subsite = Project name

On the project subsite I have document libraries. The documents and document sets should be tagged with all of the above in separate columns. (Eg. Europe + Norway+ Project site name)

Any advice on how to accomplish this with a SharePoint Designer Workflow?


First of all, I'm sorry for not being able to provide screenshots to you.

For resolving your problem I'm thinking about the SP API. You can find an exemple of using the API with a workflow on this blog post, I tried it for a project and it works very well. So, here is a method, step-by-step :

  1. Get the current site URL (project level) using workflow context variables
  2. Build the API URL with "site_url /_api/web/title" (see this post)
  3. Add an HTTP Request in your workflow (see first link)
  4. Extract the title from the JSON response variable (again, see first link)
  5. Set your column with the result
  6. Repeat with BU and Country level by spliting the URL on the "/".

If your site tree structure is "static", you could also use a list for referencing the project-to-country relation and call this with the API (one call vs. three).

Hope it helps.

  • Thx! I'll try this approach :) – IngeN Jan 20 '16 at 9:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.