About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Get Sharepoint folder URL

  • 2 February 2024
  • 8 replies
  • 94 views
S

Hi all,

I’ve created a zap, which connects my HubSpot CRM with MS Teams. Zapier looks for changes when a customer deal is moved into a specific stage. When this happens it creates a new sharepoint folder and copies information from the HubSšpt deal into a new MS Teams channel post in a dedicated channel. I’m trying to have a sharepoint folder link included in this post for conveneince, but I’m having a hard time configuring the URL, because it seems the URL is parsed in the background and the data fields that are generated do not allow me to concatenate them into a clickable URL.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @SnakeySnake 

To help us have more context, post screenshots with how your Zap steps are outlined and configured, thanks.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S

Hi Troy,

 

thank you for following up! Below is my screenshot:
 

Zapp configuration

So I’ve tested some of the data fields to concatenate an URL but it seems some thing happen in the background and I’m not able to capture the URL parts to put together a clickable URL. I’d be happy to hear if I’m missing somietinhg.

Thanks!

Troy Tessalone
Userlevel 7
Badge +14

@SnakeySnake 

Can you provide an example of the SharePoint URL you are trying to use?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S

Sorry, I need the URL to the folder created in the step 3 and include the URL in the Teams post. Not sure if this is the URL you had in mind? Thank you for your help!

Troy Tessalone
Userlevel 7
Badge +14

@SnakeySnake 

We would need to see an example of the URL that step 3 would create to have context.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S

Sorry for a delay, below is an example of a URL leading to an online folder. I have annonymized it with GPT:

https://[sharepoint-site].sharepoint.com/sites/[site-name]/Shared%20Documents/Forms/AllItems.aspx?RootFolder=%2Fsites%2F[site-name]%2FShared%20Documents%2F[folder-name]&FolderCTID=[CTID-value]
 

Troy Tessalone
Userlevel 7
Badge +14

@SnakeySnake 

If the URL you want has a standardized structure, then you can create the link by using a combo of static and dynamic values.

 

e.g. [CTID-value] would be replaced with a variable mapped from a previous Zap step.

&FolderCTID=[CTID-value]

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
D

Hi all,

I’ve created a zap, which connects my HubSpot CRM with MS Teams. Zapier looks for changes when a customer deal is moved into a specific stage. When this happens it creates a new sharepoint folder and copies information from the HubSšpt deal into a new MS Teams channel post in a dedicated channel. I’m trying to have a sharepoint folder link included in this post for conveneince, but I’m having a hard time configuring the URL, because it seems the URL is parsed in the background and the data fields that are generated do not allow me to concatenate them into a clickable URL.

Once you have the SharePoint folder URL, you may need to format it properly to ensure it is clickable within the Microsoft Teams channel post. The URL should be enclosed within angle brackets (< >) to indicate to Teams that it's a clickable link.

Terms & Conditions