cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Send email notification when new folder is folder is created

I currently have a flow that creates a new folder based on a file attachment (see https://powerusers.microsoft.com/t5/Building-Flows/create-new-folder/m-p/117084/highlight/true#M1134...) in a document library in SharePoint.   Last step is to create an EMail notification that will include a link to the newly created folder.    Searched and what I was able to find is Link to an item (files) when using the "when a file is created" action.  Really need, "when a folder is created" action but it's Not available yet which I have voted on User Voice.  

 

Does anyone know of a way to include the URL to the folder in a document libary when creating an Email notification?   I've tried the below but it puts a space between the URL library and the output, would like the output to be a part of the URL.  

SEnd Email_ Include LInk.png

 

 

 

Output:

Output.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Send email notification with new folder URL when new folder is created

Hi @Anonymous,

 

Could you please share a screenshot of your flow's configuration?

Do you want to make the output dynamic content (folder name) to be part of the URL that you mentioned?

 

If you want to make the output dynamic content (folder name) to be part of the URL that you mentioned, I think the concat() function could achieve your needs. I have made a test on my side and please take a try with the following workaround:8.JPGWithin Inputs fields of "Compose" action, type the following formula:

substring(split(item()?['Name'],'Report')[1],0,8)

Within Body field of the "Send an email" action, type the following formula:

concat('https://xxxxxx.sharepoint.com/sites/PowerApps/Reporting1/',outputs('Compose'))

Note: The 'https://xxxxxx.sharepoint.com/sites/PowerApps/Reporting1/' represents the SP library URL on my side, on your side, you should type the following formula:

concat('https://mycatalina.sharepoint.com/sites/NetworkEngineering/AppResponse%20Reports',outputs('Compose'))

The flow works successfully as below:9.JPG

 

10.JPGMore details about the concat() function, please check the following article:

concat() function

 

 

Best regards,

Kris

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Send email notification with new folder URL when new folder is created

Hi @Anonymous,

 

Could you please share a screenshot of your flow's configuration?

Do you want to make the output dynamic content (folder name) to be part of the URL that you mentioned?

 

If you want to make the output dynamic content (folder name) to be part of the URL that you mentioned, I think the concat() function could achieve your needs. I have made a test on my side and please take a try with the following workaround:8.JPGWithin Inputs fields of "Compose" action, type the following formula:

substring(split(item()?['Name'],'Report')[1],0,8)

Within Body field of the "Send an email" action, type the following formula:

concat('https://xxxxxx.sharepoint.com/sites/PowerApps/Reporting1/',outputs('Compose'))

Note: The 'https://xxxxxx.sharepoint.com/sites/PowerApps/Reporting1/' represents the SP library URL on my side, on your side, you should type the following formula:

concat('https://mycatalina.sharepoint.com/sites/NetworkEngineering/AppResponse%20Reports',outputs('Compose'))

The flow works successfully as below:9.JPG

 

10.JPGMore details about the concat() function, please check the following article:

concat() function

 

 

Best regards,

Kris

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

Re: Send email notification with new folder URL when new folder is created

Yes, would like to make the URL dynamic.  Realized when the folder is getting created, it's adding 2 spaces at the begining of the folder name.  How can I create the folder Name without adding 2 spaces at the begining of the folder, below is a copy of the flow.

 

AR-Flow.png

The expression in the folderName (Compose) action is as follows:  substring(split(item()?['Name'],'Report')[1],0,8)  

 

I have also tried the following expression in folderName and it still adds 2 spaces in front of the name of the folder:  substring(first(skip(split(outputs('Compose'),'Report'),1)),0,8) 

 

 

Here's the Output where it's putting 2 spaces at the beginning of the folder Name:

AP-Output.png

 

Here's the URL it created with the new folder (notice the %20%20 towards the end of the URL):

 

'https://xxx.sharepoint.com/sites/NetworkEngineering/AppResponse%20Reports/Forms/AllItems.aspx?newTar...20%2020180531 '

 

'

Anonymous
Not applicable

Re: Send email notification with new folder URL when new folder is created

Ended up redoing the flow and got it to work using the solution you provided.  Here's a screen shot of the flow.

 

Finalflow.png

Anonymous
Not applicable

Re: Send email notification with new folder URL when new folder is created

Thank you for your help!  apprecicate it!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,961)