0

When a user insert a new row into a SharePoint list. That row will be copied into another list with Power Automate.

Only the id of the rows are different. Is it possible to change the id of a row?

Improve this question

2 Answers 2

Reset to default
1

You cannot change the SharePoint default ID column in list.

Instead you can follow below steps, assuming you already have a Power automate flow running on item creation in 1st list (List A):

  1. Create a new column in 2nd list, say ListAItemID.
  2. In "Create item" action which is used to create item in 2nd list, you can set ListAItemID column with dynamic content (ID) from 1st list like:

enter image description here

Improve this answer
1

Even if it is possible, it isn't wise to change the internal ID of a SharePoint object. You should make an additional column with a "ReferenceID" or something. Just use that when you need to cross connect the 2 lists.

Improve this answer
4
  • So it is possible to create another column in list2 with the id of the row of list 1 ?
    – user1903995
    Mar 4, 2022 at 18:28
  • I have done it on prem. I can't imagine why not online. I even had it link back to the original list item.
    – Jammin4CO
    Mar 4, 2022 at 18:29
  • Can you show me how? gr. p
    – user1903995
    Mar 4, 2022 at 18:33
  • Maybe similar to this. I don't have a way to show you. powerusers.microsoft.com/t5/Building-Flows/…
    – Jammin4CO
    Mar 4, 2022 at 19:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.