Looking Up by ID in flow

(0) Share

Report

Posted on by lasher18

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)

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@lasher18

Are all the files pdf files or does it vary?

Was this reply helpful? Yes No
lasher18 18 on at

Like (0)

Report

They are all pdf files. So I am extracting the ID from the title with first(split(variables('MyString'),'.'))

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@lasher18

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.

Was this reply helpful? Yes No
lasher18 18 on at

Like (0)

Report

So I get the name of the file to lookUp. How can I now reference the column I want to look up? The column ID inside that file. And after that, how can I match that ID with the one in "ID.pdf" file?

Was this reply helpful? Yes No
lasher18 18 on at

Like (0)

Report

Please, help! I just want to match ID from a list to ID found in "example@mail.com#ID"

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@lasher18

Can you paste a screen shot of what your data looks like in Excel? Also, the data in Excel must be in a table.

Was this reply helpful? Yes No