Create Relation Between Custom Columns in Sharepoint List and Library

[davaakhuu]

Hello, 

Is it possible to create a relation between a column value in sharepoint list and a column value in sharepoint library? 

What I want to do is to update multiple columns in the sharepoint list whenever items are created in different folders in a library. 

I have a column with a unique number for each sharepoint item, this number is also recorded in different types of files in the folders of a library as a custom column. 

So that when a file is uploaded to folder "Invoice" with this number, the column "Invoice" on the sharepoint list item gets updated to "Completed" etc. this process has to apply to different columns and folders. 

Thanks! 

[Reimi · Accepted solution]

Hi, @davaakhuu 

Does the solution below meet your needs?

Create a following flow for each folder (like "invoice", etc)

1. When a file is created in a folder
   set the "Invoice" folder
2. Get items
   Set the list you want to update
3. Apply to each item in step 2
1. If the unique number of item in step2 equal to the unique number of item in step1
   Update status
2. Else
   Nothing

Thanks,

[davaakhuu]

Thanks a bunch, very straightforward! This makes life much easier 🙂