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:
Solved! Go to 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:
Best regards,
Kris
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:
Best regards,
Kris
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 '
'
Ended up redoing the flow and got it to work using the solution you provided. Here's a screen shot of the flow.
Thank you for your help! apprecicate it!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
27 | |
26 | |
25 | |
13 | |
12 |
User | Count |
---|---|
62 | |
50 | |
30 | |
29 | |
26 |