copy one column value from one SharePoint list to another SharePoint list

[sam123123123]

Hi,

I wonder how I can copy one column value from SharePoint list A to another SharePoint list B when the user inputs the column value in SharePoint list A, it automatically copies to SharePoint list B. After this, How can I set column formatting so that the user can click the item button in SharePoint list A to SharePoint list B based on the previously copied value which is their common property? Thanks!

[FLMike · Accepted solution]

@sam123123123 

Let's break this down and please follow the steps 1 by 1 even if you aren't sure exactly how it works, so that you can get it into a working flow or where I can help more.

I wonder how I can copy one column value from SharePoint list A to another SharePoint list B when the user inputs the column value in SharePoint list A, it automatically copies to SharePoint list B. 

• Create an Automated Flow
• Select the SharePoint Trigger action "When an item is created or updated"
• 
  • Configure it to point to SharePoint List A

  • When this triggers, it will have the data for the Item that has been changed in SharePoint List A.

• Add a Get Items SharePoint Action
• 
  • Configure it to retrieve the Row in SharePoint List B by adding a Filter expression, under Advanced Option in the Action, so that it only returns back 1 or 0 rows
    • NOTE: You cannot use the Get Item because you don't know the Row Id in the SharePoint List B which is required to retrieve the exact row you want, so you have to use Get Items
    • If your query expression is solid, you will only get back your intended 1 row, or 0 rows
• Add a Condition expression to verify that our Get Items either returned 1 or 0 rows
•  
  • In the left side put the following expression: length(In here select the value/body Dynamic Property of the previous Get Items)
    • To do this, select the left box in the condition. When the pop up appears, click on the Expression Tab
    • 
    • type length() with no space between the ()
    • Without closing the Popup window click on Dynamic Content
    • Click in between the two parans () , do not add a space just put the cursor between them
    • Scroll down until you see the Get Items dynamic properties from the previous step
    • Click on the body/value (you want the value, but i cant remember atm if its listed just as value or body/value)
    • This will insert the dynamic expression for you
  • in the middle select is equal to
  • on the right put 1
  • This will make it check to see if you received 1 row or 0. 
    • NOTE this will only work if you are certain your filter expression in Get Items only returns 0 or 1
• Add an Apply to Each action in the Yes Side
  • Set the input to the body/value of your Get Items 
  • Even though you only expect 1 row, you still use this to get to it
• In the Yes Side use an Update Item SharePoint Action, and get the Id from the CurrentItem of Apply to Each
  • Set it to point to SharePoint List B
  • Set the values you want updated and you would use the Dynamic Property of the Get Response Details right after the trigger, to retrieve the value from the changed item in List A
  • Add the value to the Column in the Update Item of List B

Done

Now for this one

After this, How can I set column formatting so that the user can click the item button in SharePoint list A to SharePoint list B based on the previously copied value which is their common property? Thanks!

I am not sure what this means, what button? Are you saying you want a hyperlink from List A that opens List B?

This is a SharePoint question really and should be posted in the SharePoint forums

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[FLMike]

Hi @sam123123123 

If my answer has helped you marking it as Accepted would be great. If you have any questions let me know. Marking them also helps others for searching.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey