Answered

SharePoint List - when a specific column of the item is updated, create duplicate of the item on another SharePoint list, and delete the item from the original list

(0) Share

Report

Posted on by murtaza5

I have a list called SUList and SUListClosed. What I want to achieve is, when an item is modified with a condition that only Feedback column has value, the item will be duplicate to list called SUListClosed, and then delete the original list from SUList. I don't get the logic on how to create the flow. Appreciate if anyone can share what is the trigger and action to be used in this flow.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

v-mengmli-msft on at

Like (0)

Report

Hi @murtaza5 ,

Please try this.

Best regards,

Rimmon

Was this reply helpful? Yes No
murtaza5 47 on at

Like (0)

Report

Hi @v-mengmli-msft,

This is when any column is being modified. I want the flow trigger only when specific column called Feedback is modified. If other than Feedback column, it will not trigger the flow.

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft on at

Like (0)

Report

Hi @murtaza5 ,

You can add Get changes and Condition to do this.

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept it as a solution.

Best regards,

Rimmon

Was this reply helpful? Yes No
murtaza5 47 on at

Like (0)

Report
Hi @v-mengmli-msft, thank you so much! But now I have a problem when want to include an attachment as well. Below is my scheme, but I got an error of "Invalid type. Expected Array but got Boolean."

{ "type": "array", "items": { "type": "object", "properties": { "name": { "type": "string" }, "link": { "type": "string" }, "id": { "type": "string" }, "type": {}, "size": { "type": "integer" }, "referenceId": { "type": "string" }, "driveId": { "type": "string" }, "status": { "type": "integer" }, "uploadSessionUrl": {} }, "required": [ "name", "link", "id", "type", "size", "referenceId", "driveId", "status", "uploadSessionUrl" ] } }

Was this reply helpful? Yes No
murtaza5 47 on at

Like (0)

Report

Hi @v-mengmli-msft, I don't need to use Parse JSON. Just use Get Attachment action.

Was this reply helpful? Yes No