cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
davaakhuu
Frequent Visitor

Create Relation Between Custom Columns in Sharepoint List and Library

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! 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reimi
Community Support
Community Support

 

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,

View solution in original post

2 REPLIES 2
Reimi
Community Support
Community Support

 

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,

View solution in original post

davaakhuu
Frequent Visitor

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

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,018)