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!
Solved! Go to 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 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)
thank you @jinivthakkar , I tried making a flow but seems the condition is always a false. Can you possibly help in this?
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! 😄
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
12 | |
11 | |
9 | |
9 | |
6 |
User | Count |
---|---|
25 | |
21 | |
17 | |
8 | |
8 |