Send email notification when new folder is folder is created

[Anonymous]

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.  

Output:

[v-xida-msft · Accepted solution]

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:Within 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:

More details about the concat() function, please check the following article:

concat() function

Best regards,

Kris

[Anonymous]

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.

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:

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]

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

[Anonymous]

Thank you for your help!  apprecicate it!