cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
flyingspoon
Regular Visitor

Attaching link to SharePoint document from a SharePoint document library to an email

Hi everyone,

 

I have a recurring (every day) flow set up that gets items from a SharePoint list that are +120 days and +90 days out and send an email with the title of the document and also the review date. 

 

I'd like to add to this flow such that it will include a link in the email to the document itself. The documents are stored in a document library located within in the same SharePoint site as the list.  The title of the document may or may not exactly match the document name in the document library. Also, the name of the document library is Policy-Working Documents and documents reside in a sub folder within the document library titled In Process.

 

For example, the list may have a document title "Employee Favorite Food" while the document library may have the title as "ABC-P10-0123 Employee Favorite Food.docx". Is there a way to account for slight discrepancies in the document title name?

 

Pictures of Current Flow:

 

flow1.png

 

flow2.png

 

 

 

 

 

4 REPLIES 4
Hardesh15
Super User II
Super User II

@flyingspoon 

 

Yes you can try with condition with logic-contains.

Hardesh15_0-1602251419233.png

i just demonstrate how you will use condition. In left side use your Document title(library)  and in right side Document Tile (List).

Thanks

Hardesh

 

@Hardesh15 

 

Where in the Flow would the Condition need to be placed? Within the Apply to Each before Send an Email? 

 

Also, I am not sure how to indicate within the Condition on the left side that the Document Name variable should come from the document library since the Condition is based on the Value output from the previous Get Items step. Is there an additional step in Dynamic Content for this that I am just not seeing?

 

The list is named Policy Inventory. 

The document library is named Policy-Working Documents and the documents reside within a sub folder named In Process.

 

Thank you!

 

 

@flyingspoon 

 

Within the Apply to Each before Send an Email. You need to use action-Get files inside apply to each before send email. After Get files action use condition and compare your document title then send email.

 

Thanks

Hardesh

@Hardesh15

 

Within the Condition, how would I indicate that I want the Condition to look at the document names within a specific document library sub-folder.

 

  1. The document library is named Policy-Working Documents
  2. There is a sub-folder within the document library that has the documents. The condition should look for the document name within the document library sub-folder named In Process.
  3. I will add Send an email to the If Yes side of the condition and within that email will be a link to the document from the sub-folder in the document library.

How should I represent this in the Condition "Choose a value" field?

 

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (55,301)