Forum Discussion
Using Power Automate to create a new item in SharePoint if the total Qty is not matched.
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 orig...
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:
- You can add conditions to check if both "approved or shipped Qty" & "requested Qty" are not empty & does not match
- 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.