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
Highlighted
Community Support
Community Support

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
Highlighted
Community Support
Community Support

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

Highlighted
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 '

 

'

Highlighted
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

Highlighted
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
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (6,681)