Answered

Automate - Move completed item to new list

(0) Share

Report

Posted on by jessicamclaugh

What am I doing wrong?? I am trying to move items that are completed to a new list. The new list has all the same headers for columns. I built a flow that when an item is modified or created and Status is equal to "Complete" then create new item (in the new list) and delete ID in the old list. Pic of flow attached... it is telling me that the flow runs successfully... but no data is in the new list and nothing is deleted from the old list.

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

schwibach 2 Moderator on at

Like (0)

Report
Copy link

Link copied!

Is the condition satisfied? Can you show a screenshot of the flow run?

Was this reply helpful? Yes No
jessicamclaugh 24 on at

Like (0)

Report
Copy link

Link copied!

It shows expression result as false... I guess that is the culprit, but I don't know what I'm doing wrong. The item is listed as "Status" there are 4 dropdown items "Not Started", "In Process", "Complete", "Canceled"
This is what I see on the flow run:
{
"expressionResult": false
}

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report
Copy link

Link copied!

Ok, so that's the issue. Without seeing the code and the action you are referencing,I could only guess what the issue is exactly.

Was this reply helpful? Yes No
jessicamclaugh 24 on at

Like (0)

Report
Copy link

Link copied!

Maybe my photo of the flow didn't show earlier? I attached it to the first post. Trying to attach it here again. The code only says the condition was not met... so not really anything to show. This is what the previous step code looks like:
{
    "host": {
        "connectionReferenceName": "shared_sharepointonline",
        "operationId": "GetOnUpdatedItems"
    },
    "parameters": {
        "dataset": "https://baycare1.sharepoint.com/sites/SystemLABQualityRegCompliance",
        "table": "d95e048d-894b-49cb-b366-409dc4059dd7"
    }
}

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (2)

Report
Copy link

Link copied!

Instead of just using Status in the condition, there should be a field called Status Value that you should be using.

Also, instead of creating a new file in the other library then deleting the existing one, there is an action called Move file that will just move the existing file to the new location. Have a look at it and see if it's what you are after here.

Was this reply helpful? Yes No
jessicamclaugh 24 on at

Like (0)

Report
Copy link

Link copied!

Ok, I will give those a try and report back here with what worked. Thanks!

Was this reply helpful? Yes No
jessicamclaugh 24 on at

Like (0)

Report
Copy link

Link copied!

Ok, I tried both options. The status value works best. The Move File isn't working, and I'm worried that it is trying to move the whole file rather than just the single item (and I'm not sure I set it up properly... would love to learn though!!). I attached a picture of the flow, when it fails it says "System cannot find the file specified".

For the status value option, I have one other issue: One of the fields that needs to be copied over is a "person" field. So, when it tried to move it, it is trying to move all the associated data that sharepoint has housed in our company for that person... I just need the person's name. Is there an expression that I can use to only have it look at the "displayname" and copy that over? Thank you for all of your input! I am very new to all of this and I'm learning a ton 🙂

Was this reply helpful? Yes No