When copying or moving a SharePoint file within a Flow, is it possible to retrieve the name of the SharePoint site so it can be inserted in an email?
Retrieving the Name of the SharePoint Site is not supported in microsoft flow currently.
I afraid that there is no way to achieve your needs in Microsoft Flow currently.
If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
There is a workaround, it is true there is no out of the box action to get the site title but you can use the sharepoint online rest api to acomplish the task. There is an action to send an HTTP request to SharePoint and you have to use your SharePoint site URL + /_api/web/title
Here is the way to do it based on the solution in @Mjcostarella post:
The above should work if you are acting on items in a SharePoint list (such as "When an item is created"). It will automatically grab the site address without having to pick it from the drop down. It then sends the HTTP request. Once it gets the Site's title, it throws it into a variable. The notes in each block tell you what to put in their respective fields as an expression.
For the first block, the Site Address gets set to:
For the second block, the Value gets set to:
Note: "Send_an_HTTP_request_to_SharePoint" in the above is highly dependent upon the name of the first block. If you decide to rename the first block from "Send an HTTP request to SharePoint" to "Get Site Title", then you must use the following for the value in the initialization block:
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.