I have the following list and document library in the same SharePoint site (sample data provided, actual list and document library have more entries):
SharePoint List (Policy Inventory):
SharePoint Document Library (Policy-Working-Documents):
My current flow filters for items in the list with a review date that is +120 days from today, then it gets the files from the document library sub-folder named Test-Folder.
I am really struggling with the following:
Filtering the Get Files output keeping only the files with a Name that is also contained in the output of Get Items?
Send an Outlook email that contains the documents that satisfy #1 as an attachment or link. The body of the email should include the Document Name and Review Date which are provided in the Policy Inventory list.
My current flow:
I was thinking of somehow using Apply to each with a condition to see if the Name in the document library is contained in the Get Items output then send an email and within the email attach the document, but it's just not working for me.