When Sharepoint Item specific column amended, Create new sharepoint item in another list

(1) Share

Report

Posted on by LM-01081535-0

Hi, I'm fairly new to Power Automate, learned alot and used the AI but i just can't get this flow to work, what am i missing. I can get it to create the sharepoint item in the other list when an item is amended generally, filling out the correct colomns with the right data. But when i add the condition to only act if the item is amended to "ordered" it doesn't work.

I've used the condition "and" True, Status (my column name) is equal to "ordered" (the choice in that column) and for False i have Terminate with a canceled status for the automation but nothing other than canceled comes through when i test.

Can anyone help please, I've attached a screenshot (I'm a little embarrassed at the simplicity, as looking at all the other questions please have asked the suggested automations look very complex.)

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

AnthonyAmador 2,557 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

It seems like I can’t download your attachment. Could you paste a screenshot of your flow so I can better understand your logic?

Thanks,
Anthony.

Was this reply helpful? Yes No
Suggested answer

AnthonyAmador 2,557 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

I got your attachment now. What exactly is the error are you seeing?

Can you verify that the value in your column Status and ‘Ordered’ are exactly the same? Any minor differences, like capital letters or other variations (such as spaces at the end), will cause it to return false.

Hope this helps.

Anthony.

Was this reply helpful? Yes No
Suggested answer

David_MA 15,205 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
I am not sure I fully understand the issue. Do you just want to create an item in some other list when the current item is modified, and the status is equal to ordered? If so, you should change your trigger condition to When an item or a file is modified. That will ensure it does not run when the item is first created. Then, so the flow only runs when status is ordered, add a trigger condition rather than a condition. This prevents the workflow from even running when it is any other status. You add the trigger condition to the trigger by going to its settings.

To write, the trigger, add a compose action and write an expression that evaluates to true or false that meets the criteria. A flow will only trigger when all trigger conditions evaluate to true. For you flow, you would use:

@equals(triggerOutputs()?['body/Status/Value'],'Ordered')

Note, when you create the expression in a compose action, it would not begin with the @ symbol. You just need to add that before the expression in the trigger. It will look like this when configured:

If the item is modified again and the status is still ordered, the workflow will run every time it meets this condition and continue adding items to your other list. I cannot imagine that is what you would want. If so, you could add a field to the list where the flow triggers called Ordered Item Created that is a true false field. You would add a second trigger check that Ordered Item Created is equal to false. Then when the flow runs, you would update it to true so it doesn't run again.

Was this reply helpful? Yes No
LM-01081535-0 8 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for your replies, I'll take a look at the trigger condition, just incase here is the screenshot of the flow

Was this reply helpful? Yes No
LM-01081535-0 8 on at

Like
a
(0)

Report
Copy link

Link copied!

The above solution worked but i wondered would anyone be able to suggest a change to the flow that it checks if the line exists already in the other sharepoint list and amends that, and only creates a new line when it doesn't exist in the second list. We're getting some duplicated lines when something in the original list is amended.

Was this reply helpful? Yes No