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:
Yes you can try with condition with logic-contains.
i just demonstrate how you will use condition. In left side use your Document title(library) and in right side Document Tile (List).
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.
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.
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.
How should I represent this in the Condition "Choose a value" field?
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.