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)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@lasher18

Are all the files pdf files or does it vary?

Was this reply helpful? Yes No
lasher18 18 on at

Like (0)

Report
Copy link

Link copied!

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,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

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
Copy link

Link copied!

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,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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