Jun 22 2021 10:12 AM
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.
Jun 22 2021 11:02 AM
@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:
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.