You’re offline. This is a read only version of the page.
Announcements
I've got two sharepoint lists that I need to establish a flow between but I'm struggling with the unique ID needed.
I've created a form which populates List 1 and have successfully set up a flow between List 1 and List 2 using 'when an item is created' trigger.
When I've tried to set up either an additional flow using the 'when an item or file is modified' trigger to update List 2 or set up one joint flow using the 'when an item is created or modified' trigger I keep hitting a problem when I need to input the unique ID in the 'Update Item' step. I keep using the 'UniqueID' dynamic content but it then changes it to 'UniqueID0' when I save it and then it fails. Both lists have a Unique ID column which share the same figure when created. I've tried adding a 'Get items' step and I've tried things like Unique ID eq' (dynamic content UniqueID) but nothing seems to work!
When I first set up and tried the flows it worked because it was based on the ID column sharepoint automatically populates, however when one of my test flows failed the numbers became out of sync so the update flow stopped working so I don't really want to rely on that column if possible.
Hi @JB32 ,
In Update item action, the Id field need to be populated using the default ID column value. So, when item modified in list1, to update corresponding item in list2, the flow would be:
In addition, to sync the two lists you will need three flows, one for syncing of creation, one for modification and the other for deletion.
Best regards,
Share
Report
All responses (
Answers (
525
