You’re offline. This is a read only version of the page.
18
I have a list with ID's. Let's call it LINKS_LIST.
I need to link those ID's from LINKS_LIST to files titles contained in another folder.
The files in this folders are called like: "20.pdf" So the ID itself.
Example:
In LINKS_LIST I have one line with ID: 20.
In my folder I have a file called "20.pdf"
Lastly, I'd like to send that link (found in LINKS_LIST) associated with the ID by mail. (I have email adresses in my list, no issue)
Can you paste a screen shot of what your data looks like in Excel? Also, the data in Excel must be in a table.
First, use a concat() action with your expression to construct the file name - add .pdf.
Then, you'll need to use a Get Files (properties only) action with a filter query to find each file. Then, you can construct the URL from data available in Dynamic properties - you may have to hard code part of the URL.
Here is a link that explains how to construct the filter query.
Spoiler - you need to use FileLeafRef instead of Name in the filter query.
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
