Using Power Automate to create a new item in SharePoint if the total Qty is not matched.

New Contributor

How can I create a flow in Power Automate or use conditional formatting in SharePoint to create a new item/separate line if the result in one column, "approved or shipped Qty" does not match the original input of "requested Qty". So the balance of what was not approved/shipped is then input into a new line/ new row as its own requested qty. 


Thank you. 

1 Reply

@ldurbin This is not possible using conditional JSON formatting in SharePoint.


You have to run the flow using when item is modified trigger on SharePoint list:

  1. You can add conditions to check if both "approved or shipped Qty" & "requested Qty" are not empty & does not match
  2. If Yes --> Create new list item in same list with difference

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.