How to do a lookup from files from a sharepoint folder to an excel file

[CatPagulayan]

Hi All,

Good day. Not sure if this question is already taken up in this forum. But I have an excel list with billing document numbers and I would want to verify or check if those billing documents are already uploaded in a sharepoint folder.

So the idea is, when there is a pdf document uploaded in a sharepoint folder, example is with filename 1234.pdf, it should look in an excel list and put some verification that it is uploaded.

This is an excel list sample:

Billing Document	Uploaded in sharepoint
1234	Yes
5678	(either no or blank)

appreciate the help to make a flow for this.

thanks in advance!

[jinivthakkar · Accepted solution]

@CatPagulayan I think this can be done, you can have a trigger on when a file is uploaded and then get the filename(eg. if file was 1234.pdf, get only 1234) then iterate through excel table(list rows present in a table action) and if filename is equals to column name in excel, update row value to yes(update row action)

[CatPagulayan]

thank you @jinivthakkar , I tried making a flow but seems the condition is always a false. Can you possibly help in this?

[jinivthakkar]

@CatPagulayan 

Instead of value, check if you are able to see column name in dynamic content : 

[CatPagulayan]

Hello @jinivthakkar ,

I have also tried all of the available columns there but to no avail. Still it shows as failed. Anyway, I did something instead, I changed my flow to simply add the filename information in another table, and then the main table will simply have a vlookup 🙂

Nevertheless, you have been really helpful and will accept your initial message as the solution. Thanks very much!! appreciate it! 😄